Structure Analysis Customer Order Table Dependencies Assignment

Assignment Task

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:

• This scenario will provide students with an academic-based case which is meant to;
  1. Establish an understanding of the relationship between data sets
  2. Identify the structure of data and how record sets are formed

• This deliverable will afford course faculty a chance to gauge student preparedness and ability to;
  1. Understand the structure and relationship of data
  2. To work within a business setting to elicit clarification on data, and data structure design, concerns 
• 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

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 
2. List out the primary key(s), foreign key(s) and candidate key(s) for the CustomerOrder
   • 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 
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(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
   • 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

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

This It Computer Science have been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.