Details of this Paper

Database System- SQL

Description

solution


Question

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.

 

Paper#70481 | Written in 18-Jul-2015

Price : $22
SiteLock