Answered step by step
Verified Expert Solution
Link Copied!

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

[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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

Students also viewed these Databases questions