Reference no: EM13703117
Design of Database Systems
1. Create the database for following relational schema with Employee, Department, and Works tables:
Employee (eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, hours: integer)
Department(did: integer, dname: string, budget: real, managerid: integer)
2. Define a table constraint on Department that will ensure that managerid is always positive and less than 1000.
3. Insert the following records in the database:
Employee
|
eld
|
ename
|
age
|
salary
|
|
101
|
Jones
|
23
|
60000
|
|
105
|
Adams
|
44
|
55000
|
|
110
|
Rivera
|
|
43000
|
|
120
|
Tanaka
|
|
60000
|
|
122
|
Lee
|
57
|
45000
|
Works
|
eld
|
did
|
hours
|
|
101
|
10
|
15
|
|
105
|
10
|
20
|
|
101
|
12
|
25
|
|
122
|
20
|
20
|
|
122
|
22
|
20
|
|
105
|
20
|
10
|
|
120
|
12
|
40
|
|
105
|
12
|
10
|
Department
|
did
|
dname
|
budget
|
managerid
|
|
10
|
Accounting
|
250000
|
234
|
|
12
|
Research
|
100000
|
453
|
|
20
|
Sales
|
|
678
|
|
22
|
IT
|
400000
|
324
|
4. Get the sorted list of name and budget of each department in which employee Jones works.
5. Get the name and id of youngest employee in Research department.
6. Create a view that shows the eids and managerids in Sales department.
7. Add a column called numHours to the Employee table. Use the UPDATE command to insert values into this new column to correspond to the current information in the Works table.
8. Write a trigger that will increment the new field numHours in the Employee table automatically whenever a record is inserted in the Works table.
9. Write a trigger that will decrement the new field numHours in the Employee table automatically whenever a record is deleted from the Works table.
|
About minimum effective radius of insulation
: What can you say about minimum effective radius of insulation? A node is located at the external corner with one side exposed to convection, and the other side insulated. if implicent method is use to dicaribe this node, what is the correct stability..
|
|
Imagine a hypothetical organism
: Imagine a hypothetical organism (critter). A DIPLOID cell from this organism has 20 chromosomes. How many chromosomes would be found in a GERM CELL of this organism?
|
|
Many globular proteins contain a segment of amino acids
: Many globular proteins contain a segment of amino acids that is extended (stretched out) and after making a U-turn binds with itself. This is one kind of Beta pleated sheet known as antiparallel. Instead of H bonds assisting in forming a spiral (a..
|
|
Determine the amount of heat transfer to the air
: Air at 14.7 psia, 50°F (DB), and 60% relative humidity is first heated to 110°F (DB) and then humidified by introducing water using an “air washer.” The air leaves the humidifying section at 70°F (DB).
|
|
Design of database systems
: Write a trigger that will increment the new field numHours in the Employee table automatically whenever a record is inserted in the Works table - Create a view that shows the eids and managerids in Sales department.
|
|
Example of benefit or harm to life that hinges on an enzyme
: An example of benefit or harm to life that hinges on an enzyme. For example, some diseases are the result of an underproduction or overproduction of a vital enzyme. Also, some substances that are considered poisons or pollutants do their harm..
|
|
Find the flux per pole required to generate this voltage
: A simplex DC generator is driven by a diesel engine. The generator is lap wound, with 8 coils, 100 turns per coil and 2 poles and generates 200V at a speed of 1000rpm. Find the flux per pole required to generate this voltage.
|
|
Compute the force suported by the pin
: The uniform slender bar AB has a mass of 8 kg and swings in a vertical plane about the pivot at A. If thett^ = 2 rad/s when theta = 30 degrees, compute the force suported by the pin at A at that instant
|
|
Defend an ethical position on the topic of genetic technolog
: Editorial letter is designed to have you state and defend an ethical position on the topic of genetic technology. You will write a clear introduction that includes a thesis statement, several body paragraphs and a thoughtful conclusion.
|