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

Follow all Instructions for the Community Assessment Plan This is for the grant Transitional Living Program Grant for youths/adults ages 16-22. A need

Follow all Instructions for the Community Assessment Plan This is for the grant Transitional Living Program Grant for youths/adults ages 16-22. A need statement is an important part of a grant proposal. It describes the reasons the grant is needed and makes a case for why support should be provided.

Description College of Administration and Finance Sciences Form No 4- Internship Report Cover Page For Instructor’s Use only Instructor’s

Description College of Administration and Finance Sciences Form No 4- Internship Report Cover Page For Instructor’s Use only Instructor’s Name: Total Training Hours /280 Students’ Grade: Marks Obtained /30 Level of Marks: High/Middle/Low Academic Report Guideline(Co-op) (please do not include this text in the final report, just follow its guidelines

Description Discussion Question: Discuss “internal and external validity errors that researchers should focus while conducting a

Description Discussion Question: Discuss “internal and external validity errors that researchers should focus while conducting a research study”. Instructions for Completing the Discussion Questions: Post your original response by Tuesday 30 April 2024 Your response should be a minimum of 5 sentences but should not exceed 250 words. Appropriately cite

Imagine that you have spent years doing the work you are meant to do. It’s stressful, but you think you manage it well. You always wanted to help people.

Imagine that you have spent years doing the work you are meant to do. It’s stressful, but you think you manage it well. You always wanted to help people. Their suffering is one of your main driving factors in choosing this path. However, you notice that you have recently started

Discussion Elucidate the brain structures and neurotransmitters/hormones involved in initiating/maintaining sleep and those

Discussion Elucidate the brain structures and neurotransmitters/hormones involved in initiating/maintaining sleep and those involved in waking/arousal. Explain insomnia from a neurobiological perspective. Response Parameters Initial Post · Each initial post should include a minimum of 250 words of actual text (i.e., the 250 word minimum does not include your reference)

Diversity issues extend beyond those of race and ethnicity. As educators, you must be able to address issues such as age and gender. As the societal

Diversity issues extend beyond those of race and ethnicity. As educators, you must be able to address issues such as age and gender. As the societal definition of gender changes, so must the instructional strategies you incorporate in lessons. you will design a lesson plan that focuses on promoting equity

Being Candid and Honest Chapter Six Informed Consent A primary reason clients seek therapy is often because the feel incapable of

Being Candid and Honest Chapter Six Informed Consent A primary reason clients seek therapy is often because the feel incapable of exercising rational, self-determination of their personal circumstances, emotions, thoughts, and deeds (i.e., nonautonomous). Therapist who fail to involve the client in the therapeutic decision-making process, by keeping them informed,

EDUC 872 CURRICULUM PLAN CRITIQUE ASSIGNMENT INSTRUCTIONS OVERVIEW The purpose of this assignment is for you to critique a curriculum plan based

EDUC 872 CURRICULUM PLAN CRITIQUE ASSIGNMENT INSTRUCTIONS OVERVIEW The purpose of this assignment is for you to critique a curriculum plan based upon what you have learned in this course by describing the strengths or weaknesses of the curriculum plan. You will evaluate and critique one curriculum plan three separate

Due Date: Sunday by 11:59pm Total Points: 100 Overview: Create a Schedule Management Plan for your project. Instructions: Your selected

Due Date: Sunday by 11:59pm Total Points: 100 Overview: Create a Schedule Management Plan for your project. Instructions: Your selected project can be either a personal or professional example, but please do not choose a project you have used for any other class or project, or that you are currently

Subject : Wine bar Business Plan – The business plan describes the opportunity that you have uncovered and how you will take advantage of that

Subject : Wine bar Business Plan – The business plan describes the opportunity that you have uncovered and how you will take advantage of that opportunity. It is a form of storytelling that will persuade readers of the feasibility of the idea. One of the most significant reasons to

Explain how health care reform has helped shift the focus from a disease-oriented health care system to one of wellness and prevention. Discuss ways in

Explain how health care reform has helped shift the focus from a disease-oriented health care system to one of wellness and prevention. Discuss ways in which health care will continue this trend and explain the role of nursing in supporting and facilitating this shift.

With respect to the supply chain, discuss the terms Just-in-time (JIT) & Materials Requirements Planning (MRP). How are they related to maintaining

With respect to the supply chain, discuss the terms Just-in-time (JIT) & Materials Requirements Planning (MRP). How are they related to maintaining proper levels of inventory?

Description Page 1 Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University المملكة العربية السعودية وزارة التعليم الجامعة

Description Page 1 Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University المملكة العربية السعودية وزارة التعليم الجامعة السعودية اإللكترونية College of Administrative and Financial Sciences Assignment 1 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 13/7/2024 @ 23:59 Course Name: Business ethics and organization social responsibility

Assignment 3 – Vision to Reality Vision and effective communication skills are essential parts of effective

Assignment 3 – Vision to Reality Vision and effective communication skills are essential parts of effective leadership. Write a paper on this issue. 1. Discuss your concept of vision and why you think it is important. 2. Discuss reason(s) why communication is important in the creation of a vision and

Running head: TITLE GOES HERE 1 TITLE OF THE PAPER GOES HERE

Running head: TITLE GOES HERE 1 TITLE OF THE PAPER GOES HERE 5 Title of the Paper Goes Here Student Name ACC 5301 Management Applications of Accounting Instructor Date Abstract The Abstract is an overview of the paper, written after completion. Other researchers use the abstract to determine if your

Instructions: Due Wed 05/8 At least 3 paragraphs long with 3 peer-reviewed references. 2: Based on authoritative sources (including peer

Instructions: Due Wed 05/8 At least 3 paragraphs long with 3 peer-reviewed references. 2: Based on authoritative sources (including peer reviewed articles from the library, Fraud Examiners Manual, etc), discuss a recent court case (within the last 3 years) where there was a breach of ethical standards that caused fraud

Upload in the format of a Word document answers to the Discussion and Critical Thinking questions in the Callaway textbook. Include: Chapter 15, #1.

Upload in the format of a Word document answers to the Discussion and Critical Thinking questions in the Callaway textbook. Include: Chapter 15, #1. Instead of #2, answer this: Discuss the various services the ASRT provides the imaging community. #3 and 4. Additional question #5: Use a search engine and research our state’s professional

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