Help

Problem 4 (10 points): Assume each teacher has a unique teacher identifier (TID). Also, assume each teacher can have multiple dependents, but those dependents first name will always be unique per teacher (but not necessarily unique across the whole table, i.e No teacher will have two dependents with the same first name but two teachers may have dependents named John). 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 not create any new columns. Show the attributes and a few sample records (enough to make your thinking clear)