Question
1NF: ROYALTY(ISBN, Book Title, Author Num, LastName, Publisher, Royalty, Editing) PK: ISBN 2NF: ROYALTY(ISBN, Book Title, Author Num, LastName, Publisher, Royalty) AUTHOR(Author Num, LastName) PK:
| 1NF: | ROYALTY(ISBN, Book Title, Author Num, LastName, Publisher, Royalty, Editing) PK: ISBN |
| 2NF: | ROYALTY(ISBN, Book Title, Author Num, LastName, Publisher, Royalty) AUTHOR(Author Num, LastName) PK: ISBN (ROYALTY) PK: Author Num (AUTHOR) |
| 3NF: | ROYALTY(ISBN, Book Title, Author Num, Publisher, Royalty) AUTHOR(Author Num, LastName) PK: ISBN (ROYALTY) PK: Author Num (AUTHOR) The final ERD for the normalized ROYALTY relation would look like this: ROYALTY(ISBN, Book Title, Author Num, Publisher, Royalty) AUTHOR(Author Num, LastName) |
A MySQL ERD is required
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Creating an EntityRelationship Diagram ERD for the normalized ROYALTY relation in MySQL involves vis...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Using Excel & Access for Accounting 2010
Authors: Glenn Owen
3rd edition
1111532672, 978-1111532673
