Create relational database tables and microsoft access data


Create relational database tables and Microsoft access data base for kudler frequent shopper program

Customer

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.

Inventory

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.

Item

The Item Table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store.

Order

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.

Order Line

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.

Store

The Store Table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc.

Supplier

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.

Tax Table

The purpose of the Tax Table is to provide tax rates applicable to orders placed at a given store.

Tender

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.

Attachment:- data.rar

Request for Solution File

Ask an Expert for Answer!!
Management Information Sys: Create relational database tables and microsoft access data
Reference No:- TGS01003374

Expected delivery within 24 Hours