CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 30

evolving data model from First Normal Form (1NF), to Second Normal Form (2NF), and
finally to Third Normal Form (3NF). When the model has reached 3NF, you will
construct the Entity Relationship Diagram (ERD) depicting the 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
1. Using the BookSales table structure shown above, draw the dependency diagram, and
show all dependenci es, full, partial, and transitive.
Figure 1 -solution 1
Discussion: A composite primary key consisting of InvNum + ISBN13 can be
constructed, ensuring that all rows are unique. All remaining attributes are shown to be