Database System- SQL

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.