Answered step by step
Verified Expert Solution
Link Copied!

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

2. Consider the following relational schema. An employee can work in more than one department; the pct_time field of the Works relation shows the percentage of time that a given employee works in a given department.
Emp(eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, pct_time: integer)
Dept(did: integer, budget: real, managerid: integer)
Write SQL-92 integrity constraints (domain, key, foreign key, or CHECK constraints; or
assertions) or SQL:1999 triggers to ensure each of the following requirements, considered independently.
a. Employees must make a minimum salary of $20000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

how would you have done things differently?

Answered: 1 week ago

Question

3. What information do participants need?

Answered: 1 week ago