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

I need an annotated bibliography written to this question: Between 1999 and 2007, how did gentrification affect the quality of life between African

I need an annotated bibliography written to this question: Between 1999 and 2007, how did gentrification affect the quality of life between African American and White Inhabitants in Downtown Oakland, I need an annotated bibliography written to this question: Between 1999 and 2007, how did gentrification affect the quality of

Project 2 – Multiclass Classification In this project you will explore some techniques in solving the supervised learning task of multiclass

Project 2 – Multiclass Classification In this project you will explore some techniques in solving the supervised learning task of multiclass classification. It is important to realize that understanding an algorithm or technique requires understanding how it behaves under a variety of circumstances. You will go through the process of

MODULE 10 RN Module 10 Content · Course Competencies: · Incorporate professional values, attitudes, and expectations

MODULE 10 RN Module 10 Content · Course Competencies: · Incorporate professional values, attitudes, and expectations regarding ageism when caring for the older adult. · Outline the importance of advocating for older adults in management of their care. Your supervisor provided some valuable feedback in response to your outline! They are

1. Go to: 2. Click on course “QMB4680” 3. On the Left Menu click on “Assignments” 4. Complete – HW#3 Chapter. 11 (2

1. Go to: 2. Click on course “QMB4680” 3. On the Left Menu click on “Assignments” 4. Complete – HW#3 Chapter. 11 (2 questions) 5. You can check your answer by clicking the red “Check answer” button. 6. You can also select “View an example” for reference. 7. If you

THE IMPACT OF NURSING INFORMATICS ON PATIENT OUTCOMES AND PATIENT CARE EFFICIENCIES In the Discussion for this module, you considered the interaction

THE IMPACT OF NURSING INFORMATICS ON PATIENT OUTCOMES AND PATIENT CARE EFFICIENCIES In the Discussion for this module, you considered the interaction of nurse informaticists with other specialists to ensure successful care. How is that success determined? Patient outcomes and the fulfillment of care goals is one of the major

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 1 Organization Design and Development (MGT 404) Due Date: 13/07/2024 @ 23:59 Course Name: Organization Design and Development Student’s Name: Course Code: MGT404 Student’s

This project will have you work together in groups to practice and demonstrate your leadership skills and team decision making in a 3 to 4-week

This project will have you work together in groups to practice and demonstrate your leadership skills and team decision making in a 3 to 4-week production simulation during our regular class time that will involve daily team huddles, assigning resources, data collection, data monitoring, and data reporting on your

ETHICS, CYBER ETHICS, AND SECURITY Transforming Nursing ETHICS, CYBER ETHICS, AND

ETHICS, CYBER ETHICS, AND SECURITY Transforming Nursing ETHICS, CYBER ETHICS, AND SECURITY Read a selection of your colleagues’ responses and respond to two of your colleagues by expanding upon their responses or sharing additional or alternative perspectives. PEER #1 · Courtney Cole Hiscox Challenges In today’s digital age, cybersecurity stands as a paramount

Follow instructions on the attached template, follow the rubric and answer all questions. Answer questions about asthma.

See attached doc Create prescriptions using the patient information, medications, and indications listed below. Your goal is to

See attached doc Create prescriptions using the patient information, medications, and indications listed below. Your goal is to demonstrate the accurate way to write a prescription that a patient would present to a pharmacy. The prescription should be written and signed. You will develop your mock prescriptions in a word document

Description ‫| كلية الحوسبة والمعلوماتية‬ College of Computing and Informatics IT Trends Research Trainee Information Student Name Student

Description ‫| كلية الحوسبة والمعلوماتية‬ College of Computing and Informatics IT Trends Research Trainee Information Student Name Student ID Student CRN Department 100 E-mail >90 70 Purchase answer to see full attachment

See docs Mental Health MindMap – Chose one of the topic and create your Mindmap. · Generalized anxiety disorder · Depression · Bipolar disorders ·

See docs Mental Health MindMap – Chose one of the topic and create your Mindmap. · Generalized anxiety disorder · Depression · Bipolar disorders · Schizophrenia · Delirium and dementia · Obsessive compulsive disease To earn full points, here are some tips: For

Ethical Paper 2: 6-8 pages As a leader in your organization, it is vital that you are familiar with the laws that regulate your industry. Sparked by the

Ethical Paper 2: 6-8 pages As a leader in your organization, it is vital that you are familiar with the laws that regulate your industry. Sparked by the dramatic corporate and accounting scandals of Enron, Arthur Andersen, Adelphia, and WorldCom, the Sarbanes-Oxley Act was implemented in 2002 in an effort

After the successful marketing and public relations campaigns your company created, the local Little League baseball organization has contacted the

After the successful marketing and public relations campaigns your company created, the local Little League baseball organization has contacted the athletic director about using the University’s facilities for the opening day ceremonies. This is a first for the school, so they have again contracted your company to help them

Investigate Henry Ford’s decisio to create $5 day. 3 main points 1. Provide historical background and content for 2.analyze a controversial decisio made

Investigate Henry Ford’s decisio to create $5 day. 3 main points 1. Provide historical background and content for 2.analyze a controversial decisio made including all.options available and the variou

Read a poem from this week making annotations as you go. Present 3-5 annotations in outline format and construct a 200 word close reading, as exampled on pages

Read a poem from this week making annotations as you go. Present 3-5 annotations in outline format and construct a 200 word close reading, as exampled on pages 308-309. Be sure to cite any quotations

Deliverable: Course Project Outline Your Course Project structure will include the following. Cover page (Include the course name and number, who you

Deliverable: Course Project Outline Your Course Project structure will include the following. Cover page (Include the course name and number, who you prepared the paper for, your name, and the date.) Course Project topic, outline, and project rationale (see below) Goals you want to achieve in this research (see below)

Are you a part of a professional organization? If so, which one? If not, which professional organization might you be interested in joining? What

Are you a part of a professional organization? If so, which one? If not, which professional organization might you be interested in joining? What type of civic engagement have you participated in, or what type of civic engagement might you be interested in participating in?

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