Question: Assume every student has a unique student id (SID). Also, assume each student can have multiple dependents, but dependents first name will always be

Assume every student has a unique student id (SID). Also, assume each student can have multiple dependents, but dependents first name will always be unique per student (but not necessarily unique across the whole table). The attribute in the table are SID, dependent first name, dependent last name, dependent date of birth (mmddyyyy), 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).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
