/* --------------------------------------------------------------
BEGIN - SQL CODE FOR RESEARCHER TABLE CREATION 
----------------------------------------------------------------*/
CREATE TABLE Researcher
( ResearcherID numeric,
  ResName char(50),
  DomainID numeric,
  SchoolID numeric,
  PRIMARY KEY (ResearcherID)
);
INSERT INTO Researcher VALUES (1, 'Dr. Hahn', 3, 2);
INSERT INTO Researcher VALUES (2, 'Dr. Lee', 2, 1);
INSERT INTO Researcher VALUES (3, 'Dr. Arling', 1, 3);
/* --------------------------------------------------------------
END - SQL CODE FOR RESEARCHER TABLE CREATION 
----------------------------------------------------------------*/

/* --------------------------------------------------------------
BEGIN - SQL CODE FOR PAPER TABLE CREATION 
----------------------------------------------------------------*/
CREATE TABLE Paper
( PaperID int not null,
  PaperTitle char(50) not null,
  DomainID smallint not null,
  PaperLength smallint not null,
  ResearcherID smallint not null,
  PRIMARY KEY (PaperID)
);
INSERT INTO Paper VALUES (1, 'Stock Predications for 2018', 2, 32, 1);
INSERT INTO Paper VALUES (2, 'Sox Complaints and Compliance', 3, 39, 2);
INSERT INTO Paper VALUES (3, 'Big Clouds', 1, 22, 1);
INSERT INTO Paper VALUES (4, 'Spark and Analytics', 3, 20, 3);
INSERT INTO Paper VALUES (5, 'Hive and Hadoop', 3, 22, 3);
INSERT INTO Paper VALUES (6, 'Augmented Reality in 2020', 3, 45, 3);
INSERT INTO Paper VALUES (7, 'Start Up Funding Best Practices', 1, 15, 2);
INSERT INTO Paper VALUES (8, 'Visualization Dos and Donts', 3, 31, 1);
INSERT INTO Paper VALUES (9, 'AI in Five Years', 3, 16, 3);
INSERT INTO Paper VALUES (10, 'Depreciating IT Investments', 2, 18, 2);
/* --------------------------------------------------------------
END - SQL CODE FOR PAPER TABLE CREATION 
----------------------------------------------------------------*/

/* --------------------------------------------------------------
BEGIN - SQL CODE FOR SCHOOLTABLE CREATION 
----------------------------------------------------------------*/
CREATE TABLE School
( SchoolID numeric,
  SchoolName char(50),
  PRIMARY KEY (SchoolID)
);
INSERT INTO School VALUES (1, 'TCU');
INSERT INTO School VALUES (2, 'SMU');
INSERT INTO School VALUES (3, 'UTA');
/* --------------------------------------------------------------
END - SQL CODE FOR SCHOOLTABLE TABLE CREATION 
----------------------------------------------------------------*/

/* --------------------------------------------------------------
BEGIN - SQL CODE FOR DOMAIN TABLE TABLE CREATION 
----------------------------------------------------------------*/
CREATE TABLE Domain
( DomainID numeric,
  DomainName char(50),
  PRIMARY KEY (DomainID)
);
INSERT INTO Domain VALUES (1, 'Accounting');
INSERT INTO Domain VALUES (2, 'Finance');
INSERT INTO Domain VALUES (3, 'Marketing');
/* --------------------------------------------------------------
END - SQL CODE FOR DOMAIN TABLE CREATION 
----------------------------------------------------------------*/