Question: match A functional dependence criterion is fulfilled: 1 NF - compliant database structure. To achieve 3 NF - - compliant database structure, Jonny should eliminate:
match A functional dependence criterion is fulfilled:
NFcompliant database structure.
To achieve NFcompliant database structure, Jonny should eliminate:
Eliminate the Repeating Groups and create a new Location table with unique rows.
Which attribute will serve as the FK in the newly created Location table?
If each value of A determines one and only one value of B
To avoid unnormalized data in the Supplier table, reflected by multivalued attribute:
Jonny created a NFcompliant database structure.
Jonny redesigned the Supplier table to
Jonny placed the Memo field in the redesigned Location table.
Jonny removed City and State from the Location table and added a linked Zip table.
SupplierID
The existing Supplier table is in violation of
Transitive Dependencies.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
