Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. (15 pts) Consider following relation for published books: Book_type List_price Author_affil Publisher BOOK Book title Author name FD1 FD3 FD2 Author affil refers to

image text in transcribed

1. (15 pts) Consider following relation for published books: Book_type List_price Author_affil Publisher BOOK Book title Author name FD1 FD3 FD2 Author affil refers to the affiliation of the author. Primary key is {Book_title, Author_name}. Functional dependencies are: FD1: Book_title -> Publisher, Book_type FD2: Book_type -> List_price FD3: Author_name -> Author_affil a. (5 pts) What normal form this relation in (1NF, 2NF, 3NF)? Justify your answer by describing violations of normal forms (if any). b. (10 pts) Describe steps to normalize this relation up to 3NF. For full points, show all decomposed relations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

6. Conclude with the same strength as in the introduction

Answered: 1 week ago

Question

7. Prepare an effective outline

Answered: 1 week ago