For the CustomerOrder table, identify and list out each of the functional dependencies that exist

Due Date: Please refer to the Instructional Plan for all assessment deadlines. Description: This assessment will make use of a central narrative (case study) file, please note that this case study may be unique to your intake, as such the answers generated will be exclusive to your cohort ensuring a customized experience and supporting academic integrity initiatives. This assessment has multiple objectives for student learning and skill(s) development: 1) This scenario will provide students with an academic-based case which is meant to; a. Establish an understanding of the relationship between data sets b. Identify the structure of data and how record sets are formed 2) This deliverable will afford course faculty a chance to gauge student preparedness and ability to; a. Understand the structure and relationship of data b. To work within a business setting to elicit clarification on data, and data structure design, concerns 3) This assessment is part of a series of deliverables that make use of a continuing narrative, which affords students the opportunity to experience first-hand how any project can leverage expertise from multiple different fields to properly develop a functional solution. Please refer to the Resources section at the end of this document for location information regarding the central narrative file (case study) to be used for completing this assessment. Tasks: Your submission for this assessment will be formatted as a written report. Utilizing the Orders Schema, you are to address the following questions while referring to narrative section 6.4.1.1. "Orders Database" in your course's case narrative you will: Section A) 1. For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the primary key(s), foreign key(s) and candidate key(s) for the CustomerOrder table. - For this question, you only need to consider the relationship(s) between the CustomerOrder table and the tables within the Orders Schema. Do not refer to, or in any way utilize, tables outside of the Order Schema. 3. List all multivalued dependencies within the CustomerOrder table utilizing the following format: - Attribute Attribute 4. Transform the CustomerOrder entity [table] into the 4th Normal Form utilizing the following format: Entity(Attribute, Attribute, Attribute) - Underline the Primary Key(s) - Italicize the Foreign Key(s) Due Date: Please refer to the Instructional Plan for all assessment deadlines. Description: This assessment will make use of a central narrative (case study) file, please note that this case study may be unique to your intake, as such the answers generated will be exclusive to your cohort ensuring a customized experience and supporting academic integrity initiatives. This assessment has multiple objectives for student learning and skill(s) development: 1) This scenario will provide students with an academic-based case which is meant to; a. Establish an understanding of the relationship between data sets b. Identify the structure of data and how record sets are formed 2) This deliverable will afford course faculty a chance to gauge student preparedness and ability to; a. Understand the structure and relationship of data b. To work within a business setting to elicit clarification on data, and data structure design, concerns 3) This assessment is part of a series of deliverables that make use of a continuing narrative, which affords students the opportunity to experience first-hand how any project can leverage expertise from multiple different fields to properly develop a functional solution. Please refer to the Resources section at the end of this document for location information regarding the central narrative file (case study) to be used for completing this assessment. Tasks: Your submission for this assessment will be formatted as a written report. Utilizing the Orders Schema, you are to address the following questions while referring to narrative section 6.4.1.1. "Orders Database" in your course's case narrative you will: Section A) 1. For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the primary key(s), foreign key(s) and candidate key(s) for the CustomerOrder table. - For this question, you only need to consider the relationship(s) between the CustomerOrder table and the tables within the Orders Schema. Do not refer to, or in any way utilize, tables outside of the Order Schema. 3. List all multivalued dependencies within the CustomerOrder table utilizing the following format: - Attribute Attribute 4. Transform the CustomerOrder entity [table] into the 4th Normal Form utilizing the following format: Entity(Attribute, Attribute, Attribute) - Underline the Primary Key(s) - Italicize the Foreign Key(s)