Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Database

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:

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Project 3

To complete this assignment, review the prompt and grading rubric in the Project Three Guidelines and Rubric. When you have finished your work, submit the assignment here for grading and instructor feedback.

digital marketing

 Digital marketing involves promoting products and services using online platforms.The goal is to increase brand awareness and drive sales 

WEEK 2 DISCUSSION MR

 I UPLOADED IN THE FILE HOW THE ASSIGNMENT SHOULD FLOW AND ALSO THE ACCEPTABLE TOPICS FOR MY PROGRAM THAT U CAN SELECT FROM!  INSTRUCTIONS!! This week you considered study topics deemed acceptable for your program. For this discussion, share with your peers your initial thoughts on a topic you’d like

wk 2 practice models

INSTRUCTIONS!! Discuss the various practice models discussed in Chapter 3 of The Ernst and Young Business Plan GuideLinks to an external site.. What model is the most attractive for your own consultancy? Why? Do you see the model for your practice changing in the future?   READ CHAPTER 3!! OF THE

Computer Science Sustainable Development Goal and Mobile App Assignment

ATTACHED IS THE COPIED STATEMENT ON INTEGRATION OF FAITH AND WORK A s a university, we believe that the message of Jesus Christ bears profound implications, not only for individuals, but also for society and the ways that we as individuals live within it. The Lord Jesus instructed His followers

Intro Pogramming

After viewing the videos and listening to the information on programming, you should be ready to answer the questions listed below.     Your assignment is as follows:  I.   Access the Youtube videos:    Introduction to Programming Fundamentals (by Neso Academy).  You will be responsible for accessing the first 3 videos in

Disruptive technology and its impact on society (Discussion)

A discussion on disruptive technology and its impact on society 1) Discussion 1: Write a reflective response to the lesson on disruptive technology and its impact on society. (200-word minimum) Explore the impact on a macro and micro level looking at the impact on systems and structures as well as the

week 1 begin your

 I am a Kroger fulfillment delivery driver trainer / and I am also a TECH SUPERVISOR for spectrum whichever job you find easier to discuss about share something from your profession, job, or other source of inspiration that generated the idea for your project. What do you want to learn

project 2

To complete this assignment, review the prompt and grading rubric in the Project Two Guidelines and Rubric. When you have finished your work, submit the assignment here for grading and instructor feedback. For reference, refer to the CIA Triad and Fundamental Security Design Principles PDF document.

project 1

To complete this assignment, review the prompt and grading rubric in the Project One Guidelines and Rubric. When you have finished your work, submit the assignment here for grading and instructor feedback.

Final SWOT presentation

Concepts and Applications of Information Technology (IFSM201) Class Project Purpose of this Assignment The Class Project is the most significant assignment in this course, Concepts and Applications of Information Technology. As such, it accounts for 58% of the course points. This assignment is comprised of two deliverables: a SWOT Analysis

Wk4_411

Need help with a question. Due 10/7/2024 Based on your research, readings, and this week’s Learning Team assignment, create a 4- to 5-page sample penetration agreement for a banking institution using the major sections listed below and the purpose of each section. Include examples within each section. The major sections

Discussion 7 Social Networking

  Discussion Seven – Social Networking Social networking Web sites create online communities of Internet users that eliminate barriers created by time, distance, and cultural differences. These sites allow people to interact with others online by sharing opinions, insights, information, interests, and experiences.  Members may use the site to interact

Cap assign

Unit III Scholarly Activity Top of Form Bottom of Form Assignment Content Top of Form Purpose, Subject, Object, and Ethics In this unit, you will determine the purpose, subject, object, and ethical considerations of your case study, then assemble your findings in the  Unit III Case Study Outline Template .

project 3:

Support Queue Case Study Instructions:  Select two tickets from each level and explain how you would solve them. Name:  Level 1 Tickets Instructions:  Select two of the five scenarios to troubleshoot.  One template has been created for each of the two tickets you need to choose.  Make one to two

case

Write three pages of high-quality content for this case study, using the concepts discussed in class and any relevant external resources to support your analysis. Follow the instructions for your research problem carefully, as your argument and research will significantly impact your grade. Ensure that AI patterns do not exceed

cap dis

Discussion one (followed two responses later one is below) Part II: Think about a case study you would like to conduct. Identify the subject of your case study and the purpose of the study (see Tables 1.1 and 1.3 in the textbook for guidance). In addition, suggest at least two

journal

Contingency planning is an important part of the cybersecurity process. It is necessary to have a plan for mitigating and recovering from damage. In your journal, you will reflect on cryptography and contingency planning. Specifically, you will discuss cryptography, keys, algorithms, business continuity, and disaster recovery. Your journal entry should