Create a new view that holds the data with DOB after 2000, this view should include the WITH CHECK OPTION Now try to insert a new record in this view Try 1 record that has DOB before 2000 and one that has DOB after 2000 1 Write a create table command to create a relation that will hold the following data Driver Licence SSN First name Firs Last Name Date of Birth State AB17893 9820124 Harvey Goldberg 01 01 1982 OH CD17673 8975382 Paul Maxwell 02 10 1974 GH92641 7394104 Peter Feynman 05 17 2005 VH02378 1325639 Sally Maxwell 07 22 2000 ID820381 1325640 Sally Feynman 09 01 2013

Question

Create a new view that holds the data with DOB after 2000, this view should include the WITH CHECK OPTION  Now try to insert a new record in this view  Try 1 record that has DOB before 2000 and one that has DOB after 2000  1  Write a create table command to create a relation that will hold the following data  Driver Licence SSN First name Firs Last Name Date of Birth State AB17893 9820124 Harvey Goldberg 01 01 1982 OH CD17673 8975382 Paul Maxwell 02 10 1974 GH92641 7394104 Peter Feynman 05 17 2005 VH02378 1325639 Sally Maxwell 07 22 2000 ID820381 1325640 Sally Feynman 09 01 2013

Accepted Answer

The Answer is in the image, click to view ...

Question

Create a new view that holds the data with DOB after 2000, this view should include the WITH CHECK OPTION. Now try to insert a

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question