Kudler Fine Foods Database Analysis Essay -- Business Database Invento

Kudler Fine Foods Database AnalysisOverviewKudler Fines Foods is a rapidly increment small business located in Southern California. Founded in 1998, Kudler specializes in providing quality gourmet foods to a wide range of customers.When Kudler opened its number superstar store back in 1998, Microsoft Access was chosen as the database computer program apply to track inventory, orders and customers. While this initially proved to be an decorous solution, it has since outgrown its usefulness. Now with three stores and a fourth due to open soon, a new database management system must be put into place. single of the most detrimental problems with the Microsoft Access database is that it is limited to a file coat of only two gigabytes. While this may initially seem identical a large files size, it can rapidly grow and eventually move on this maximum size in a relatively short nub of time. This one drawback alone is reason enough to pursue a weaken solution.Another aspect of Micr osoft Access that does not scale well is that it exit not accommodate multiple users simultaneously. The database needfully to be updated continuously by multiple users at each store. Running one instance of Microsoft SQL host 2000 in a centralized location could easily handle the database needs of all of the store locations. Connections to the database could be made via Virtual Private vane (VPN) connections over the Internet. Updates to the database can be further streamlined by development and utilizing a web based interface. The best solution for Kudler Fine Foods would be to implement an enterprise level database solution. Microsoft SQL master of ceremonies 2000 would be a large fit for the database needs of Kudler Fine Foods. Microsoft SQL Server 2000 impart easily get through the current needs of Kudler Fine Foods and also meet their needs of the afterlife as they continue their growth.Existing Database OverviewCurrently the Kudler database contains nine add-ins. Ea ch table is designedto support and facilitate the filling 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 mannerThe 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 Mixed 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 indoors 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. Groupi ng the users into roles, either boniface or database roles, allows a way to assign permissions to multiple users at one time. For example, a salesperson would not have the same permissions as a manager probably would.ConclusionThe changes and updates that we have outline throughout this composition would greatly improve and enhance Kudlers operations. This would be a a lot more effective, efficient database that would not only serve them well today, only when allow for growth for tomorrow.ReferencesDeveloper.com Retrieved on June 3, 2005, on the World Wide weathervane http//www.developer.com/tech/article.php/10923_721441_1