Question

Question 4: E-R Diagrams-(10 marks Draw an E-R Diagram for the following situation: Employees (identified by EMP-ID, SURNAME, FIRST-NAME, and Date-of Birth) make many orders (identified by ORDER-NO, ORDER-DATE, DES, WUOTED-PRICE) for Customers (Identified by CUST-ID). The orders are for one customer at a time but a customer might have many orders. The orders create many requests (Identified by REQUEST-NO, START-DATE, END-DATE). Those requests might result in few jobs (identified by JOB-NO COST) and consequently will use different materials (identified by MATERIAL-ID MATERIAL-DES). The requests are made to one section but a section has many requests

Answer 1

r)4 TE istome emp o B ENDDATE Das MATERIA CoST DES CE ann 2019-5-4 18:45