Question #1 Assume your team members have used the Training Unit Client Characte

Question

Question #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:

Question #2 Apply normalization to the table your team has developed to remove repeating groups. Display your results.

Question #3 Remove transitive dependencies from your table and show your resulting database table.

Table name: CLIENT TABLE Column Name CLIENT ID (primary key) CLIENT NAME ADDRESS CONTACT PHONE NUMBER CLASS STAFF-SIZE TRAINING LEVEL EQUIP-QTY EQUIP TYPE EQUIP MODEL-YR Description 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 (Veterans 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 The type of medical machines (e.g., X-ray, MRI, CAT) The model and year of each medical machine

Explanation / Answer

Question #2

CLIENT(CLIENTID,CLIENTNAME,ADDRESS,STAFF-SIZE,CLASS,TRAININGLEVEL,EQUIP-QTY,EQUIPTYPE,EQUIPMODEL-YR)

Attributes CLIENTNAME,ADDRESS,STAFF-SIZE,CLASS,TRAININGLEVEL,EQUIP-QTY,EQUIPTYPE,EQUIPMODEL-YR are functionally dependent on CLIENTID but there are transitive dependencies like TRAININGLEVEL is functionally dependent on CLASS also,EQUIP-QTY,EQUIPMODEL-YR are functionally dependent on EQUIPTYPE also.

CONTACT(PHONENUMBER,CONTACT)

Question #3

CLIENT(CLIENTID,CLIENTNAME,ADDRESS,STAFF-SIZE)

CLIENTCLASS(CLIENTID,CLASS,TRAININGLEVEL)

CLIENTEQUIPMENT(CLIENTID,EQUIPTYPE,EQUIP-QTY,EQUIPMODEL-YR)

CONTACT(PHONENUMBER,CONTACT)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---