Developing erd on basis of crows foot model|Computer Engineering
1) Assume that you are currently considering the purchase of the client/server DBMS. What features should you look for and why?
2) “Develop an ERD based on Crow’s Foot model, utilizing the following requirements.
a) An INVOICE is written by a SALESREP. Each sales representative may write several invoices, however each invoice is written by the single sales representative.
b) The INVOICE is written for the single CUSTOMER. However, every customer may have different invoices.
c) An INVOICE may involve several detail lines (LINE) that explains the products bought by the customer.
d) The product information is stored in the PRODUCT entity.
e) The product’s vendor information is found in the VENDOR entity.
