Write sql statement to delete all information about employee

Assignment Help Database Management System

Reference no: EM13934262

Consider the following relational schema and briefly answer the ques- tions that follow:

Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct time: integer) Dept(did: integer, budget: real, managerid: integer)

1. Define a table constraint on Emp that will ensure that every employee makes at least $10,000.

2. Define a table constraint on Dept that will ensure that all managers have age > 30.

3. Define an assertion on Dept that will ensure that all managers have age > 30. Compare this assertion with the equivalent table constraint. Explain which is better.

4. Write SQL statements to delete all information about employees whose salaries exceed that of the manager of one or more departments that they work in. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates.

Reference no: EM13934262

Questions Cloud

Investment funds to self-managed super fund : Having completed your Graduate Degree from Cambridge, you have just got a job at a small investment advisory firm. Your firm recommends investment funds to Self-Managed Super Fund (SMSF) clients based on their risk and return characteristic

What central purpose for developing first apa ethics code : What was the central purpose for developing the first APA Ethics Code? Was that purpose accomplished? Why or why not? Why were revisions to the code deemed necessary in 2002? How did those revisions affect the ethical principles of the code?

Environment over evolutionary time-order to ensure survival : Consider the differences between an animal that must survive in the arctic cold and one that lives in a hot, dry desert. Each one has adapted to their environment over evolutionary time in order to ensure survival.

C code : C code to find the sum of elements

Write sql statement to delete all information about employee : Write SQL statements to delete all information about employees whose salaries exceed that of the manager of one or more departments that they work in.

Simplify the company logistics requirements : IndoAust Jaya(IAJ) has just employed you as its new logistics manager to examine the company's requirements and also to implement new initiatives to make the business more profitable. The owner/managing director is especially keen to simplify the ..

Determine the required force applied to the handle : Determine the required force F applied to the handle at A and the magnitude of the pin reaction at O. Note that the plunger passes through a vertically-elon- gated hole in the handle at B, so that negligible vertical force is transmitted there.

Prepare a presentation outlining an example : Prepare a presentation outlining an example of an ethical dilemma in that department and proposing a solution for resolving it.

C code : C code to find the sum of elements

User Account

All Pages