Question 6: LibraryBooks (Book-ISBN.Library _ID,Jite, lib address, book title, n

Question

Question 6: LibraryBooks (Book-ISBN.Library _ID,Jite, lib address, book title, no of copies) conhs FDs: Book-ISBN, Library-ID no,of copies Book ISBN book title Library-ID lib address lib addressCounty Book Library ID Hio adress Countybook tleno of copies ISBN 123 456 789 LI L21l Burnside L1 Multnomah C+ Prog Ave. | Washington Data Structures 3 23 Powell Blvd. Multnomah Intro. Databases 3 a) Which FD is not enforced in the database instance above? (1 point) b) Fix the data so the FD in point a is enforced. You only need to rewrite one row. (1 point) c) Write one SQL query to test if the FD (Book ISBN >book_title) is satisfied. The query should return an empty result if the FD is satisfied (enforced). (3 points)

Explanation / Answer

Answer

a). Library_ID --> lib_address functional dependency is not enforced in the database.

b). lib_address will same for each L1 (Library_id) , for enforced above functional dependency in given database.

So, New update Row will be, ( 23 Powell Blvd will replaced by 11 Burnside ) in new update row.

c).

Select Book_ISBN from LibrayBooks

group by Book_ISBN

having count ( distinct book_title )  > 1

789 L1 11 Burnside Multnomah Intro. Database 3

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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