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)