Customer Cust-code (p.k) Cust-name Receipt Cust-phone Receipt code (p.k) Cust-address Date: Cust-code (fix) Receipt Item ITEM Payment mode Receipt code (p.k) Item-code(p.r) EMP num (f.k) Item code...

DATABASE SYSTEMS Exercise

TO-DO:

Please create an enhanced entity-relationship with ERD below, complete with participation and disjoint constraints.

Customer<br>Cust-code (p.k)<br>Cust-name<br>Receipt<br>Cust-phone<br>Receipt code (p.k)<br>Cust-address<br>Date:<br>Cust-code (fix)<br>Receipt Item<br>ITEM<br>Payment mode<br>Receipt code (p.k)<br>Item-code(p.r)<br>EMP num (f.k)<br>Item code (p.k)<br>Item-name<br>Total pay<br>Quantity<br>Unit price<br>Total price<br>Discount<br>EMPLOYEE<br>EMP NUM<br>EMP NUMBER<br>

Extracted text: Customer Cust-code (p.k) Cust-name Receipt Cust-phone Receipt code (p.k) Cust-address Date: Cust-code (fix) Receipt Item ITEM Payment mode Receipt code (p.k) Item-code(p.r) EMP num (f.k) Item code (p.k) Item-name Total pay Quantity Unit price Total price Discount EMPLOYEE EMP NUM EMP NUMBER

Jun 07, 2022

SOLUTION.PDF

Customer Cust-code (p.k) Cust-name Receipt Cust-phone Receipt code (p.k) Cust-address Date: Cust-code (fix) Receipt Item ITEM Payment mode Receipt code (p.k) Item-code(p.r) EMP num (f.k) Item code...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment