create primary key constraints for eID and dID on Employee and Departmetn table -create constraint that ensures salary is not

create primary key constraints for eID and dID on Employee and Departmetn table -create constraint that ensures salary is not

Question:

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.eIDadd the above integrity constrains to table schema:Employe( eID, ename, salary, mangerID, dID)Departnemtn ( dID, dname, address, chairID)

Expert Answer:

Answer rating: 100% (QA)

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