logical design of the database. Your ERD will use Crow‘ s Foot notation to denote the relationships between tables.
Sample Exercise, With Solution
Before completing your lab, please review this example problem. The diagram below is a partial depiction of a business spreadsheet for a 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