Q2: Consider the relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publish

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Q2: Consider the relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publish

Post by answerhappygod »

Q2 Consider The Relation For Published Books Book Book Title Authorname Book Type Listprice Author Affil Publish 1
Q2 Consider The Relation For Published Books Book Book Title Authorname Book Type Listprice Author Affil Publish 1 (28.56 KiB) Viewed 9 times
Q2: Consider the relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher), Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book-title→→ Publisher, Book_type Book_type Listprice → Authorname→→ Author_affil Answer the following questions i. What normal form is the relation in? Explain you answer [3pts] ii. Apply normalization until you cannot decompose the relations any further. State the reasons for every decomposition you perform
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”