Create relational database tables

Assignment Help Management Information Sys

Reference no: EM13750202

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

Reference no: EM13750202

Questions Cloud

Identify symptoms that suggest an underlying problem : What alternative solutions should be considered in solving this problem? How did you arrive at these alternatives?4. What are the advantages and disadvantages of these alternatives? Quantify where possible.

Describe teaching of hebrew wisdom on diligence and laziness : Describe the teachings of Hebrew wisdom on diligence and laziness. How does this correspond with the contrast between wisdom and folly? In your essay, include Scripture references and quotations as appropriate.

Implementation plan development : Individual: Implementation Plan Development-Design an application, presentation, or website site that presents and explains your Implementation Plan

As a continuation of the diversity training manual : As a continuation of the diversity training manual, you (as the new manager of human resources) should now create portions that specifically address gender issues and are targeted at training and raising the sensitivity of all supervisors regardin..

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

Write clearly and concisely about terrorism and antiterroris : Use technology and information resources to research issues in Terrorism and Antiterrorism - Write clearly and concisely about terrorism and antiterrorism using proper writing mechanics and APA style conventions.

Telecommunications technology products : The two enterprises are Apple Inc. and Samsung Electronics Company, Ltd, multinational makers of information and telecommunications technology products. Samsung is the current world leader in smartphone sales, while Apple is #1 in tablet computer ..

What was the basis for greek economy : What was the basis for Greek economy?

Explain the relationship between the indians and settlers : In a paragraph, tell me how the relationship between the Indians and settlers went from good to bad. Be sure to include the names Powhatan. John Smith and Pocahontas.

User Account

All Pages