1. Apply normalization to the table your team has developed to remove repeating groups. Display your results.

2. Remove transitive dependencies from your table and show your resulting database table.

ery good things about your team from the peop in t even got some praise from isn't easy to please these days. Even he is see- Keep at it. sibilities. think you'll pu us together yet unless f in different directions again. I'm just teasing you HYPERCASE Questions about whether we are a family, a zoo, or a the time to start designing systems that fit us conference in Minneapolis, but when he returns you should have some database ideas worked up for Snowden and him to discuss. Use the table that appears in this exercise to complete the questions here long enough now to form those opinions. Ihope below. Assume that your team members have used the Training able. I think our famous Southern hospitality coupled Unit Client Characteristics Report to design this database table to ceably British sense of humor should help influence store the relevant information contained on this report. ou? I as so busy persuading you that we're worth 1. Apply normalization to the table your team has developed to t I almost forgot to tell you: Tom and Snowden have remove repeating groups. Display your results nk about moving toward a database of some sort 2. Remove transitive dependencies from your table and sho your resulting database table have this ready in the next two weeks? Tom is at a Table name: CLIENT TABLE Column Name Description CLIENTID (primary key) Mnemonic made up by users, such as STHSP for State Hospital The actual, full client name CLIENT NAME The client's address ADDRESS The name of the contact person CONTACT The phone number of the contact person PHONE NUMBER The type of institution (Veterans Administration hospital, clinic, other) CLASS Size of client staff (number) STAFF SIZE Minimum required expertise level of the staff (as defined by the class) TRAINING LEVEL The number of medical machines that the client has EQUIP-QTY The type of medical machines (e.g., X-ray, MRI, CAT) EQUIP TYPE The model and year of each medical machine EQUIP MODEL-YR n the designated category. Notice the prominence of the relationship between the and the use of the word development. The user can visually see the promi between the "license" and use of the word project. critical here category itself is especially analysis of as well system using must do is to demonstrate organization the value of sup- dentify and to the customer, surrounding are predict future trends in important element the desi the Remember is is not enough software. Incorpora you are systems e data into quantitative data. Instead, should also how are useful means to an end. So you results, used ns for how decision makers should view the results can be inm those