1. Assume your team members have used the Training Unit Client Characteristics Report to design a database table to store the relevant information contained on this report, with the following result:
2. Apply normalization to the table your team has developed to remove repeating groups. Display your results.
3. Remove transitive dependencies from your table and show your resulting database table.

€œI hear very good things about your team from the people in Management Systems. You even got some hard-earned praise from Tom Ketcham who isn€™t easy to please these days. Even he is seeing some possibilities. I think you€™ll pull us together yet . . . unless we all go off in different directions again. I€™m just teasing you. I told you to think about whether we are a family, a zoo, or a war zone. Now€™s the time to start designing systems that fit us. You€™ve been here long enough now to form thoseopinions.

Transcribed Image Text:

CLIENT TABLE Column Name Description CLIENT ID (primary key) CLIENT NAME ADDRESS CONTACT PHONE NUMBER Mnemonic made up by users, such as STHSP for State Hospital The actual, full client name The client's address The name of the contact person The phone number of the contact person The type of institution (Veteran's Administration hospital, clinic, other) Size of client staff (number) Minimum required expertise level of the staff (as defined by the class) The number of medical machines that the client has CLASS STAFF-SIZE TRAINING LEVEL EQUIP-QTY EQUIP TYPE EQUIP MODEL-YR The type of medical machines (e.g. X-ray, MRI, CAT) The model and year of each medical machine