Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

These questions are from DBMS subject. For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the

These questions are from DBMS subject.

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions