Reply to thread

Message: <blockquote data-quote="sbanurada" data-source="post: 19682283" data-attributes="member: 33920">CREATE TABLE Student(S_ID VARCHAR(5) NOT NULL PRIMARY KEY,S_NAME VARCHAR(30) NOT NULL,GENDER VARCHAR(1) NOT NULL CHECK ( [Gender] IN ('M', 'F') ),DOB VARCHAR(8) CHECK (DOB > 'Current_Date'),P_ID VARCHAR(5) FOREIGN KEY REFERENCES Degree_Programs(P_ID) );CREATE TABLE Degree_Programs(P_ID VARCHAR(5) PRIMARY KEY,P_NAME VARCHAR(15) NOT NULL,FAC_ID VARCHAR(5) FOREIGN KEY REFERENCES Faculties (FAC_ID));CREATE TABLE Faculties(FAC_ID VARCHAR(5) PRIMARY KEY,FAC_NAME VARCHAR(15) NOT NULL);CREATE TABLE Levels(LEVEL_ID VARCHAR NOT NULL PRIMARY KEY,P_ID VARCHAR(5) FOREIGN KEY REFERENCES Degree_Programs(P_ID));CREATE TABLE Modules(MODULE_ID VARCHAR(5) NOT NULL PRIMARY KEY,MODULE_NAME VARCHAR(15) NOT NULL,LEVEL_ID VARCHAR FOREIGN KEY REFERENCES Levels(LEVEL_ID),LECTURER_ID VARCHAR(5) FOREIGN KEY REFERENCES Lecturer(LECTURER_ID));CREATE TABLE ASSESMENT(A_ID VARCHAR(5) NOT NULL PRIMARY KEY,A_TYPE VARCHAR(10) NOT NULL,MODULE_ID VARCHAR(5) FOREIGN KEY REFERENCES Modules(MODULE_ID));CREATE TABLE Lecturer(LECTURER_ID VARCHAR(5) NOT NULL PRIMARY KEY,LECTURER_NAME VARCHAR(25) NOT NULL );  godak waridi ban.onna haduwa.FOREIGN KEY hadanakota anith tabale hadila thiyenta oni.DOB VARCHAR(8) CHECK (DOB > 'Current_Date'), cuurent date kiyana 1a mata suvrer ne.anika space be table name walatathawa waradi tikak atha.ewa himita balapan.day end time 1a busyyyyyyyyyyyyy.</blockquote>

Top Bottom