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
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)
Step by Step Solution
3.40 Rating (147 Votes )
There are 3 Steps involved in it
Step: 1
To create the primary key constraints ensure the minimum salary constraint and foreig...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
