CREATE VIEW megaview as
SELECT r.Title,s.Title,p.First_Name,p.Last_Name FROM paper r

JOIN sec_par_paper pps ON pps.RID=r.RID
JOIN participant p ON pps.PID=p.PID
JOIN sections s ON pps.SID=s.SID
CREATE TABLE lecturer (
LID int NOT NULL PRIMARY KEY IDENTITY(1,1),
First_Name varchar(20) DEFAULT 'Unknown',
Last_Name varchar(20) DEFAULT 'Unknown'
);

CREATE TABLE participant (
PID int NOT NULL PRIMARY KEY IDENTITY(1,1),
First_Name varchar(20) DEFAULT 'Unknown',
Last_Name varchar(20) DEFAULT 'Unknown'
);

CREATE TABLE sections (
SID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Title varchar(20) DEFAULT 'Unknown'
);

CREATE TABLE paper (
RID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Title varchar(20) DEFAULT 'Unknown',
Theses int DEFAULT '0',
Full_text int DEFAULT '0',
Photos int  DEFAULT '0'
);

CREATE TABLE lec_sec (
LSID int NOT NULL PRIMARY KEY IDENTITY(1,1),
LID int NOT NULL FOREIGN KEY REFERENCES lecturer,
SID int NOT NULL FOREIGN KEY REFERENCES sections
);

CREATE TABLE par_pap_sec (
PPSID int NOT NULL PRIMARY KEY IDENTITY(1,1),
PID int NOT NULL FOREIGN KEY REFERENCES participant,
RID int NOT NULL FOREIGN KEY REFERENCES paper,
SID int NOT NULL FOREIGN KEY REFERENCES sections
);

CREATE VIEW megaview as
SELECT r.Title,s.Title sname,p.First_Name,p.Last_Name FROM paper r

JOIN par_pap_sec pps ON pps.RID=r.RID
JOIN participant p ON pps.PID=p.PID
JOIN sections s ON pps.SID=s.SID