QUESTION 1   The dependency diagram in figure below indicates that authors are paid royalties for each book that they write for a publisher.  The amount of the royalty can vary by author, by book, and by edition of the book.    Book royalty dependency diagram See attached for diagram  Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table     Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter3: Designing A Page Layout: Creating A Website For A Chocolatier
Section3.2: Visual Overview: Page Layout Grids
Problem 6QC
icon
Related questions
Question

QUESTION 1

 

The dependency diagram in figure below indicates that authors are paid royalties for each book that they write for a publisher.  The amount of the royalty can vary by author, by book, and by edition of the book. 

 

Book royalty dependency diagram

See attached for diagram 



  1. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table

   

  1. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

 

ISBN
BookTitle
Author Num
LastName
Publisher
Royalty
Edition
Transcribed Image Text:ISBN BookTitle Author Num LastName Publisher Royalty Edition
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning