DATABASES MEMORANUDM essays

DATABASES MEMORANUDM essays Database Applications in the company Database in my company are used for several purposes. Because my company is a small retail store, it needs several kinds of information to collect and analyze. Right now, my company uses Microsoft Access for The company needs information about its customers, its inventory of products, its suppliers, orders, prices of the items, and item availability. Until recently, this information was collected and stored in paper files and folders. Although it was easy to store this information in folders, it also caused frequent delays in accepting the customer orders as it was often difficult to tell at the time of the customer order the price of the items, the availability of the products, and when it would be Presently with the use of the Microsoft Access databases in the company, the company has been able to make many decisions quickly as it can find the status of the customers, their orders, products, and shipping date in time. Besides, by using the database, the company can find every night how much inventory is sold and how much it needs to order (Haag, Cummings, and Dawkins, 1998). Through the use of databases, it has become quite easy for the company to track its inventory use and calculate the profits. The greatest advantages of the database model is that it is easy to use as it is built on a simple concept of representing information in two dimensional tables. Most of the employees working in the company can easily be trained to identify most of the common entities such as customer, order, inventory, supplier etc. By using the database, the company has been able to avoid a lot of duplication of the paper work processes and has been able to capture data with much more accuracy and details. My company is also making extensive use of databases for the development of the predictive models on consumer data. By ...