Consider the following relational instances of EMPLOYEE and CHILDREN tables with primary keys underlined and foreign key

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Consider the following relational instances of EMPLOYEE and CHILDREN tables with primary keys underlined and foreign key

Post by answerhappygod »

Consider the following relational instances of EMPLOYEE andCHILDREN tables with primary keys underlined and foreign key shownby arrow. Assume the foreign key EmpID in CHILDRENtable has "on update cascade" and "on delete cascade"constraint.
Explain what constraints, if any are violated when one attemptsthe following operations: (a-e are not applied sequentially,they operate on the original instance of database shownabove. Assume domain constraints are not violated. Also,if there is no violation, explain the effect of the operation.
(a) change the EmpID 'DV001' into 'DV005' in the relationEmployee;
(b) insert <'SA002', 'M. Owen', 'Accounting','Eastside'> into table Employee;
(c) insert <null, 'DV001',5,F> into relationChildren;
(d) delete B. Giggs (DV002) from the relation Employee.
(e) insert <'SA003', null, 'Sales0Y','Eastside'> into table Employee;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply