ZuoTi.Pro
Question

Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0022 sher 一6) Boola-title → (2丿 ma dlue to Fos and3) b) Booh De cuis ane - Boob .htleうRubl sha, ßooh 冰 → LIST İhe too tables which ane um 20 C/ ) C Boo-H-le, fublishu , B‘。匂shfteList.hu 2.8 20 Book yhe 3)

4 6
Add a comment
Know the answer?
Add Answer to:
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Question: Consider the following relation for published books: BOOK (Book title, Author_name, Book_type, List_price, Author_affil, Publisher)...

    Question: Consider the following relation for published books: BOOK (Book title, Author_name, Book_type, List_price, Author_affil, Publisher) Author _affil refers to the affiliation of an author. Suppose the following dependencies exist Book_title Publisher, Book type Book-type → List-pricej Author name → Authoraffil - a. What normal form is the relation in? Explain your answer.

  • 1. Consider a Relation that holds attributes of courses and sections at a university: R =...

    1. Consider a Relation that holds attributes of courses and sections at a university: R = CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN, Semester, Year, Days Hours, RoomNo, NoOfStudents Assume that the following functional dependencies hold: • CourseNo → Offering Dept, CreditHours, CourseLevel • CourseNo, SecNo, Semester, Year → Days Hours, RoomNo, NoOfStudents, InstructorSSN • RoomNo, Days Hours, Semester, Year → InstructorSSN, CourseNo, SecNo Normalize Relation R upto 3NF. 2. Consider the relation for published books: Book = Book title, AuthorName,...

  • need help with question 5. 3- Consider the following relation for published books: BOOK(Book_ title, Author_name,...

    need help with question 5. 3- Consider the following relation for published books: BOOK(Book_ title, Author_name, Book_type, List_price, Author_affil, Publisher) Suppose the following dependencies exist: Book_title à Publisher, Book_type Book_type à List_price Author_name à Author_affil a. What normal form is the relation in? Explain your answer? b. Apply normalization until you cannot decompose the relation further. State the reasons behind the decomposition. 4- Consider the above question, write a program in python to create xml file for the decomposed BOOK...

  • Write a C program to create a list of books details. The details of a book...

    Write a C program to create a list of books details. The details of a book include title, author, publisher, publishing year, no. of pages , price Perform the following with respect to the list of books created Display all the details of books written by a given author. Sort the details of books in the increasing order of price. Display the details of books published by a given publisher in a given year. Sort the list of books in...

  • Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city) Given the following relation,...

    Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city) Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city)

  • Consider the following relation R, where {A, B} is its PK. Assume that R is in...

    Consider the following relation R, where {A, B} is its PK. Assume that R is in the first normal form (INF). R (A, B, C, D, E, F) Functional dependencies: FD1: BàC FD2: AàDE FD3: ABàF Why is this table not in 2NF? Specify which FDs make R violate 2NF. Normalize the data shown in this table to second normal form (2NF). Specify the primary and foreign key (if any) in each table of your 3NF relations. Normalize the data...

  • Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...

    Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes on the semantics of attributes are as follows: • Each project has a unique project ID (projID) and also has a title, type and manager. Each manager has a specialty project type. • A project often contracts jobs to contractors with start-date and end-date. Contracts are identified by contract numbers (contractNo), but contract details are out of the scope of...

  • Consider a relation R with ve attributes A, B, C, D, and E. You are given...

    Consider a relation R with ve attributes A, B, C, D, and E. You are given the following functional dependencies: A->B, BC->E, and ED->A. (a) List all keys for R. (10 points) (b) Is R in BCNF? If it is, explain why. If is not, decompose it into a collection of BCNF relations. (20 points) (c) Is R in 3NF? If it is, explain why. If it is not, convert it into a collection of 3NF relations. (20 points)

  • Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher,...

    Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...

  • Database Management ID Price 1 Author Richie Karen 10 2 4 Year 1955 1958 1959 Title...

    Database Management ID Price 1 Author Richie Karen 10 2 4 Year 1955 1958 1959 Title с JAVA Script Java C++ prolog Perl 20 10 5 6 Schwartz Ross Maria 1959 1972 20 10 7 Wall 1987 20 The above relation has information about different books. The table information is already saved as txt format in Moodle under the name Quiz2Data.txt. Using MySql on your computer do: Create a database Create a table with name book, then load Quiz2Data.txt (check...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT