Project part 2

1

Part#2: DATA STRUCTURE

To do:

1. Using the ERD (reduced from Part 1) provided below, create logical data structures for all the entities and associative entities.

2. For each data structure, include a Data Structure Form that lists all of the assumptions and business rules relating to the data structures. (Copy of this form and sample

completed form are provided below (next page).)

To submit:

1. Include updated ERD + description page 2. Insert the pages for the data structures. There will be one page for each data structure. 3. Submit your work on Canvas by the due date.

ERD for Group Project Part 2

TRANSACTION

PK Transaction_Number

Transaction_date Transaction_Total_Cost FK1 Member_ID FK2 Employee_ID

EMPLOYEE

PK Employee_ID

Employee_Name Employee_Address Employee_Phone Employee_Hire_Date Employee_Position Employee_Status

MEMBERSHIP

PK Membership_ID

Membership_Type Membership_Fee Membership_Discount

MEMBER

PK Member_ID

Member_Name Member_Address Member_Gender Member_DOB Member_Join_Date FK1 Membership_ID

FITNESS_CLASS

PK Reference_Number

Start_Date DaysOfWeekHeld Time_Period FK1 Course_Number FK2 Employee_ID

FITNESS_COURSE

PK Course_Number

Course_Name Course_Description Course_Category Course_Duration Course_Fee

has

has

has

has

has

INSTRUCTOR_COURSE

PK,FK1 Employee_ID PK,FK2 Course_Number

DateQualified Qualification_Type

CLASS_ENROLLMENT

PK,FK1 Member_ID PK,FK2 Reference_Number

Enrollment_Date

has

has

has

has

2

Sample page and instructions to illustrate Data Structure Form

(TABLE NAME entered in all capital letters)

Example TABLE: EMPLOYEE

Business Rules:

(List all cardinality rules that apply to this table, rules for primary key selection,

referential integrity rules, etc.)

Examples:

• Each Employee has a unique ID.

• Employee can be instructor for many courses, but a course is taught by only one Employee.

• Only one phone number will be kept for each Employee.

• Each Employee must have a name and a hire date.

Data Structure:

Example: EMPLOYEE(Employee_ID, Employee_Name, Employee_Address,

Employee_Phone, Employee_Hire_Date, Employee_Position, Employee_Status) Underline

primary key!

Attribute Description:

For each field identified in the data structure, complete the information in the table below.

(Example )

Attribute Name Attribute

Data Type

Attribute

Required?

PK or FK FK Reference Table

Employee_ID INTEGER Y PK

Employee_Name VARCHAR(30) Y

Employee_Address VARCHAR(25)

Employee_Phone CHAR(12)

Employee_Hire_Date CHAR(10) Y

Employee_Position VARCHAR(25)

Employee_Status CHAR(3)