The following problem is based on the Elmasri Company database, with all the constraints described
in Figure 4.1. Now suppose we were working with the relational instance described in Figure 3.6. For the following
operations, write down all the integrity constraints, if any, that are violated: No explanation necessary: all you
have to do is to write down one or more of the following integrity constraints which have been violated: domain
constraint, key constraint, entity integrity constraint, referential integrity constraint
(a) Delete the WORKS ON tuples with ESSN = `123456789′.
(b) Delete the PROJECT tuple with PNAME = `ProductY’.
(c) Insert `999678989′,null,40.0 into WORKSON.
(d) Insert Research, Chicago into DEPT LOCATIONS
All I want is to write down one or more of the following integrity constraints which have been violated:
domain
constraint,
key constraint,
entity integrity constraint,
referential integrity constraint
Database is attached
(e) Insert `ProductB’,2,`Bellaire’,4 into PROJECT.
0 comments