FOREIGN KEY (StudentNumber) REFERENCES STUDENT (StudentNumber), (SectionIdentifier) FOREIGN KEY REFERENCES SECTION (SectionIdentifier)); One possible database state for the COMPANY relational database schema. Figure: Specify the updates for the below using the SQL update commands. Insert <‘Robert’, Newcastle Rd, ‘F’, ‘943775543’, ‘1972-06-21’, ‘2365 Bellaire, TX’, M, 58000, 1> into EMPLOYEE. ‘888665555’, Answer: INSERT INTO EMPLOYEE VALUES ('Robert', 'F', 'Scott', '943775543', '21-JUN-42', '2365 Newcastle Rd, Bellaire, TX', M, 58000, '888665555', 1) Insert <‘ProductA’, 4, 2> into PROJECT. ‘Bellaire’, Answer: INSERT INTO PROJECT VALUES ('ProductA', 4, 'Bellaire', 2) Insert <‘Production’, 4, into DEPARTMENT. ‘943775543’, ‘2007-10-01’> Answer: INSERT INTO DEPARTMENT VALUES ('Production', 4, '943775543', '01-OCT-88') Insert <‘677678989’, NULL, into WORKS_ON. ‘40.0’> Answer: INSERT INTO WORKS_ON VALUES ('677678989', NULL, '40.0') Insert <‘453453453’, into DEPENDENT. ‘John’, ‘M’, ‘1990-12-12’, ‘spouse’> Answer: INSERT INTO DEPENDENT ('453453453', 'John', M, '12-DEC-60', 'SPOUSE') VALUES
FOREIGN KEY (StudentNumber) REFERENCES STUDENT (StudentNumber), FOREIGN KEY (SectionIdentifier) REFERENCES SECTION (SectionIdentifier)); Figure: One possible database state for the COMPANY relational database schema. Specify the updates for the below using the SQL update commands. Insert <‘Robert’, ‘F’, ‘943775543’, ‘1972-06-21’, ‘2365 Newcastle Rd, Bellaire, TX’, M, 58000, ‘888665555’, 1> into EMPLOYEE. Answer: INSERT INTO EMPLOYEE VALUES ('Robert', 'F', 'Scott', '943775543', '21-JUN-42', '2365 Newcastle Rd, Bellaire, TX', M, 58000, '888665555', 1) Insert <‘ProductA’, 4, ‘Bellaire’, 2> into PROJECT. Answer: INSERT INTO PROJECT VALUES ('ProductA', 4, 'Bellaire', 2) Insert <‘Production’, 4, ‘943775543’, ‘2007-10-01’> into DEPARTMENT. Answer: INSERT INTO DEPARTMENT VALUES ('Production', 4, '943775543', '01-OCT-88') Insert <‘677678989’, NULL, ‘40.0’> into WORKS_ON. Answer: INSERT INTO WORKS_ON VALUES ('677678989', NULL, '40.0') Insert <‘453453453’, ‘John’, ‘M’, ‘1990-12-12’, ‘spouse’> into DEPENDENT. Answer: INSERT INTO DEPENDENT VALUES ('453453453', 'John', M, '12-DEC-60', 'SPOUSE')
Chaitra_Ananth_Assignment_4.docx