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
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 dependent( at least partially) on this composite key, so the table is 1NF. Further analysis shows that InvDate is dependent on only part of the key( InvNum), and that unitPrice, PubCode, and BookTitle also depend on part of the key( ISBN13). A transitive relationship is also revealed: PubName truly depends on PubCode, which in turn depends on ISBN13.