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 ...view middle of the document...
Each table is designed
to support and facilitate the filling of orders placed by customers in the stores. Based upon the description of the tables that was posted on Kudler’s intranet and our analysis, the tables may be described in the following manner:
The Customer table contains demographic data for each of Kudler’s customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc. Each record in the customer table contains a customer_id field that is used to link the customer to the orders that they place.
The Inventory table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc. Each record in the inventory table is linked to the Item table by the item_id and to the Supplier’s table by the supplier_id.
The Item table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store. The Item table is linked to the Inventory table by way of the item_id and to the Order Line table by the item_id field.
The Order table is used to record information pertinent to each order placed with a given store. Each order will have one or more entries in the Order Line table associated with it. The Order table is linked to the Order Line table by the store_code and the order_id. It also links to the Customer table via the customer_id field.
The Order Line table contains details on items appearing on an order. One or more order lines are associated with each order and each order line references an item being purchased with its description, quantity, price, etc. The Order Line table is linked with the Order table by the order_id and the store_code. It also links to the Item table by the item_id.
The Store table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc. The Store table links with the Order table by the store_code.
The Supplier table contains data concerning wholesalers, vendors and other suppliers from whom inventory is procured. These goods are used to prepare saleable items or are simply resold in their acquired form. The Supplier table is linked with the Inventory table by way of the supplier_id.
The purpose of the Tax table is to provide tax rates applicable to orders placed at a given store. The Tax table is linked with the Order table by way of the store_code field.
The Tender table provides a means to record the methods of payment used for an order. For example, an order may be paid for partially by cash and partially by credit card. The Tender table is linked with the Order table by the store_code and the order_id.
Recommendations for Improvements and/or Enhancements
Based on the descriptions of the tables, it is recommended that the Kudler database undergo the following enhancements. The...