Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[ 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started