ENTITY TYPE DOCUMENT:

ENTITY NAME / DESCRIPTION / ALIASES / OCCURENCES
STAFF / Employees working in the department / Employee / Staff works for IT department.
MEMBERSHIP / Staff Committee relation. / A staff can be a member of oneto many committees.
FAQ / Frequently asked questions posted by the students. / Department can have one or many frequently asked questions.
DEPARTMENT / Division of a school/faculty. / Each department offers many courses.
ACTIVITY / Eventthat involves the department. / Department can have one to many activities.
ANNOUNCEMENT / Alerts and news about the department. / NEWS / Department can have one to many announcements.
CATEGORY / Type of courses offered. / A category contains one to many courses.
GALLERY / Photos of the department and student life. / Department can have many photos in the gallery.
COURSECATEGORY / Category Course relation. / Category and courses are related.
COURSE / Courses the department offers. / Department has many courses.
PREREQUISITES / Courses that depend on other courses in the department. / Some courses has one or many courses as prerequisites in the department.
REFERENCE / References the course in a curriculum. / Each course has a reference code in a curriculum.
CURRICULUM / All courses offered for a program in the department. / Curriculum contains many courses.
COMMITTEE / Staff grouped for a specific task / A staff can be a member of one to many committees.

Relationship Type Document:

Relationship Type / Entity Type / Cardinality Ratio / Participation
Works for / Staff / M / Mandatory
department / 1 / Mandatory
offers / Department / 1 / Mandatory
course / M / Mandatory
Belongs / Staff / M / Optional
Membership / 1 / Mandatory
Assign / Membership / 1 / Mandatory
Committee / M / Optional
Has / Department / 1 / Mandatory
F.A.Q / M / Optional
Has / Gallery / M / Optional
Department / 1 / Mandatory
Has / Department / 1 / Mandatory
Activity / M / Optional
Has / Announcement / M / Optional
Department / 1 / Mandatory
Belongs / Category / M / Optional
Coursecategory / 1 / Optional
Has / Course / 1 / Mandatory
prerequisites / M / Optional
Has / Course / M / Mandatory
Reference / 1 / Mandatory
Has / Reference / 1 / Mandatory
Curriculum / M / Optional

Attribute Document:

Entity/Relationship Type / Attribute / Description / Data Type and Length / Constraint / Default Value / Alias / Null? / Derived?
Staff / Name / First Name / Staff first name / Char(25) / AK / No
Last Name / Staff last name / Char(25) / No
SID / Staff unique no / Varchar2(7) / PK
OFFICE NO / Staff office no / Varchar2(5)
E-mail / e-mail address of staff / Varchar2(20)
Phone_NO / Staff phone no / Number(11)
Title / Staff prefix / Char(15)
Status
Office hour / Staff office hour
Picture / Staff photo / Varchar2(5)
Membership / Position / Staff position / Char(10)
Start_date / Membership start date / Date
End_date / Membership end date / Date
Committee / CID / Committee unique no / Varchar2(10) / PK
Name / Name of committee / Char(20) / No
Curriculum / Cuid / Curriculum unique no / Varchar2(7) / PK
Program / Curriculum Program / Char(15) / No
Semester no / Semester course offers
Course / C_code / Course unique no / Varchar2(7) / PK
Semester / semester the course offers in the curriculum / Varchar2(15)
C_title / Name of the course / Varchar(20) / No
Desc / Course objectives / Varchar(50)
Hours / Tutorial / Tutorial hour for the course in a week / Varchar2(5)
Lab / Lab hour for the course in a week / Varchar2(5)
Lecture / Lecture hour for the course in a week / Varchar2(5)
Credit / ECTS / Course credit / Number(1) / No
EMU / University course credit / Number(1)
CoourseCategory
Reference / Refcode / Reference unique no / Varchar2(7) / PK
Gallery / PID / Picture unique no / Varchar2(10) / PK
Picture / Name of picture / Char(15) / No
caption / Char(15)
Activity / title / Activity name / Char(20)
Act_ID / Activity unique no / Varchar2(7) / PK
visibility / Place taken place / Char(15)
Announcement / desc / Purpose of announcement / Char(50)
An_date / Announcement date / date
An_ID / Announcement unique no / Varchar2(7) / PK
Title / Announcement name / Char(20)
Visibility / place / Date
Category / CAID / Category unique no / Varchar2(7) / PK
name / Category name / Varchar(20)
Department / D_code / Department unique no / Number(2) / PK
Name / Department name / Char(25)
F.A.Q / num / Unique no / Varchar2(7) / PK
question / Questions post / Char(50)
Answer / Answer for the question / Char(50)
Prerequisites / Prid / Prerequisites unique no / Varchar2(7)

Attribute Domain Document:

Domain Name / Domain Characteristics / Examples of allowable values / Columns
Membership_start_date / char(7); First three characters month abbreviation,4th character underscore, last 3 characters sequential number / JAN_001, JAN_999, APR_067 / Start_date(membership)
Curriculum_program / Char(15);(‘Bachelor’ or ‘Masters’) / B_tech , M_tech / Program(curriculum)