Question
Create MySQL ERD. 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
Create MySQL ERD.
| 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)
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Database Support For Data Mining Applications Discovering Knowledge With Inductive Queries Lnai 2682
Authors: Rosa Meo ,Pier L. Lanzi ,Mika Klemettinen
2004th Edition
3540224793, 978-3540224792
