create primary key constraints for eID and dID on Employee and Departmetn table

-create constraint that ensures salary is not less than 2500

-add constraints to table Employee to ensure that attribute dID refers to attribute Departmnt.dID

-add constraints to table Deparment to ensure that attribute chairID refers to attribute Employee.eID

add the above integrity constrains to table schema:

Employe( eID, ename, salary, mangerID, dID)

Departnemtn ( dID, dname, address, chairID)

Answer rating: 100% (QA)

To create the primary key constraints ensure the minimum salary constraint and foreig... View the full answer