CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 40

retail store operation. The store sells books. Books have a 13-digit
International Standard Book Number (ISBN), a title, a publisher, and
a unit price. Invoices track sales of books. An Invoice contains one or
many line items, with each line item reflecting the sale of one or more
copies of a specific book. Every publisher has a company name, and a
publisher code.
InvNum ISBN13 InvDateBookTitlePubCodePubNameQtyunitPrice
1022 9781291940336 2015-03-09 MYSQL Functions 1001 Lulu.com 3
4.99
1022 9780321833877 2015-03-09 MySQL, Fifth Edition 1029
Addison-Wesley 5 33.95
1022 9781890774820 2015-03-09 Murach‘s MySQL, 2nd Edition 1032
Murach, Mike & Associates, Inc 2 48.95
1249 9781449374020 2015-02-22 MySQL Cookbook: Solutions for
Database Developers and Administrators 1118 O‘Reilly Media,
Incorporated 9 50.59
1249 9781449325572 2015-02-22 PHP & MySQL: The Missing
Manual 1118 O‘Reilly Media, Incorporated 6 29.95
1249 9781890774790 2015-02-22 Murach‘s PHP and MySQL, 2nd
Edition 1032 Murach, Mike & Associates, Inc 1 48.95
BookSales
1. Using the BookSales table structure shown above, draw the
dependency diagram, and show all dependencies, full, partial, and
transitive.
Figure 1 -solution 1