Question: Help Problem 5 (10 points): Similar to Problem 4 but not identical. Assume teacher has a unique teacher identifier (TID). Also, assume each teacher can

 Help Problem 5 (10 points): Similar to Problem 4 but not

Help

Problem 5 (10 points): Similar to Problem 4 but not identical. Assume teacher has a unique teacher identifier (TID). Also, assume each teacher can have multiple dependents, but those dependents first name may or may not be unique per teacher. The attributes in the table are TID, dependent first name, dependent last name, dependent phone number, and dependent sex. What would the primary key be? Design the table accordingly, but you may create new columns. Show the attributes and a few sample records (enough to make your thinking clear)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!