Question 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice...


Question 3<br>Draw a complete ER diagram using Crow's foot notation based on the given business<br>rules below:<br>A sales representative can write many invoices. (In a business environment, each<br>invoice represents a sales transaction. Given the

Extracted text: Question 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice represents a sales transaction. Given the "commission set" label, one might infer that the sales rep earns a commission on each sale for which an invoice is written) Each invoice is written by a single sales representative. A customer can generate many invoices. (Each time a customer makes a purchase of one or more items, and invoice is generated) Each invoice is generated by a single customer. Each invoice includes one or more invoice lines. (Each item purchased is recorded in an invoice line) Each invoice line is associated with one (and only one) invoice. Each invoice line records a single product. Each product can be recorded in many invoice lines. (If the inventory contains 100 hammers, each one may be sold and, therefore, each of those 100 hammers may at some point be recorded in an invoice line.) Include all the entities, attributes, relationships and cardinality.

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here