Sample Resume

Submitted By Manich999
Words: 367
Pages: 2

PERSON | STAFF | PersonIDStaffIDNameAddressDateOfBirthOfficeNoPhoneExtEmailJobID | STUDENT | PersonIDStudentIDNameAddressTypeDateOfBirthEmail |
PersonID | PROGRAM-STUDENT | PersonIDProgramID | SCHOOL | SchoolIDNameLocation | CAMPUS | CampusIDNameLocation |

JOBCLASS | JobIDJobTypeJobDesignation |

STAFF-COURSE | PersonIDCourseID |

COURSE | CourseIDName | PROGRAM-COURSE | CourseIDProgramID | PROGRAM | ProgramIDNAMEStartDateCompleteDateDegreeIDStudentID | DEGREE | DegreeIDNameTypeLevel |

COURSE-TEACHINGPERIOD | CourseIDPeriod |

TEACHINGPERIOD | PeriodTimeVenue |

COURSEOFFERED | PersonIDOfferedDate |

Relational Data Structures

PERSON (PersonID, {{STAFF (PersonID, StaffID, Name, Address, DateOfBirth, OfficeNo, PhoneExt, Email)}, {STUDENT (PersonID, StudentID, Name, Address, Type, DateOfBirth, Email)}}
JOBCLASS (JobID, JobType, JobDesignation)
DEGREE (DegreeID, Name, Type, Level)
SCHOOL (SchoolID, Name, Location)
CAMPUS (CampusID, Name, Location)
PROGRAM (ProgramID, Name, StartDate, CompleteDate)
COURSE (CourseID, Name)
PROGRAM-COURSE (CourseID, ProgramID)
STAFF-COURSE (PersonID, CourseID)
PROGRAM-STUDENT (PersonID, ProgramID)
TEACHINGPERIOD (Period, Time, Venue)
COURSE-TEACHINGPERIOD (CourseID, Period)
COURSEOFFERED (PersonID, OfferedDate)

Relational Database Schema Table Name | Field | Type | Description | PERSON | PersonID | Text(30) | Primary Key | | STUDENT | PersonID StudentID Name Address Type DateOfBirth Email | Text(30)NumberText(30)Text(30)Text(30)DateText(30) | Primary Key | | STAFF | PersonID StaffID Name Address DateOfBirth Email | Text(30)NumberText(30)Text(30)DateText(30) | Primary Key | | JOBCLASS | JobIDJobNameJobDesignation | NumberText(30)Text(30) | Primary Key | | DEGREE | DegreeIDName TypeLevel | NumberText(30)Text(30)Text(30) | Primary Key | | SCHOOL | SchoolIDName Location | NumberText(30)Text(30) | Primary Key | | COURSE | | | | CourseIDName | NumberText(30) | Primary Key | | CAMPUS | CampusIDName Location | NumberText(30)Text(30) | Primary Key | | PROGRAM | ProgramID StartDate CompleteDate | NumberDateDate | Primary Key | | PROGRAM-COURSE | ProgramIDCourseID | NumberNumber |