Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Identify all the fields on the View Identify the unique key to find each instance of the view BID NAME ADDR DEPT Status TERM
Identify all the fields on the View Identify the unique key to find each instance of the view BID NAME ADDR DEPT Status TERM CallIDI ISBNI TITLE1 Publl Pricel Datel DueDatel HoldY/NI CallID2 ISBN2 TITLE2 Publ2 Price2 Date2 DueDate2 HoldY/N2 CallID3 ISBN3 TITLE3 Publ3 Price3 Date3 DueDate3 HoldY/N3 FIRST NORMAL FORM Remove repeating groups from the view for each instance of the key- ie for each BobcatID/each term (the unique key), what fields repeat more than once/twice SECOND NORMAL FORM Remove the partial dependencies you probably just created - ie what non-unique-key fields can you determine uniquely with only part of the key? THIRD NORMAL FORM Remove the transitive dependencies that are left- ie what non-unique-key fields can you uniquely determine without knowing any of the key?
Step by Step Solution
★★★★★
3.31 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started