D ScholarshipsTbl PERAH PROJECT Data Structures Diagram Ver

D Scholarships_Tbl PERAH PROJECT Data Structures Diagram – Ver 5 (according to ERD Ver 6) Scholarship_Code(PK) Coach_Id_Fld (FPK) Coordinator_Id_Fld(FPK) Scholarship_Hours_Fld Scholarship_Excellent_Fld Scholarship_Wage_Fld Coaches_Tbl B Coordinators_Tbl Coordinator_Id_Fld(PK) Coordinator_FName_Fld Coordinator_LName_Fld Coordinator_Address_Fld Coordinator_PNumber_Fld Coordinator_Email_Fld Coordinator_Available_Day_Fld Coordinator_Available_Hours_Fld Extra_Activities_Tbl B Professions_Coaches_Tbl A Professions_Tbl Profession_Code_Fld(FPK) Coach_Id_Fld (FPK) Extra_Activities_Coach_Tbl Extra_Activities_Fld(FPK) Coach_Id_Fld (FPK) A Hobbbies_Coaches_Tbl Hobby_Code_Fld(FPK) Coach_Id_Fld (FPK) students_Coaches_Professions_ Tbl student_id_Fld(FPK) Coach_Id_Fld (FPK) Proffesion_Code_Fld(FPK) Meeting_Date_Fld Meeting_Duration_Fld Hobbies_Students_Tbl students_Coaches_Hobbies_ Tbl student_id_Fld(FPK) Coach_Id_Fld (FPK) Hobby_Code_Fld(FPK) Professions_Students_Tbl A A Hobby_Code_Fld(FPK) Student_Id_Fld (FPK) D Profesion_Code_Fld(PK) Profession_name_Fld A B Student_Id_Fld (PK) Student_FName_Fld Student_LName_Fld Student_Address_Fld Student_PNumber_Fld Student_Parent_Name_Fld Student_Parent_PNumber_Fld Student_School_Name_Fld Student_Bdate_Fld Student_Socialinitiation_Fld Extra_Activity_Code_Fld(PK) Extra_Activity_Duration_Fld Summary_Activity_Fld D Hobby_Code_Fld(PK) Hobby_Name_Fld Hobby_Description_Fld Students_Tbl Coach_Id_Fld (PK) Coordinator_Id_Fld(FK) Coach_FName_Fld Coach_LName_Fld Coach_Address_Fld Coach_PNumber_Fld Coach_Email_Fld Coach_Bdate_Fld Coach_Semester_Fld D Hobbies_Field_Tbl Proffesion_Code_Fld(FPK) Student_Id_Fld (FPK) Student_Grade_Fld Current_Avg_Grades_Fld Previous_Avg_Grades_Fld A A

3 D Scholarships_Tbl PERAH PROJECT Data Structures Diagram – Ver 5 (according to ERD Ver 6) Scholarship_Code(PK) Coach_Id_Fld (FPK) Coordinator_Id_Fld(FPK) Scholarship_Hours_Fld Scholarship_Excellent_Fld Scholarship_Wage_Fld 1 B Coordinators_Tbl 2 Coordinator_Id_Fld(PK) Coordinator_FName_Fld Coordinator_LName_Fld Coordinator_Address_Fld Coordinator_PNumber_Fld Coordinator_Email_Fld Coordinator_Available_Day_Fld Coordinator_Available_Hours_Fld 1 Extra_Activities_Tbl Coaches_Tbl 3 D Extra_Activities_Coach_Tbl Extra_Activities_Fld(FPK) Coach_Id_Fld (FPK) Professions_Coaches_Tbl A A Hobbbies_Coaches_Tbl B Students_Tbl Student_Id_Fld (PK) Student_FName_Fld Student_LName_Fld Student_Address_Fld Student_PNumber_Fld Student_Parent_Name_Fld Student_Parent_PNumber_Fld Student_School_Name_Fld Student_Bdate_Fld Student_Socialinitiation_Fld Professions_Tbl Hobby_Code_Fld(FPK) Coach_Id_Fld (FPK) 3 students_Coaches_Professions_ Tbl student_id_Fld(FPK) Coach_Id_Fld (FPK) Proffesion_Code_Fld(FPK) Meeting_Date_Fld Meeting_Duration_Fld D 2 Hobbies_Students_Tbl 3 students_Coaches_Hobbies_ Tbl student_id_Fld(FPK) Coach_Id_Fld (FPK) Hobby_Code_Fld(FPK) 2 Professions_Students_Tbl A A Hobby_Code_Fld(FPK) Student_Id_Fld (FPK) D Profesion_Code_Fld(PK) Profession_name_Fld A Hobbies_Field_Tbl Hobby_Code_Fld(PK) Hobby_Name_Fld Hobby_Description_Fld 1 Profession_Code_Fld(FPK) Coach_Id_Fld (FPK) 3 1 Coach_Id_Fld (PK) Coordinator_Id_Fld(FK) Coach_FName_Fld Coach_LName_Fld Coach_Address_Fld Coach_PNumber_Fld Coach_Email_Fld Coach_Bdate_Fld Coach_Semester_Fld Extra_Activity_Code_Fld(PK) Extra_Activity_Duration_Fld Summary_Activity_Fld 3 B 1 Proffesion_Code_Fld(FPK) Student_Id_Fld (FPK) Student_Grade_Fld Current_Avg_Grades_Fld Previous_Avg_Grades_Fld A A

Legend: A - Connection table B -Prime table D -Secondary table Connection 1: N Connection N: N Order construction: 1 -3 1 - Build first 2 - Build second 3 - Build third