sql_queries

--1
INSERT INTO GRAD_CANDIDATES (STUDENT_ID, LAST_NAME, FIRST_NAME, CREDITS, GRADUATION_DATE) VALUES(1234567, 'NELSON','IVAN', 123, '12-DEC-22')

--2
Major_ID IS a FOREIGN KEY referncing the Major_ID COLUMN IN the Major TABLE. AS we have NOT inserted DATA IN Major_ID COLUMN we cannot enter major_id yet.

--3
INSERT INTO MAJOR (MAJOR_ID, MAJOR_NAME, CREDITS_REQUIRED) VALUES(002520, 'Database Technology', 62)
INSERT INTO MAJOR (MAJOR_ID, MAJOR_NAME, CREDITS_REQUIRED) VALUES(001275, 'Computer Programming', 63)
INSERT INTO MAJOR (MAJOR_ID, MAJOR_NAME, CREDITS_REQUIRED) VALUES(001315, 'Math', 64)

--4
UPDATE GRAD_CANDIDATES
SET MAJOR_ID = 002520
WHERE STUDENT_ID = 1234567

--5
COMMIT

--6
INSERT INTO GRAD_CANDIDATES (STUDENT_ID, LAST_NAME, FIRST_NAME, CREDITS, GRADUATION_DATE, MAJOR_ID) VALUES(1234568, 'SANCHEZ','RICK', 123, '12-DEC-22', 001315)

--7
DROP TABLE dept cascade constraints

CREATE TABLE dept
AS SELECT department_id, department_name FROM departments;

--8
INSERT INTO WAREHOUSE (WAREHOUSE_ID, WAREHOUSE_NAME, DEPT_ID)
VALUES('&WAREHOUSE_ID','&WAREHOUSE_NAME','&DEPT_ID')

--9
INSERT INTO D_SONGS
VALUES (52, 'Surfing Summer' , 'Not known', 12);
INSERT INTO D_SONGS
VALUES (53, 'Victory Yay' , '5 min', 12);

--10
The DEFAULT VALUE can be used TO SET a VALUE OF the COLUMN IF no VALUES are provided FOR that COLUMN. FOR example we can USE it SET the DATE COLUMN TO CURRENT DATE IF no VALUE IS specified.