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

 

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

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!