Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Question 1. Relational Model and Integrity Constraints.
(a) Can the following record be inserted into the BRANCH table? Why?
BRANCHNUMBE R
BRANCHNAME
B R A N C H S TR E E T
B R A N C H C I TY
B R A N C H S TA TE
B R A N C H ZI P
R E V E N U E T A R GET
B R A N C H M A N A GE R
b9
Branch9
E 241 52 St
New York
NY
11010
700000
e77
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
The referenced table does not contain the branch Manager e77
(b) Can the following record be inserted into the EMPLOYEE table? Why?
E M P L OY E E ID
E M P L N A ME
E M P F N A ME
e39
Joe
Smith
E M P TI TLE
E M P S T A R T D A TE
E MP BRANCH
E M P S A L A RY
E M P S U P E R V I SOR
06/23/2004
b19
450000
e2
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
(c) Can the following record be deleted from the INSTLINE table? Why?
OR D E R N U M B E R
I N S T T Y PE
H OU R S
o1
i1
20
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
It cannot be deleted since it’s a generated value> Its constrained by the relationship
(d) Can the following record be deleted from the EMPLOYEE table? Why?
E M P LOYEEID
E M PLNAME
E M PFNAME
E M P T ITLE
E M P STARTD...