phase_1_solution

phase_1_solution - 1 The ER diagram: (1) Inventory Domain :...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 The ER diagram: (1) Inventory Domain : book CD title ISBN publisher author album cdID studio artist product price weight pid warehouse m available n quantity location zip w-ID city street state contact phone fax manager
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Note: it is also OK to add the following structure to the solution of Inventory domain. It is OK to remove the attribute cdID.
Background image of page 2
(2) Billing Domain invoice invoice-ID date total price street city state customer name email credit card 1 place n exp date card# billing address zip city street state zip shipping address secure code paid by 1 has 1 n n product quantity pricePerUnit include m package Refer to shipping domain for detail of package packed n m n address zip city street state divided into 1 n Refer to inventory domain for detail of product name email phone package-id pid shipping method shipped by m 1 sname Refer to shipping domain for detail of shipping method Students also can have a 3-way relationship, among invoice customer and credit card It is OK to record customers’ name quantity With respect to Product/Item, the student could also model as the following:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

phase_1_solution - 1 The ER diagram: (1) Inventory Domain :...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online