Database Analysis Paper

Database Analysis Paper Microsoft Access was chosen as the infobase political program use to track inventory, secernates and customers. piece of music this initi exclusivelyy proved to be an adapted solution, it has since outgrown its usefulness. One of the most detrimental problems with the Microsoft Access database is that it is peculiar(a) to a file sizing of only two gigabytes. While this may initially seem like a outstanding files size, it tail rapidly grow and eventually r each(prenominal) this supreme size in a relatively short total of time. This champion drawback alone is reason enough to pursue a crack solution. Another aspect of Microsoft Access that doesnt exfoliation well is that it will not accommodate multiple users simultaneously. The database postulate to be updated continuously by multiple users at each introduce. runway one instance of Microsoft SQL Server 2000 in a modify location could easily handle the database needs of all of the store loca tions. The best solution for Kudler Fine Foods would be to apply an enterprise level database solution. Microsoft SQL Server 2000 would be a large(p) live for the database needs of Kudler Fine Foods. Currently the Kudler database contains nine bring out panels. severally display board is designed to support and urge the filling of orders placed by customers in the stores.

Based upon the exposition of the tabularises that was posted on Kudlers intranet and our analysis, the panels may be describe in the following flair: The Customer table contains the data in this table is apply to access the name and steer of cu stomers for order processing and for partic! ular(prenominal) mailings for anniversaries and/or birth dates, etc. Each record in the customer table contains a customer field that is use to link the customer to the orders that they place. The Inventory table manages inventory and determine the availability of ingredients that go into prepared items, such(prenominal) as bakeshop products, etc. Each record in the inventory table is linked to the Item table by the item and to the Suppliers table by the supplier...If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper