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 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
Get step-by-step solutions from verified subject matter experts
