Sample Resume

Submitted By Manich999
Words: 367
Pages: 2
Open Document
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 |
Show More

Related Documents: Sample Resume

It Sql Final Essay

DATABASE FINAL EXAM: What does the update command do? It allows you to update data. What do the inner/full outer join commands do? The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables. The FULL OUTER JOIN keyword returns all rows from the left table (table1) and from the right table (table2). The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins. What does the Alias command do? SQL aliases are used to…

Words 2049 - Pages 9

Winter Study Guide Essay

Winter 2012 Study Guide – Comprehensive Exam (in reverse order) BUS 391 Chapter 7 Networks, Telecommunications, and Wireless Networks and Telecommunications Network Basics • Telecommunication system - enable the transmission of data over public or private networks • Network - a communications, data exchange, and resource-sharing system created by linking two or more computers and establishing standards, or protocols, so that they can work together • The three types of networks…

Words 5237 - Pages 21