Logical Database Design

CIT 214 – Assignment 1 – Logical Database Design, The Big Boys and Girls Gym Database

View 1

MEMBER (MEM_ID, MEM_LAST, MEM_FIRST, MEM_EMAIL, MEM_LEVEL, MEM_BDAY) AK MEM_EMAIL SK MEM_LAST

EMAIL (EMAIL_ID, MEM_ID, C_ID, EVENT_ID, EMAIL_DESCRIP) SK MEM_ID, C_ID, EVENT_ID FK MEM_ID ( MEMBER FK C_ID ( CLASS FK EVENT_ID ( EVENT

CLASS (C_ID, C_NUMBER, C_NAME, C_START_TIME, C_END_TIME, C_ACTUAL_DATE) SK C_NUMBER

EVENT (EVENT_ID, EVENT_DESCRIP) SK EVENT_DESCRIP

View 2

INSTRUCTOR (INST_ID, INST_LAST, INST_FIRST) SK INST_LAST

INSTRUCTOR SPECIALTIES (SPEC_ID, INST_ID) FK SPEC_ID ( SPECIALTIES INST_ID ( INSTRUCTOR

SPECIALTIES (SPEC_ID, SPEC_DESCRIPTION) SK SPEC_DESCRIPTION

View 3

MEMBER (MEM_ID, MEM_LAST, MEM_FIRST, MEM_PHONE, MEM_EMAIL, MEM_LEVEL) SK MEM_LAST

SESSION (SESS_ID, MEM_ID, INST_ID, SESS_DATE, SESS_FEE, SESS_QUANTITY, SESS_PMT) SK MEM_ID, INST_ID FK MEM_ID ( MEMBER INST_ID ( INSTRUCTOR

INSTRUCTOR (INST_ID, INST_LAST, INST_FIRST, INST_PHONE, INST_EMAIL) AK INST_PHONE, INST_EMAIL SK INST_LAST

View 4

INSTRUCTOR (INST_ID, INST_LAST, INST_FIRST, INST_PHONE, INST_EMAIL) AK INST_PHONE, INST_EMAIL SK INST_LAST

CLASS (C_ID, C_NUMBER, C_NAME, C_START_DATE, C_END_DATE, C_START_TIME, C_END_TIME, C_ACTUAL_DATE, INST_ID) SK C_NUMBER, C_NAME FK INST_ID ( INSTRUCTOR

View 5

MEMBER (MEM_ID, MEM_LAST, MEM_FIRST, MEM_LEVEL) SK MEM_LAST

ROSTER (MEM_ID, C_ID, MEM_PAID) FK MEM_ID ( MEMBER C_IS ( CLASS

CLASS (C_ID, C_NUMBER, C_NAME) SK C_NUMBER

View 6

MEMBER (MEM_ID, MEM_LAST, MEM_FIRST, MEM_LEVEL) SK MEM_LAST

PLAN (PLAN_ID, MEM_ID, DIET_ID, PLAN_START, PLAN_END) SK MEM_ID, DIET_ID FK MEM_ID ( MEMBER DIET_ID ( DIET

DIET (DIET_ID, DIET_DESCRIPTION) SK DIET_DESCRIPTION

Combined View Relational Diagram