Anjelo's Oracle SQL

Anjelos Oracle SQL

--Drop every cancer table --Uncomment the below if you are sure the db tables exist
--DROP TABLE Instructor;
--DROP TABLE Subject_Area;
--DROP TABLE Courses;


--Create Instructor Table:
CREATE TABLE Instructor
( id number NOT NULL,
  name varchar2(150) NOT NULL,
  CONSTRAINT instructor_id PRIMARY KEY (id)
);

--Create Subject_Area Table:
CREATE TABLE Subject_Area
( id number NOT NULL,
  name varchar2(150) NOT NULL,
  CONSTRAINT subject_area_id PRIMARY KEY (id)
);

--Create Courses Table:
CREATE TABLE Courses
( id number NOT NULL,
  name varchar2(150) NOT NULL,
  CONSTRAINT course_id PRIMARY KEY (id)
);

--Create Person-Address Table: IT DOESN'T RUN FOR SOME FUCKING REASON
--CREATE TABLE Person-Address
--( id number NOT NULL,
--  street varchar2(150) NOT NULL,
--  numberr number NOT NULL,
--  post_code number NOT NULL,
--  country varchar2(150) NOT NULL,
--  CONSTRAINT person_address_id PRIMARY KEY (id)
--);