Question
g. Construct a new tuple that can be inserted into ASSIGNMENT without violating any constraints. h. Construct a new tuple that cannot be inserted into
g. Construct a new tuple that can be inserted into ASSIGNMENT without violating any constraints.
h. Construct a new tuple that cannot be inserted into ASSIGNMENT because doing so would violate referential integrity (but would not violate any other constraints)
i. Construct a new tuple that can be inserted into EMPLOYEE without violating any constraints.
j. Construct a new tuple that cannot be inserted into EMPLOYEE because doing so would violate a key constraint (but would not violate any other constraints).
k. Which tuples in PROJECT could be removed without violating referential integrity, and which tuples in PROJECT would cause referential integrity to be violated if they were removed?
lccIo Database Schema: DEPARTMENT (Code, Name, Building) EMPLOYEE (ID, First, Last, DeptCode) ASSIGNMENT (EmpID, ProjectNumber, Hours) Database Instance: DEPARTMENT Code 10 Building Name Administration Marketin Human Resources Product Development |B Legal 39 40 58 EMPLOYEE ID 3443 1087 6518 9220 First Luke Jessica Matt Dann Last DeptCode 39 39 Jones Murdock 58 Rand 10 ASSIGNMENT EmpID 3443 6518 3443 1087 Hours 20 10 20 15 ProiectNumberStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started