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.  

 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) 

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)

• Drawing3

Page-1
Page-2