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.
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.
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 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 Line table contains detail 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 Store Table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc.
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 purpose of the Tax Table is to provide tax rates applicable to orders placed at a given store.
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 in cash and partially by credit card.
Pivot Table Example
There are varying formats for pivot tables; however, this example has been provided in order to allow students to begin…