Question: Applying normalization means first removing repeating groups. In this case, CLIENT-ID, CLIENT-NAME, CONTACTS, CLASS, and STAFF-SIZE would repeat for various EQUIP-TYPE. The resulting tables are:
Applying normalization means first removing repeating groups. In this case, CLIENT-ID, CLIENT-NAME, CONTACTS, CLASS, and STAFF-SIZE would repeat for various EQUIP-TYPE. The resulting tables are:
CLIENT CLIENT-ID (primary key) CLIENT-NAME ADDRESS CONTACTS PHONE-NUMBER CLASS STAFF-SIZE TRAINING-LEVEL EQUIPMENT CLIENT-ID (primary key) EQUIP-MODEL-YR (primary key) EQUIP-QTY EQUIP-TYPE
Step by Step Solution
★★★★★
3.41 Rating (164 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
In addition CONTACTS and PHONENUMBER would still be repeat... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help