C- ASEP DATABASE (ASEPDB) 
ASEPDB is the database where the information
about the students, courses, instructors, assistants, assignments, grades
and any other related data are stored. There are seven tables in this database.
These are student, instructor, assistant, course, enrollment, assignment,
and evaluation tables. Figure 2 shows the
database schema of the ASEPDB and figures 3-9
show the table structures of all the tables in ASEPDB. In Appendix
A, you can see the Entity Relationship (ER) diagram of ASEP Database.
|
Database Schema of
ASEPDB
|
| |
| Student (SID*, FirstName, LastName,
Password, Email) |
| Instructor (IID*, FirstName, LastName,
Password, Email) |
| Assistant (AID*, FirstName, LastName,
Password, Email) |
| Course (CID*, IID, AID, Name) |
| Enrollment (SID*, CID*) |
| Assignment (CID*, Type*, GivenDate,
DueDate, Format) |
| Evaluation (CID*, SID*, Type*,
Grade, Feedback, Submitted) |
Figure 2: Database Schema of
ASEPDB
| Field
Name |
Field
Data Type |
Explanation |
| SID |
VARCHAR(10) |
Student ID number, primary
key. |
| FirstName |
VARCHAR(20) |
First name of the student. |
| LastName |
VARCHAR(20) |
Last name of the student. |
| Password |
VARCHAR(20) |
User password of the student. |
| Email |
VARCHAR(30) |
E-mail address of the student. |
Figure 3: Student Table Structure
| Field
Name |
Field
Data Type |
Explanation |
| IID |
VARCHAR(10) |
Instructor ID number, primary
key. |
| FirstName |
VARCHAR(20) |
First name of the instructor. |
| LastName |
VARCHAR(20) |
Last name of the instructor. |
| Password |
VARCHAR(20) |
User password of the instructor. |
| Email |
VARCHAR(30) |
E-mail address of the instructor. |
Figure 4: Instructor Table
Structure
| Field
Name |
Field
Data Type |
Explanation |
| AID |
VARCHAR(10) |
Assistant ID number, primary
key. |
| FirstName |
VARCHAR(20) |
First name of the assistant. |
| LastName |
VARCHAR(20) |
Last name of the assistant. |
| Password |
VARCHAR(20) |
User password of the assistant. |
| Email |
VARCHAR(30) |
E-mail address of the assistant. |
Figure 5: Assistant Table Structure
| Field
Name |
Field
Data Type |
Explanation |
| CID |
VARCHAR(10) |
Course ID (CS 101), primary
key. |
| IID |
VARCHAR(10) |
Instructor ID number, primary
key. |
| AID |
VARCHAR(10) |
Assistant ID number. |
| Name |
VARCHAR(50) |
Course name (Computer Science). |
Figure 6: Course Table Structure
| Field
Name |
Field
Data Type |
Explanation |
| SID |
VARCHAR(10) |
Student ID number, primary
key. |
| CID |
VARCHAR(10) |
Course ID (CS 101), primary
key. |
Figure 7: Enrollment Table
Structure
| Field
Name |
Field
Data Type |
Explanation |
| CID |
VARCHAR(10) |
Course ID (CS 101), primary
key. |
| Type |
VARCHAR(20) |
Assignment type, primary
key. |
| GivenDate |
VARCHAR(10) |
Given date of the assignment. |
| DueDate |
VARCHAR(10) |
Due date of the assignment. |
| Format |
VARCHAR(5) |
Assignment file formats (doc,
txt, java). |
Figure 8: Assignment Table
Structure
| Field
Name |
Field
Data Type |
Explanation |
| SID |
VARCHAR(10) |
Student ID number, primary
key. |
| CID |
VARCHAR(10) |
Course ID (CS 101), primary
key. |
| Type |
VARCHAR(20) |
Assignment type, primary
key. |
| Submitted |
CHAR(1) |
(Y/N) Is assignment submitted
or not?. |
| Grade |
NUMBER(3) |
Grade given to the assignment. |
| Feedback |
VARCHAR(5) |
Feedback file format if there
is. |
Figure 9: Evaluation Table
Structure
ASEPDB is implemented in Oracle
Database Management System, which runs under the bursa Unix machine.
You can see the details of database implementation in SQL and the sample
table contents in Appendix B.