Table Name Attribute Data Type Relation Department Dept_id Integer PK Dept_name Varchar(100) Program Prog_id Integer PK Prog_name Varchar(150) Dept_id Integer FK Semester Sem_id Integer Pk Prog_id Integer Fk Sem_no Varchar(150) Session Session_id Integer Pk Session_startyear Varchar(20) Session_endyear Varchar(20) Dept_id Integer FK ClassRoom Room_id Integer Pk Room_label Varchar(50) Room_type Varchar(50) Room_id integer Fk Subject Sub_id Integer Pk Sub-name Varchar(150) Sem_id integer Fk Credithour Varchar Day Day_id Integer Pk Day_name Varchar(150) Day_status Varchar(20) Time_id Integer FK Teacher Teacher_id Integer Pk Teacher_name Varchar(150) Teacher_address Varchar(150) Teacher_nic Varchar(20) Teacher_cellNo Varchar(50) Teacher_email Varchar(100) Teacher_qualification Varchar(150) Teacher_interest Varchar(200) Dept_id integer Fk Teacher_status Varchar(20) Time Time_id Integer Pk Duration Varchar(50) Starting_time Varchar(50) Ending_time Varchar(50) Day_id integer Fk Class_id integer Fk Subjectteacher Subtech_id integer Pk Sub_id integer Fk Teacher_id integer Fk
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)