Our Services

Get 15% Discount on your First Order

Instructions are attached. CMIS 320 Project 4 Examine the following relation and its attributes and answer the following questions. Assume these a

July 22, 2024

Instructions are attached.

CMIS 320 Project 4

Examine the following relation and its attributes and answer the following questions. Assume
these are the values for “all time”. Assume girls with the same name are the same person.

GIRL GROUP AGE GAME CATEGORY PRICE
Charlotte 5 year olds 5 Mirror Makeup 4.88
Susan 6 year olds 6 Lipstick Makeup 5.95
Jane 5 year olds 5 Chess Games 7.55
Susan 6 year olds 6 Checkers Games 5.95
Susan 6 year olds 6 Mirror Makeup 4.88
Carrie 6 year olds 6 Lipstick Makeup 5.95
Jacqueline 5 year olds 5 Visual Basic Prog. Languages 199.99

For each question below, please be sure to review the course content for additional reference
material.

1. Is this relation in at least 1NF? Why or why not?

2. What is the primary key of the initial relation (assume the values shown are the only
possible tuples for all time)? Remember that a primary key must be unique and not null.

3. Describe the specific data anomalies that exist if we DELETE the tuple containing
Jacqueline.

4. Draw a functional dependency diagram for the initial relation. This diagram should agree
with the primary key you selected in above. This can be drawn in any drawing tool. Be
sure to identify dependencies like full, partial, transient, etc. between the attributes.

5. Based on your diagram, what normal form is the initial relation in? Why?

6. If necessary, decompose the initial relation into a set of non-loss 3NF relations by showing
the relations, attributes, and tuples. Show complete relations with attribute headings and
all data values in the tuples of your relations. Determine the number of 3NF relations you
end up with after normalization, write this number, and then circle the number.

Additional References:

• What is Normalization?
• What is a Primary Key?
• What are data anomalies?
• The Third Normal Form.

Assignment-4’s grading rubric:

Attributes Meets Does Not Meet

Normal form
45 points
Student correctly identifies normal form
of initial relation.

0 points
Major error in identification of normal
form or not specified.

Primary key
60 points
Student correctly identified primary key
of initial relation.

0 points
Major error with identification of primary
key or not specified.

Data anomalies
30 points
Student correctly describes data
anomalies.

0 points
Major errors with description of data
anomalies or not specified.

Functional dependency
diagram

30 points
Student correctly develops functional.
dependency diagram of initial relation.

0 points
Major errors developing functional
dependency diagram or not specified.

Normalized 3NF relations
60 points
Student correctly develops the proper
set of 3NF relations via normalization.

0 points
Major errors in development of proper
set of 3NF relations or not specified.

CMIS 320 Project 4
Assignment-4’s grading rubric:

>Computer Science homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

JWI 550: Operational Excellence Assignment 1 © Strayer University. All Rights Reserved. This document contains Strayer University confidential and

JWI 550: Operational Excellence Assignment 1 © Strayer University. All Rights Reserved. This document contains Strayer University confidential and proprietary information and may not be copied, further distributed, or otherwise disclosed, in whole or in part, without the expressed written permission of Strayer University. This document is subject to change

Library Research Assignment A strategic component and responsibility of the human resources department is the management of the people of the organization,

Library Research Assignment A strategic component and responsibility of the human resources department is the management of the people of the organization, which is frequently called human capital m

Write the clinical write up for a psychiatric fictitious patient .32-Year-Old female With Post-Traumatic Stress Disorder (PTSD),. Stable Patient.

Write the clinical write up for a psychiatric fictitious patient .32-Year-Old female With Post-Traumatic Stress Disorder (PTSD),. Stable Patient. Follow up. Currently in Psychotherapy. Form attached.

Please see the attached legal case: 1) the case summary and 2) full indictment: please note that you don’t have to read the full indictment.please use it

Please see the attached legal case: 1) the case summary and 2) full indictment: please note that you don’t have to read the full indictment.please use it for the reference while you answer the following questions. Provide a brief summary of the case Identify financial loss/any victimization and damages due

Explore key economic theories, models, and trends, and how they impact decision making processes at different levels, vis-s-vis, micro, macro and

Explore key economic theories, models, and trends, and how they impact decision making processes at different levels, vis-s-vis, micro, macro and international. • Analyze the functioning of the market and the role of business in the international arena. • Interpret various economic indicators across different levels of analysis. • Develop

Due: Sunday, 11:59 p.m. EST Points: 100 Overview: Write a research paper based on the topic chosen. Answer the topic question and support your opinion

Due: Sunday, 11:59 p.m. EST Points: 100 Overview: Write a research paper based on the topic chosen. Answer the topic question and support your opinion with appropriate resources. Instructions: The essay must have the following components:  An Introduction that briefly sets up the topic and states the premise of

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Quality Management (MGT 424) Due Date: 03/08/2024 @ 23:59 Course Name: Quality Management Student’s Name: Course Code: MGT 424 Student’s ID Number: Semester:

Project 3 instructions– Assess and revise recipes (File upload) Note: This Assessment flows

Project 3 instructions– Assess and revise recipes (File upload) Note: This Assessment flows from information obtained as a result of Role Play 2 and the recipes developed for Project 2. General learner instructions You are required to provide a written report with evidence attached that proves you have assessed one

Instructions In this assignment, you will be required to use the Heart Rate Data Set to

Instructions In this assignment, you will be required to use the Heart Rate Data Set to complete the following: · Use the classification of variables from the Unit 1 assignment to match each variable to one appropriate type of graph · Create graphs of those variables · Give a brief

This week is another blended week. In the developed countries of the world, we are living longer than at any time in history. While this is definitely a

This week is another blended week. In the developed countries of the world, we are living longer than at any time in history. While this is definitely a plus for those of use in our later years, it also has resulted in more of those individuals over fifty living longer

What 5 interest groups affect your life? What are the issues that this interest group would support and lobby the government about? How would this affect

What 5 interest groups affect your life? What are the issues that this interest group would support and lobby the government about? How would this affect domestic policy? Do interest groups have too much control over domestic policy? **When answering these questions they need to be answered on how as

View minute mark 8:00 to 14:32 of the following CDC video (2020) on the Six Principles of Crisis and Emergency Risk Communication (CERC) Webinar April

View minute mark 8:00 to 14:32 of the following CDC video (2020) on the Six Principles of Crisis and Emergency Risk Communication (CERC) Webinar April 6, 2020 – CERC Overview for COVID-19 (cdc.gov) Explain whether or not you believe local, state, or federal government adhered to the six principles of

Statistics final exam on Pearson. 22 questions 150 minutes.

In what area of imagination and the arts do you have personal interest and skills? How would you share that with children? How would you plan lessons

In what area of imagination and the arts do you have personal interest and skills? How would you share that with children? How would you plan lessons for children to help them discover their own interests in Imagination and The Arts?

As you prepare to create your legitimate budget for your Week 8 assignment, where are the areas that align well with your existing agency budget and

As you prepare to create your legitimate budget for your Week 8 assignment, where are the areas that align well with your existing agency budget and where are their conflicts? Consider whether new staff will be hired. Who will be responsible for the benefits part of the salary. If salary

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an emergency

75 y.o. patient diagnosed with heart failure is seen in cardiac office for worsening of shortness of breath. He has difficulty completing sentences

75 y.o. patient diagnosed with heart failure is seen in cardiac office for worsening of shortness of breath. He has difficulty completing sentences and has productive cough. He has increased difficulty in self-care. On assessment noted bilateral crackles, +3 pedal edema, jugular vein distention. He states he takes his medications

Our Services

Instructions are attached. CMIS 320 Project 4 Examine the following relation and its attributes and answer the following questions. Assume these a

Share This Post

Related Questions

Use Our 6 Free Tools