1) Show how you can insert the following row in the DEPARTMENT table using SQL: (1 point) Dname=HR Dnumber=6 Mgr_ssn=Hou

[answerhappygod]

1) Show how you can insert the following row in the DEPARTMENT table using SQL: (1 point)
Dname=HR
Dnumber=6
Mgr_ssn=Houston
Mgr_start_date=1999-01-01
Figure 5.6 One possible database state for the COMPANY relational database schema Dno 5 5 EMPLOYEE Frame Minit John B Franklin T Alicia J Jennifer S Ramesh K Joyce А Ahmad v James E 4 Lname San Bdate Address Sex Salary Super_sn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 6668844441962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX м 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL ? ד ה 4 5 이지 5 ΣΕ ΣΣ 4 1 DEPARTMENT Dname Research Administration Headquarters Dnumber 5 4 1 Mgr son 333445555 987654321 888665555 Morstart date 1988-05-22 1995-01-01 1981-06-19 DEPT LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston Pno 1 2 3 Hours 32.5 7.5 40.0 PROJECT Pname ProductX Product Product Computerization Reorganization Newbenefits IN Pnumber 1 2 3 10 20 30 Plocation Bellaire Sugarland Houston Stafford Houston Stafford Dnum 5 5 5 1 4 1 2 2 4 WORKS ON Esan 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 20.0 20.0 10.0 10.0 10.0 10.0 3 10 20 Sex 30 F 10 30.0 10.0 35.0 5.0 10 DEPENDENT Essn 333445555 333445555 333445555 987654321 123456789 123456789 123456789 M F Dependent name Alice Theodore Joy Abner Michael Alice Elizabeth Bdate 1986-04-05 1983-10-25 1958-05-03 1942-02-28 1988-01-04 1988-12-30 1967-05-05 30 30 Relationship Daughter Son Spouse Spouse Son Daughter Spouse M M 20 20.0 15.0 NULL F F 20