MORGAN IMPORTING PROJECT Suppose that you have been hired by Morgan Importing to
ID: 3683887 • Letter: M
Question
MORGAN IMPORTING PROJECT Suppose that you have been hired by Morgan Importing to create a database application to track stores, purchases, shipments, and shippers. Sometimes several items are purchased from a store on a single visit, but do not assume that all of the items are placed on the same shipment. You want to track each item in a shipment and assign an insurance value to each item.
A. Using your knowledge, create a data model for Morgan Importing. Name each entity, describe its type, and indicate all attributes and identifiers. Name each relationship, describe its type, and specify minimum and maximum cardinalities.
B. List any item in your answer to A that you believe should be checked out with Phillip Morgan and/or his employees.
MARCIA’S DRY CLEANERS CASE Suppose that you have been hired by Marcia’s Dry Cleaning to create a database application to track customers, orders, and items. Marcia also wants to start a Frequent Cleaner’s Club, whereby she will offer a 50 percent discount on every 10th customer order.
A. Using your knowledge, create a data model for Marcia’s business. Name each entity, describe its type, and indicate all attributes and identifiers. Name each relationship, describe its type, and specify minimum and maximum cardinalities.
B. List any item in your answer to A that you believe should be checked out with Marcia and/or her employees.
Explanation / Answer
Creating stores entity:
Name datatype Information
Store Id int primary key
Store name varchar
Store location varchar
Creating Items entity:
Name datatype Information
item Id int primary key
item name varchar
quantity int
store Id int foreign key
creating purchases entity:
Name datatype Information
Order Id int primary key
Date date
Quantity int
Shiping Id int foreign key
Creating purchased items entity :
Name datatype Information
Purchased item Id int primary key
Order id int foreign key
Store Id int foreign key
Creating shipment entity:
Name datatype Information
shiping Id int primary key
customer name varchar
customer address varchar
order Id int foreign key
creating shippers entity:
Name datatype Information
Shipper Id int primary key
Store Id int foreign key
Shiping Id int foreign key
Tracking number int
Creating relationships between entities:
stores and Items: one-to-many. Each store can have multiple items.
Items and purchases: many-to-many.
Purchases and shipment:one-to-one.one order will have one id
Shipment,shippers and stores:one-to-many.
____________________________________________________________________
Creating customers entity:
Name datatype Information
customer Id int primary key
customer name varchar
address varchar
Creating orders entity:
Name datatype Information
order Id int primary key
customer Id int foreign key
date date
amount int
discount numeric Precision=2
creating Items master entity:
Name datatype Information
Item code int primary key
Item desc varchar
Creating order items entity :
Name datatype Information
order item Id int primary key
Order id int foreign key
Item code int foreign key
Quantity int
Creating relationships between entities:
Customers and orders: one-to-many.
Orders and order Items: one-to-many.
Orders masters entity is independent
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.