D. Given below is the table of data for a library. First, determine which attrib
ID: 3739796 • Letter: D
Question
D. Given below is the table of data for a library. First, determine which attribute is the best primary key. Second, examine the table and indicate the anomalies that may occur with the original design of this database? Why? Third, normalize the table into the normal form to prepare it for use in a relational data base environment. Title Borrower FirstName LastName DateOut DateDue ID# Call# John James Mark Austin Wilson Ding S551442 K561.02 Soccer D221.67 US Presidents S702361 1264.89 HR Laws & 12-03-05 01-03-06 12-20-05 01-20-06 12-20-05 03-20-06 F012618 Regulations H122.34 Volcanoes K249.02Swimming M426.52Egypt K922.4 S702361 S002579 S002579 F012618 Wilson Sunder Sunder Ding James Freddie Freddie Mark 12-20-05 01-20-06 01-03-06 02-03-06 01-03-06 02-03-06 01-05-06 04-05-06 BadmintonExplanation / Answer
(i) Call# will be the best attribute for primary key.
(ii) In given table deletion anomally may occur in following situations:
by deleting one call# from table , leads to deletion about borrower details
similarly , by deletion of borrower details , leads to deletion of call#
(iii) To normalize, break it into following relations: R1(call#,title),
R2(call#,BorrowerID#,DateOut,DataDue),
R3(BorrowerID#,FirstName,LastName).
Primary key of R1: call#
Primary key of R2:call#
Primary key of R1:BorrowerID#
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.