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

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. 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.

Answer rating: 100% (QA)

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