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

Virtual LANs

  Questions: A VLAN allows different devices to be connected virtually to each other as if they were in a LAN sharing a single broadcast domain. 1. Why a network engineer would want to deploy VLANs? 2. How do VLANs improve network security?

compliance and rules to follow in cybersecurity.

Follow the attached instructions to complete this work. Note: Make sure to follows rubric or aligns with Rubric. Unit 8 Assignment Directions: Case Study Review the following hypothetical case study. Consider the big-picture ideas and the specific concerns. Make use of the key terms and concepts from the readings in

Discussion on data ( computer science)

Follow the attached direction to complete this work Unit 7 Discussion   Overview Consider this scenario: PQR Corporation provides facial recognition technology to customers. Its products include customer access to consumer electronics as well as mass surveillance capabilities through networked camera systems. While operating legally, PQR has maintained a low

Computer Science – Machine Learning Python Programming Assignment

Assignment Help. Please don’t forget to add comments in the code Page 1 of 3 NorQuest College – CMPT 1011: Lab Assignment 5 CMPT 1011: Introduction to Computing Lab Assignment 2: Variables, mathematical operations and data types Value This coding challenge is worth 3% of your final grade. Background In

Public safety Communications

Subscribe The Communications and Cyber Resiliency Toolkit provides guidance for establishing resiliency measures, public safety communications can better withstand potential disruptions to service. This toolkit, developed by CISA, describes networks and systems critical to successful communication and cyber resiliency and possible threats while providing many resources and additional links for

Case Study 4 o Data (computer)

Follow the attached instructions to complete this work Unit 4 Case Study Directions Review the following case study. Consider both the big-picture ideas and the specific concerns. Make use of the key terms and concepts from the readings in your written responses to the questions below. The case study paper

Discussion 5 and 6

Follow  the attached instructions to complete this work Unit 5 Discussion   Overview In this discussion, you will be considering the emphasis on aspects such as privacy and safety. You will reflect on the significance of the legal concerns and goals of public-private partnerships to address cybersecurity. You will also

SQL injection

Hey! ????  I need an expert in SQL injection, DDOS attack, Code injection attack, XSS attack! To talk further please contact me on discord at mara411 so we can talk more freely and then I will hire you on here! Thanks ???? 

Free CAD, FeniCS or paraview

I have attached the picture and sample work too, I need work as like sampl, but not the copypasted Make sure you can ask me multiple questions but not dont do rubbish work

database

2. Final Assignment – equivalent to 4,000 words The final module mark is based on two deliverables focused on the CarNow case study described below. – 50% of the final mark a. An advisory report – 50 % of the final mark Includes 5% (of the module grade) given for

Computer

Documentation Tabula Insurance Agency ENTER AND UPDATE COMPANY DATA Author: Ashanti Joyner Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Personnel Tabula Insurance Agency Personnel: April 4-10, 2024 Employee Name Salary

Computer class

All information is below Toronto converted a declining part of the city into a vibrant neighborhood using the smart city 1.0 approach when a local technology company introduced electric shuttle buses to replace private cars and intelligent traffic lights to regulate the flow of pedestrians, bicycles, and vehicles. From Frankl,

Week 15

Read attachments for assignments  Week 14 Feedback Overall Feedback Well done on this assignment You will have to refine your tables and figures for your final submission. Always introduce them to the reader in preceding paragraph, properly create APA table, and cite figures. See Video:   APA Tables and Figures

Prof Double R

  PowerPoint Presentation: Narrative Presentation to the Board of Trustees The Centers for Medicare & Medicaid Services (CMS) has taken on a more visible role in health care. A great deal of change has transpired to improve patient safety and implementation of additional quality metrics. The new health care reform

Week 14

Please read attachments for details  image1.png

Week 13

Read attachments for details  The Finishing Touches – Week 13 Instructions For this week’s assignment you will submit the material discussed in the lesson plan and summarized below: · A refined introduction (Mandatory) · Updated Title Page (Mandatory) · Copyright Page with Declaration (Mandatory) · Dedication Page (Optional) · Acknowledgement

SCMT699

please read attachments for assignment  Feedback from week 10 Please address your design before your next submission.  Its how you are going to go about conducting your research so other can duplicate it. This is a good book on it. Creswell, J. W. (2009). Research design: Qualitative, quantitative, and mixed