Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 . Consider the following relational schema. An employee can work in more than one department; the pct _ time field of the Works relation
Consider the following relational schema. An employee can work in more than one department; the pcttime field of the Works relation shows the percentage of time that a given employee works in a given department.
Empeid: integer, ename: string, age: integer, salary: real
Workseid: integer, did: integer, pcttime: integer
Deptdid: integer, budget: real, managerid: integer
Write SQL integrity constraints domain key, foreign key, or CHECK constraints; or
assertions or SQL: triggers to ensure each of the following requirements, considered independently.
a Employees must make a minimum salary of $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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