CREATE TABLE Employer(

  employer# NUMBER NOT NULL UNIQUE,
  EmpName VARCHAR2(25) NOT NULL UNIQUE,
  Address VARCHAR2(30),
  PRIMARY KEY (employer#, EmpName)

);

CREATE TABLE Job_posting(

  JobPosting# NUMBER NOT NULL UNIQUE,
  employer# NUMBER REFERENCES Employer(employer#),
  EmpName VARCHAR2(25) REFERENCES Employer(EmpName),
  Phone VARCHAR2(12) NOT NULL,
  Email VARCHAR2(25) NOT NULL,
  skillsRequired VARCHAR2(30) NOT NULL,
  hourlyWage NUMBER NOT NULL,
  JobPos VARCHAR2(12),
  yearOfExpReq NUMBER,
  PRIMARY KEY (employer#, EmpName)
);

CREATE TABLE Job_seeker(

  JobSeeker# NUMBER NOT NULL UNIQUE,
  jobSeekerName VARCHAR(25) NOT NULL,
  Email VARCHAR2(25) NOT NULL,
  Phone VARCHAR2(12) NOT NULL,
  Address VARCHAR2(50) NOT NULL
);

CREATE TABLE JobResume(

  resumeID NUMBER REFERENCES Job_seeker(JobSeeker#),
  Skills VARCHAR2(30) NOT NULL,
  yearsOfExp NUMBER NOT NULL
);

INSERT INTO employer
VALUES(01, 'Google', 'Menlo Park, CA, US');

INSERT INTO employer
VALUES(05, 'IBM', 'Toronto, ON, CA');

INSERT INTO employer
VALUES(06, 'Ryerson', 'Toronto, ON, CA');

INSERT INTO employer
VALUES(07, 'Soundcloud', 'Stockholm, Sweden');

INSERT INTO Job_posting
VALUES(01, 01, 'Google', '647-999-8877', 'google@gmail.com', 'Java', 40, 'JunDev', 2);

INSERT INTO Job_posting
VALUES(02, 05, 'IBM', '416-888-7755', 'ibmadmin@ibm.com', 'C++', 50, 'SenDev', 4);

INSERT INTO Job_posting
VALUES(03, 06, 'Ryerson', '647-222-5147', 'jobs@ryerson.ca', 'smalltalk', 25, 'Intern', 1);

INSERT INTO Job_posting
VALUES(04, 07, 'Soundcloud', '215-447-9897', 'admin@soundcloud.com', 'SQL', 45, 'SenDev', 3);

INSERT INTO JOB_SEEKER
VALUES(01, 'John Smith', 'jsmith@gmail.com', '647-224-7898', '12 Lakeshore West, Toronto, ON, CA');

INSERT INTO JOB_SEEKER
VALUES(02, 'Mary Jane', 'mjane@hotmail.com', '416-789-8547', '250 Yonge St, Toronto, ON, CA');

INSERT INTO JOB_SEEKER
VALUES(03, 'Jawad Khudadad', 'jawad@hotmail.com', '647-420-0154', '20 Gerrard St W, Toronto, ON, CA');

INSERT INTO JOB_SEEKER
VALUES(04, 'Aria Alaei', 'aria@gmail.com', '416-222-4787', '20 Eglinton Ave, Brampton, ON, CA');

INSERT INTO JOBRESUME
VALUES(01, 'Java, Basic C, C#', 2);

INSERT INTO JOBRESUME
VALUES(02, 'smalltalk', 1);

INSERT INTO JOBRESUME
VALUES(03, 'Java, C, C++, C#, SQL', 3);

INSERT INTO JOBRESUME
VALUES(04, 'Java', 4);