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\mathrm{.}4\mathrm{.}1\mathrm{.}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.

$3.$ List all multivalued dependencies within the CustomerOrder table utilizing the following format:

$$ Attribute $->->$ Attribute

$4.$ Transform the CustomerOrder entity $[$table$]$ into the $4$th Normal Form utilizing the following format:

$$ Entity $($PrimaryKey$,$ ForeignKey, Attribute$)$

$$

Underline the Primary Key$($s$)$

$$ Italicize the Foreign Key$($s$)$

Section B

Assume that you are contracted as a Business Analyst consultant with the client organization from the narrative.

$1.$ If you were to take on the task of updating the organizations database, enforcing the entity $[$table$]$ structure changes you indicated in the previous question$($s$),$ what questions would you want to ask the resident Database Administrator, or Business Manager, for clarification? Keep the following concepts in mind while drafting your questions:

$$ Scope: Keep a tight constraint on the topics$)$you are covering and ensure only value$-$added material is being elicited.

$$ Audience: Understand who you are speaking to and write for that audience and level of knowledge.

Write your work to appeal to the target audience.

Language: Professional level of written English skills goes a long way to ensure that no ambiguity or vagueness exists.

$2.$ Identify at least two $(2)$ potential issues found within any of the $4$ tables of the Orders schema $($CustomerOrder$,$ ShipmentMethod, OrderStatus, ProductSelection$).$ Be sure to clearly state what the issue is and how you would address these issues.