Ch. 3: Problem and Exercise 2

PERSON

NameAddress

SSN

Sex

Date_of_Birth

Person_Type

Employee? Alumnus?

Student?

O

ALUMNUSSTUDENTEMPLOYEE

Salary

Employee_Type

Date_Hired

Major_Dept

Student_Type

Degrees

YearDesignation

Date

d d

FACULTY STAFF UNDERGRADSTUDENT

GRADUATESTUDENT

Rank Class_StandingTest_ScorePosition

“Faculty” “Staff”

Employee_Type=

“Grad” “Undergrad”

Student_Type=

Alumnus?=“Y”

Student?=“Y”Employee?=“Y”

Person_Type:

Ch. 3: Problem and Exercise 9

ACCOUNT

Acct No Date_OpenedBalance

Account_Type

d

LOAN

Payment L_Interest_Rate

SAVINGS

S_Interest_Rate

CHECKING

Service_Charge

Account Type=

‘L’‘S’

‘C’

Note: Even though Interest_Rate exists under two subtypes, they have different meanings. Bank will pay you interest for SAVINGS but you will pay the bank interest for LOAN.

Ch 3: Project Exercises 1

PERSONBirth_Date Phone

City/State/Zip

AddressName

Person_ID

O

EMPLOYEE VOLUNTEER

PATIENT

PHYSICIAN

Contact_Date

Specialty

Pager #

Skill

Responsible Date_Hired

Note: The model solution is incomplete. You need to add in the subtype discriminators with proper notations.

Ch 3: Project Exercises 1 (cont.)

Assigned

d

STAFFNURSE TECHNICIAN

Certificate

Skill

Assigned

Is_Assigned

CARECENTER

LocationJob_Class

In_Charge

Name

LABORATORY

Name

Location

Assigned

BED

RESIDENT

Date_Admitted Bed_ID

Bed # Room #

OUTPATIENT

d

Scheduled VISIT

Date

Comments