What ways can I make my Relational Data Model conversion meet the following requirements listed below? Am I on the right track? What corrections do I need to address?

ERD:

My Conversion of ERD onto a Relational Data Model:

Requirements:

1. Relational Data Model Design includes a Student Table with appropriate fields and designated primary key.
2. Relational Data Model Design includes a Faculty Table with appropriate fields and designated primary key.
3. Relational Data Model Design includes a Course Table with appropriate fields and designated primary key.
4. Relational Data Model Design includes an Offerings Table with appropriate fields and designated primary key.
5. Relational Data Model Design includes a OfficialRecords Table with appropriate fields and designated primary key.
6. Relational Data Model Design includes a StudentAssociation Table with appropriate fields and designated primary key.
7. Relational Data Model Design includes an Advise Table with appropriate fields and designated primary key.
8. Relational Data Model Design includes a MemberList Table with appropriate fields and designated primary key.
9. Relational Data Model Design presented among the following pair of Tables: 1. Student to Faculty 2. Offerings to Faculty 3. OfficialRecord to Offerings 4. OfficialRecord to Student 5. Advise to Faculty 6. Advise to Faculty to StudentAssociation 7. MemberList to Student 8. MemberList to StudentAssociation

 

 

FACULTY FacultyID First Name Initials Last Name Position Advises Office Phone No COURSE CourseID Name Department Offers Credit Hours Teaches Advises STUDENT ASSOCIATION AssociationID Association Name OFFERING Belongs STUDENT StudentID First Name Initials Last Name Classification School Major Has Semester Reports Section OFFICIAL RECORD Classroom Grade