Answer the fowllowing questions :-( Only Handwritten, the name of the answer file is your university number and the exetintion is PDF, the time allawed is 24 hours (1 day) Q1:- 1- Find superkeys, candidate keys, primary keys, alternative keys in the following CAR relation schema? CAR (State, Reg#, SerialNo, Model, Year) 2- Find superkeys, candidate keys, primary keys, alternative keys in the following relation? A1 Hh 101 D10 10 A2 Mm 200 D30 20 АЗ Ff 50 D90 30 A4 LI 60 D53 30 A1 Ff 70 D6 10 Q2:- 1- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 1/12/1970 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Insert <123456, 'Rani', 123, 3/9/1985, '350OJD', 432, 10> into EMPLOYEE. 2. Insert <30,'Planning'> into DEPARTMENT. 3. Insert < 'Jasmine', 'Rani',NULL, 30/9/1977, '400OJD', 587, 10> into EMPLOYEE. 4. Insert into DEPARTMENT. 2- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? Q2:- 1- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 1/12/1970 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Insert <123456, 'Rani', 123, 3/9/1985, '3500JD', 432, 10> into EMPLOYEE. 2. Insert <30,'Planning'> into DEPARTMENT. 3. Insert < 'Jasmine', 'Rani',NULL, 30/9/1977, '4000JD', 587, 10> into EMPLOYEE. 4. Insert into DEPARTMENT. 2- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD | NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 |1/12/1970 | 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Delete the EMPLOYEE tuple with FName ='Smith' 2. Delete the EMPLOYEE tuple with SSN=432 3. Update the DNO of the DEPARTMENT tuple with DName ='IT' to 40. 4. Update the SSN of the EMPLOYEE tuples with FName ='Smith' to NULL.

Answer the fowllowing questions :-( Only Handwritten, the name of the answer file is your university number and the exetintion is PDF, the time allawed is 24 hours (1 day) Q1:- 1- Find superkeys, candidate keys, primary keys, alternative keys in the following CAR relation schema? CAR (State, Reg#, SerialNo, Model, Year) 2- Find superkeys, candidate keys, primary keys, alternative keys in the following relation? A1 Hh 101 D10 10 A2 Mm 200 D30 20 АЗ Ff 50 D90 30 A4 LI 60 D53 30 A1 Ff 70 D6 10 Q2:- 1- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 1/12/1970 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Insert <123456, 'Rani', 123, 3/9/1985, '350OJD', 432, 10> into EMPLOYEE. 2. Insert <30,'Planning'> into DEPARTMENT. 3. Insert < 'Jasmine', 'Rani',NULL, 30/9/1977, '400OJD', 587, 10> into EMPLOYEE. 4. Insert into DEPARTMENT. 2- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? Q2:- 1- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 1/12/1970 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Insert <123456, 'Rani', 123, 3/9/1985, '3500JD', 432, 10> into EMPLOYEE. 2. Insert <30,'Planning'> into DEPARTMENT. 3. Insert < 'Jasmine', 'Rani',NULL, 30/9/1977, '4000JD', 587, 10> into EMPLOYEE. 4. Insert into DEPARTMENT. 2- Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD | NULL 10 Susan 432 3/6/1982 1547JD 123 10 James Ford 587 20/9/1980 | 3650JD 983 20 Sali Miller 983 |1/12/1970 | 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT 1. Delete the EMPLOYEE tuple with FName ='Smith' 2. Delete the EMPLOYEE tuple with SSN=432 3. Update the DNO of the DEPARTMENT tuple with DName ='IT' to 40. 4. Update the SSN of the EMPLOYEE tuples with FName ='Smith' to NULL.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 11MC: Which of the following has no repeating groups but can contain partial or transitive...

See similar textbooks