Kudler Fine Foods Database Analysis Essay -- Business Database Invento

Kudler Fine Foods Database compendOverviewKudler Fines Foods is a speedily growing small business located in Southern California. Founded in 1998, Kudler specializes in providing quality gourmet foods to a roomy range of customers.When Kudler opened its first store back in 1998, Microsoft access code was chosen as the selective informationbase platform used to track inventory, vows and customers. While this ab initio proved to be an adequate solution, it has since outgrown its usefulness. Now with three stores and a stern due to open soon, a new database management system mustiness be put into place.One of the most detrimental problems with the Microsoft Access database is that it is control to a file size of hardly two gigabytes. While this may initially seem like a large files size, it can rapidly grow and eventually reach this maximum size in a relatively short amount of time. This one drawback alone is reason copious to pursue a better solution.A nonher aspect of Micr osoft Access that does not scale well is that it will not accommodate multiple users simultaneously. The database require to be updated continuously by multiple users at each store. running game one instance of Microsoft SQL boniface 2000 in a centralized billet could easily handle the database needs of all of the store locations. Connections to the database could be do via Virtual Private Network (VPN) connections over the Internet. Updates to the database can be just streamlined by developing and utilizing a web based interface. The crush solution for Kudler Fine Foods would be to implement an enterprise level database solution. Microsoft SQL waiter 2000 would be a great fit for the database needs of Kudler Fine Foods. Microsoft SQL legion 2000 will easily meet the current needs of Kudler Fine Foods and alike meet their needs of the future as they continue their growth.Existing Database Overviewshortly the Kudler database contains nine t equals. Each table is designedto s upport and facilitate the fill up of orders placed by customers in the stores. Based upon the description of the tables that was posted on Kudlers intranet and our analysis, the tables may be described in the following lookThe Customer table contains demographic data for each of Kudlers customers. The data in this table is used to access the name and address of customers for order processing and for special maili... ... in Windows NT would automatically change and update the SQL Server password. If separate logins are desired, they will also be possible with the sundry(a) Authentication offered through Microsoft SQL Server 2000. The security settings will be able to be further customized by the use of permissions and roles. A permission allows a user to do something in spite of appearance the database, whether it is accessing and manipulating data or creating new objects within the database. These settings can be individualized, or given to a group of users by roles. Grouping t he users into roles, either server or database roles, allows a way to redact permissions to multiple users at one time. For example, a salesperson would not sport the same permissions as a manager probably would.ConclusionThe changes and updates that we pass outline throughout this paper would greatly improve and enhance Kudlers operations. This would be a much more effective, efficient database that would not only serve them well today, but allow for growth for tomorrow.ReferencesDeveloper.com Retrieved on June 3, 2005, on the World Wide Web http//www.developer.com/tech/article.php/10923_721441_1