![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 03.04.2021 01:50 mckennayoshz
Emp( eid:integer, ename: string, age: integer, salary: real)
Works( eid:integer, did: integer, pet_time: integer)
Dept(did:integer, dname: string, budget: real, managerid:integer)
1. Give an example of a foreign key constraint that involves the Dept relation.
2. Write the SQLstatements required to create the preceding relations, includingappropriate versions of all primary and foreign key integrityconstraints.
3. Define the Deptrelation in SQL so that every department is guaranteed to have amanager.
4. Write an SQLstatement to add John Doe as an employee with eid = 101, age = 32and salary = 15,000.
5. Write an SQLstatement to give every employee a 10 percent raise.
6. Write an SQLstatement to delete the Toy department.
![ansver](/tpl/images/cats/User.png)
Answers: 3
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 12:30
An atom's diameter is about 0.1 nanometer (1×10-9m), and a human hair is about 1×10-3m. how many times greater is a human hair than an atom's diameter? sorry pushed wronf button but this is math
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 15:30
The processing of data in a computer involves the interplay between its various hardware components.
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 08:30
Aconsumer would pay an extra they used the rent to own program to buy the computer, rather than using cash. for all of the items, is the cheapest option over the life of the contract. the most expensive overall option is to use purchase the item.
Answers: 2
![question](/tpl/images/cats/informatica.png)
You know the right answer?
Emp( eid:integer, ename: string, age: integer, salary: real)
Works( eid:integer, did: integer, pet_...
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 26.07.2019 10:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
History, 26.07.2019 10:00
![question](/tpl/images/cats/mkx.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 26.07.2019 10:00
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/es.png)
Spanish, 26.07.2019 10:00
![question](/tpl/images/cats/mkx.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/himiya.png)
Chemistry, 26.07.2019 10:00
![question](/tpl/images/cats/es.png)
Spanish, 26.07.2019 10:00
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/biologiya.png)
Biology, 26.07.2019 10:00