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.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Question
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.
Transcribed Image 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY