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

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

(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.

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN