Question: [ 4 pts ] Consider a general dataset with the same schema as you answered in the second question ( NOT specifically for the instance
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 threeattribute
primary key that will work for such a general dataset and briefly explain why it makes sense.
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 and
passport number TP
pts Provide a SQL statement that removes all records for international student from 'BUS' college.
pts Provide a SQL statement that updates the country of "Mandi Smith" to DE
pts Provide a SQL statement to add attribute 'visaExpiryDate' of type DATETIME to the relation.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
