Hello There, This is discussion Question For Advanced Database Systems Question: Consider the relation:
View the step-by-step solution to:

Question

Hello There,

 

style="background-color:transparent;color:rgb(61,61,61);">This is discussion Question

For Advanced Database Systems

 

Question:  

Consider the relation: 

   BOOK(Book_title, Author_name, Book_type, List_price, Author_affiliation, Publisher_name)

 

    Primary Key: (Book_title, Author_name)

 

    FD1: (Book_title, Author_name) ( (Book_type, List_price, Author_affiliation, Publisher_name)

   

The following additional dependencies exist:

    FD2: Book_title ( Publisher_name, Book_type

    FD3: Book_type ( List_price

    FD4: Author_name ( Author_affiliation

 


    (b)Is the relation BOOK in second normal form? Why?

    (c)Is the relation BOOK in third normal form? Why?

(d) Improve the relation by breaking it down to separate relations, so that the whole design is in third normal form. For each relation in this improved design, please clearly indicate the relation name, the attributes, and have the primary key attribute(s) underlined. You CANNOT add new attributes or change the names of the existing attributes.

   

 

Thank you 

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Software engineering tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors