For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the…

For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the…

Question:

Transcribed Image Text:

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)
.
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 topic(s) 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 the CustomerOrder entity, or, the relationship that exists
between CustomerOrder entity and ProductSelection entity. Be sure to clearly state what the issue is and how
you would address these issues.

Expert Answer:

Answer rating: 100% (QA)

Solution Section A CustomerOrder Attributes OrderID CustomerID OrderStatusID ProductSelectionID Functional Dependencies OrderID CustomerID OrderID Ord
View the full answer