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

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions

Question

1. Who should participate and how will participants be recruited?

Answered: 1 week ago