The following tables are for bookstore database. A book is written by one or mor

Question

The following tables are for bookstore database. A book is written by one or more authors and is published by one publishing company. Each book has one title but it can have multiple formats (such as digital, paperback, hardcover). Price of the same book but different book format can be different. A book is uniquely identified by arn ISBN. The bookstore has four departments and employs a number of employees; each employee works in only one department. Each department has a manager BOOKS ISBN, Title, Author-Full-Name, Publishing-Company-ID) PUBLISHING COMPANY Publishing-Company-ID, Publishing-Company-Name) DEPARTMENT Dept-ID, Dept-Name, Manger-ID, Manager-Name) ENTK OVEE Emplovee.ID, Employee-First-Name, Employee-Last-Name, Dept-ID) BOOK PRICES ISBN, Book-Format, Book-Title)

Explanation / Answer

11. d. 3NF

Because this tables doesn't have any partial or transitive dependencies.

12. d. 3NF

Because this tables doesn't have any partial or transitive dependencies.

13. c. 2 NF
Because in this we are having transitive dependency which is Manager_ID is depending on Dept-ID and Manager-Name is depending on Manager-ID.

14. d. 3NF

Because this tables doesn't have any partial or transitive dependencies.

15. b. 1NF
Because it is having partial dependency . Book-Title is depending upon ISBN only not on Book-Format.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.