logo

CREATE TABLE Student(.

3 Pages466 Words1072 Views
   

Added on  2019-09-21

CREATE TABLE Student(.

   Added on 2019-09-21

ShareRelated Documents
CREATE TABLE Student( Student_ID Number(8) PRIMARY KEY, Name Varchar2(15) NOT NULL, Mobile Varchar2(8), Birth_date Date, Dept_ID char(4) NOT NULL, Major Varchar2(3), Nationality Varchar2(20) NOT NULL, Course_ID Varchar2(8) NOT NULL, Grades Varchar2(2), Gender Char(1) NOT NULL, CONSTRAINT student_gender_ck CHECK(Gender='M' OR Gender='F'), CONSTRAINT student_deptid_fk FOREIGN KEY(Dept_ID) REFERENCES Departement(Dept_ID), CONSTRAINT student_courseid_fk FOREIGN KEY(Course) REFERENCES Course(Course_ID));CREATE TABLE Semester( Semester_ID Varchar2(8) NOT NULL, Course_ID Varchar2(8) NOT NULL, CONSTRAINT semester_id_pk PRIMARY KEY(Semster_ID), CONSTRAINT semester_courseid_fk FOREIGN KEY (Course_ID) REFERENCES Course(Course_ID));CREATE TABLE Course( Course_ID Varchar2(8) PRIMARY KEY, Course_name varchar2(10), Crdt_hrs varchar(3), Prerequisite varchar(10), CONSTRAINT course_prereq_ck CHECK(count(Prerequisite)<=3) --CHECK! --CONSTRAINT course_m CHECK PASSED PREQUISITES!);CREATE TABLE Departement( Dept_ID char(4) PRIMARY KEY, Dept_name Varchar2(20) NOT NULL, College_ID Varchar2(3), CONSTRAINT departement_collegeid_fk FOREIGN KEY (College_ID) REFERENCES College(College_ID));
CREATE TABLE Student(._1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
KC7013 DATABASE MODELLING | SQL
|26
|3569
|10

Database Design and Implementation Task 2022
|31
|3280
|19

ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code
|12
|1599
|46

Database Management System
|16
|590
|69

Database Implementation Assignment 2022
|24
|2500
|10

ICT40115 - Certificate IV in Information Technology
|10
|741
|216