Business Admin

Barb Gordon

Abstract:

Royal Realty Services and Loans is a rapidly growing small business located in Southern California. Founded in 1996, Royal Realty Services and Loans specializes in providing loans and escrow services to a wide range of customers.

When Royal Realty opened its first store back in 1996, Windows 2000 was chosen as the operating system for all computers. While this initially proved to be an adequate solution, it has since outgrown its usefulness. Now with three stores, a new operating system must be put into place.

One of the most detrimental problems with the Microsoft Access database is that it is limited to a file size of only 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 enough to pursue a better solution.

Another aspect of Microsoft Access that does not scale well is that it will not accommodate multiple users simultaneously. The database needs to be updated continuously by multiple users at each store. Running one instance of Microsoft SQL Server 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 Network (VPN) connections over the Internet. Updates to the database can be further streamlined by developing and utilizing a web based interface.

Analysis:

The best solution for Royal Realty Services and Loans would be to implement an enterprise level database solution. Microsoft SQL Server 2000 would be a great fit for the database needs of Royal Realty Services. Microsoft SQL Server 2000 will easily meet the current needs of Royal Realty Services and also meet their needs of the future as they continue their growth.

Existing Database Overview

Currently the Kudler database contains nine tables. Each table is designed

to support and facilitate the filling of orders placed...