I am mostly having trouble figuring out how to answer deliverable 2, specifically on how to show the functional dependencies (Full, partial, and transitive). Below I included my answer to deliverable 1, so all I need help on is what I stated for deliverable 2. If anyone could check my deliverable 1 and see if I did that correctly that would be great as well. I provided all the instructions given.

The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of VCPP University. The initial entities for your model are STUDENT, COURSE, and INSTRUCTOR. In addition to these initial entities, you are provided with several business rules. You should treat this project as a business assignment in which your instructor is | your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay. Initial Entities. STUDENT (StudentID. StudentName, Student Address, StudentPhone, StudentEmail, StudentDOB, StudentMajor, GPA) COURSE (CourseID, CourseName, CreditHours) INSTRUCTOR( InstructorID. InstructorName. InstructorAddress, InstructorPhone, Instructor Email, Salary) You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships. Deliverable 2 In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules: Business Rules: In addition to the following business rules, make sure to add any other business rules based on your assumptions: INSTRUCTOR may teach one or more courses and each COURSE could be taught by one or more INSTRUCTORS. > Many STUDENTS may take many COURSES, and each COURSE may have many Students. Each Student is required to take many COURSES Each COURSE can have one or more SECTIONS, and each SECTION belongs to one COURSE Feel free to add any other business rules. In Deliverable 2. You will add the additional relations and relationships to the relational schema you created in Deliverable 1. You must maintain 1, 2, & 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order and be sure to include the relationships between the relations (all of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order. Be sure to use the correct capitalization formatting with RELATION names being singular and, in ALL CAPS, while attributes are presented using Proper Camel notation. Remember that this logical schema is a listing of the relations and relationships, and it is not in the same format as an ERD. Also, make sure to show the functional dependencies (Full, Partial, Transitive) Deliverable 1 DELIVERABLE 1 Student Studenti StudentName StudentAddress StudentPhone StudentEmail StudentDOB Student Major GPA Course Courseld CourseName CreditHours Course Type Course Desc Studenti Instructor InstructoriD InstructorName InstructorAddress InstructorPhone InstructorEmail Coursel The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of VCPP University. The initial entities for your model are STUDENT, COURSE, and INSTRUCTOR. In addition to these initial entities, you are provided with several business rules. You should treat this project as a business assignment in which your instructor is | your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay. Initial Entities. STUDENT (StudentID. StudentName, Student Address, StudentPhone, StudentEmail, StudentDOB, StudentMajor, GPA) COURSE (CourseID, CourseName, CreditHours) INSTRUCTOR( InstructorID. InstructorName. InstructorAddress, InstructorPhone, Instructor Email, Salary) You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships. Deliverable 2 In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules: Business Rules: In addition to the following business rules, make sure to add any other business rules based on your assumptions: INSTRUCTOR may teach one or more courses and each COURSE could be taught by one or more INSTRUCTORS. > Many STUDENTS may take many COURSES, and each COURSE may have many Students. Each Student is required to take many COURSES Each COURSE can have one or more SECTIONS, and each SECTION belongs to one COURSE Feel free to add any other business rules. In Deliverable 2. You will add the additional relations and relationships to the relational schema you created in Deliverable 1. You must maintain 1, 2, & 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order and be sure to include the relationships between the relations (all of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order. Be sure to use the correct capitalization formatting with RELATION names being singular and, in ALL CAPS, while attributes are presented using Proper Camel notation. Remember that this logical schema is a listing of the relations and relationships, and it is not in the same format as an ERD. Also, make sure to show the functional dependencies (Full, Partial, Transitive) Deliverable 1 DELIVERABLE 1 Student Studenti StudentName StudentAddress StudentPhone StudentEmail StudentDOB Student Major GPA Course Courseld CourseName CreditHours Course Type Course Desc Studenti Instructor InstructoriD InstructorName InstructorAddress InstructorPhone InstructorEmail Coursel