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.