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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
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 <NULL,'Planning'> into DEPARTMENT.
2- Which relational constraints would be violated if the following operation were
applied to the COMPANY database snapshot illustrated bellow?
Transcribed Image Text: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 <NULL,'Planning'> 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 <NULL,'Planning'> 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.
Transcribed Image Text: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 <NULL,'Planning'> 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education