FK CUSTOMER CUSTOMER ID CUSTOMER NAME strong CUSTOMER FNAME CUSTOMER DEPT CUSTOM

Question

FK CUSTOMER CUSTOMER ID CUSTOMER NAME strong CUSTOMER FNAME CUSTOMER DEPT CUSTOMER PHONE CUSTOMER EMA NVENTORY option MEDIA TYPE MEDIA STOCK QUANTITY NVOICE INVOICE NUM CUSTOMER ID FK INVOICE DATE STAFF SUBTOTAL AMOUNT TAX AMOUNT SHIPPING AMOUNT TOTAL AMOUNT PAYMENT INSTRUCTIONS MEDIA MEDIA TYPE COSTS strong MEDIA TYPE MEDIA SIZE PRICE EXTRA MEDIA AMOUNT FK MEDIA TYPE PROCESS FEE PRINTED AREA SIZE MEDIA PRICE MEDIA PRICE EXTRA MEDIA AMOUNT strong EXTRA MEDIA PRICE IS PART OF PROCESS FEE CREATES optional NVOICE DETAIL INVOICE NUM FK POSTER DESCRIPTION MEDIA TYPE strong INCLUDES MEDIA USED QUANTITY PRINTED AREA SIZE MEDIA PRICE ITEM TOTAL EXTENDS strong MEDIA SUBTOTAL EXTRA SUBTOTAL PROCESS FEE

Explanation / Answer

Yes, it is correct.But you can make it better by following changes.

1) You should have one more entity for Order(if mentioned in the requirement document) as well. Because first you take order and after processing the order, invoice will be generated.

2)And Creates relation between customer and invoice does not sound good , rather it should be between customer and order because invoice is generated by shop and the order is created on behalf of customer.

3)And also please check your Inventory entity, because from the storage efficiency point of view it is not a good design. Because for a particular media_type you can put its quantity in the media entity itself.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.