Question: [ 4 pts ] Consider a general dataset with the same schema as you answered in the second question ( NOT specifically for the instance

[4 pts] Consider a general dataset with the same schema as you answered in the second question
(NOT specifically for the instance provided in the table above). Choose a reasonable three-attribute
primary key that will work for such a general dataset and briefly explain why it makes sense.
[2 pts] Provide a SQL statement for inserting a new record to the relation for a student named "Kate
Young" from ITA who is enrolled in "BUS" college "FIN" department with student number "18674" and
passport number "TP65462".
[2 pts] Provide a SQL statement that removes all records for international student from 'BUS' college.
[2 pts] Provide a SQL statement that updates the country of "Mandi Smith" to DE.
[2 pts] Provide a SQL statement to add attribute 'visaExpiryDate' of type DATETIME to the relation.
 [4 pts] Consider a general dataset with the same schema as

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!