$/*--------------------------------------------------------------$BEGIN $-$ SQL CODE FOR RESEARCHER TABLE CREATION $----------------------------------------------------------------*/$CREATE TABLE Researcher$($ ResearcherID numeric, ResName char$(50),$ SubjectID numeric, SchoolID numeric, PRIMARY KEY $($ResearcherID$))$;INSERT INTO Researcher VALUES $(1,\text{'}$Dr$.$ Hahn', $3,1)$;INSERT INTO Researcher VALUES $(2,\text{'}$Dr$.$ Lee', $2,2)$;INSERT INTO Researcher VALUES $(3,\text{'}$Dr$.$ Arling', $1,3)$;INSERT INTO Researcher VALUES $(4,\text{'}$Dr$.$ Smith', $1,2)$;$/*--------------------------------------------------------------$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, PaperLength smallint not null, ResearcherID smallint not null, PRIMARY KEY $($PaperID$))$;INSERT INTO Paper VALUES $(1,$ 'Stock Predications for $2018\text{'},32,1)$;INSERT INTO Paper VALUES $(2,$ 'Sox Complaints and Compliance', $39,2)$;INSERT INTO Paper VALUES $(3,$ 'Big Clouds', $22,1)$;INSERT INTO Paper VALUES $(4,$ 'Spark and Analytics', $20,3)$;INSERT INTO Paper VALUES $(5,$ 'Hive and Hadoop', $22,3)$;INSERT INTO Paper VALUES $(6,$ 'Augmented Reality in $2020\text{'},45,3)$;INSERT INTO Paper VALUES $(7,$ 'Start Up Funding Best Practices', $15,2)$;INSERT INTO Paper VALUES $(8,$ 'Visualization Dos and Donts', $31,1)$;INSERT INTO Paper VALUES $(9,\text{'}$AI in Five Years', $16,3)$;INSERT INTO Paper VALUES $(10,$ 'Depreciating IT Investments', $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 SUBJECT TABLE CREATION $----------------------------------------------------------------*/$CREATE TABLE Subject$($ SubjectID numeric, SubjectName char$(50),$ PRIMARY KEY $($SubjectID$))$;INSERT INTO Subject VALUES $(1,$ 'Accounting'$)$;INSERT INTO Subject VALUES $(2,$ 'Finance'$)$;INSERT INTO Subject VALUES $(3,$ 'Marketing'$)$;$/*--------------------------------------------------------------$END $-$ SQL CODE FOR SUBJECT TABLE CREATION $----------------------------------------------------------------*/$