Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Write a create table command to create a relation that will hold the following data Driver Licence SSN AB1789:3 First name Last Name Date

image text in transcribed

1. Write a create table command to create a relation that will hold the following data Driver Licence SSN AB1789:3 First name Last Name Date of.Birth State 9820124 Harvey Goldberg 01/01/1982 OH Maxwe 02/10/1974 CA Feynman 05/17/2005 HI Maxwell 07/22/2000 CA Feynman 09/01/2013 HI CD1767;3 8975382 Paul GH92641 7394104 Peter VH02378 1325639 Sally ID820381 1325640 Sally You will have to choose the datatype for each column. Also notice that 1. The Last Name cannot be NULL 2. The State column should have UD as default value 3. Driver Licence is the primary key 4. SSN should also be unique 2. Now insert the data 3. Write a command to update the record with Driver's Licence AB17893 to have NY as State 4. Now delete the record with SSN 1325640 5. Now update the two record with First Name Sally to have First Name Sal 6. Create a view that holds the CA records only 7. Insert a new record into the view. Does it also appear in the table? 8. Now alter the table to make sure that also First Name cannot be null 9. Now alter the table in order to add a new column named Points 10. Now complete the data of this new column so that everyone has 0 points except for Peter, who has 1 point and Harvey who has 2. Will you INSERT or UPDATE

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

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions

Question

How would we like to see ourselves?

Answered: 1 week ago