Consider the following relations for a mini world of credit). COMPANY. Answer all queries in the language asked for (alternate language gets no 

EMPLOYEE (FName, LName, SSN, Bdate, 

Address, Sex, Salary, SuperSSN, Dno), 

DEPENDENT (SSN, Dep name, Sex, Bdate, Relationship), 

PROJECT (Pnumber, Pname, Plocation, Dnum), WORKS ON (SSN, Pnumber, Hours).

DEPARTMENT (Dname, Dnumber, MgrSSN, Mgr_Start_Date, Dept_Create_Date),

Transcribed Image Text:

Where primary keys are underlined. "Dnumber" in Department is the department number, which is restricted to an integer number between 1 and 20. "Dep_name" in Dependent is the name of employee's dependent. "Dno" in Employee is the "Dnumber" of the department for which an employee works. "Dnum" in Project is the "Dnumber" of its controlling department. "SuperSSN" in Employee is the "SSN" of the employee, who supervises some employees. "Mgr_Start_Date" in Department is the date when department manager starts to manage a department. "Dept_ Create_Date" in Department is the date when the department was created. Assume that a manager's start date is later than the department creation date. "Dname" in Department is the name of each department, which is a candidate key. Where primary keys are underlined. "Dnumber" in Department is the department number, which is restricted to an integer number between 1 and 20. "Dep_name" in Dependent is the name of employee's dependent. "Dno" in Employee is the "Dnumber" of the department for which an employee works. "Dnum" in Project is the "Dnumber" of its controlling department. "SuperSSN" in Employee is the "SSN" of the employee, who supervises some employees. "Mgr_Start_Date" in Department is the date when department manager starts to manage a department. "Dept_ Create_Date" in Department is the date when the department was created. Assume that a manager's start date is later than the department creation date. "Dname" in Department is the name of each department, which is a candidate key.

Answer rating: 100% (QA)

ANSWER 2A INSERT INTO WORKS ON VALUES 11155666 Proj86 120 2Bi SELECT T FName LName Salary FROM EMP... View the full answer