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

4/6pg

Your company Acme Logistics has recently been experiencing some thefts of equipment during the business day. All employees have been asked about the thefts and no one is claiming that they are responsible. Your facilities has three doors that are not locked during business hours and currently have no identification

Computer program

Kenya Forestry College [email protected] P.O. BOX 8 -20203, Londiani Tel .No.0202349901, 07232262 APPLICATION FOR TRAINING PROGRAMMES 2019/2020 Applications are invited for the following training programmes to be offered at Kenya Forestry College, Londiani commencing on the given dates. S/ n Programme Entry Requirements Duration Commencement Date Total Cost (Ksh) 1

Wk5_492

Need help with a question. Imagine that you are hired as an Ethical Hacking Consultant by your organization. You are asked by the top management to compare two object-oriented programming languages and create a presentation about your findings and suggestions. Use your problem-solving skills and  integrate your knowledge of web application testing

Computer Science

What is computer science  Science? what is the benefit of computer science?

6/8p

Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION 2 Research Paper Topic: · Legal and legislative issues associated with biometric industry Instructions: · Prepare a 6-8 page paper in Microsoft Word using approved APA format. · The minimum page count cannot not include your Title page and Reference list. ·

week 7 Discussion and Replies

Please review the instructions for the assignment     WK7 Discussion Instructions: Database Failures and Timestamp Protocol  250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 19 Dec 24.  1. Discuss the different types of failures. What is meant by catastrophic failure? 2.

Capstone B

Assessment 1 & 4 This file is too large to display.View in new window

hrmt

  how can organizations address change management in the workplace such that healthy stress is created? Be creative in your answer! You may find appropriate articles at the end of each chapter, and/or identify articles through the APUS online Library. Finally, be sure that all discussions are answered in full,

help

can u build a project for me based on the description given  below

help

can u build a project for me based on the description given  below

apple vs fbi

read this article Explain, based on the article and additional research, whether you agree with the FBI or Apple and why. Describe a possible compromise to the issue for future cases that would allow the investigation to continue. Take a position on whether technology is moving too fast for the

excel module 3

who can complete homework  assignment  by 4pm today  excel module 3 Documentation Shelly Cashman Excel 2019 | Module 3: SAM Project 1a Raybridge Recruiting CREATE A SALES REPORT Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new

excel module2

who can complete this assignment by 4pm today  Documentation Shelly Cashman Excel 2019 | Module 2: SAM Project 1a Roadrunner Online FORMAT WORKSHEETS Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from

Excel module 1

can anyone complete this ASAP or by tomorrow Documentation Shelly Cashman Excel 2019 | Module 1: SAM Project 1a New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy

bcis

IfSuccessful_Status GA_Status_Icon SAM_Logo true false ID FirstName LastName AssignmentGUID UserID false rohan maharjan {308B14B0-E32E-42D1-BE7D-54EE2E09B8CD} {308B14B0-E32E-42D1-BE7D-54EE2E09B8CD} ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder ConsultantID FirstName Last 110345 Jenette Masterson 110347 Victorina Hogg 110349 Marguerite Hathcock 110351 Sid Ortiz 110352 Glenn Testani

WK6 Discussion

Please see attachment instructions to complete the assignment.     WK6 Discussion Instructions: Cost Functions and Record Lengths    250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 15 Nov 24.  1. Discuss the different types of parameters that are used in cost

Enterprise Networking

ICT3051 Enterprise Networking Week-8 Laboratory Practicum 1 Configuring Quality of Service Task Use the following video to configure your own packet tracer file. Make sure everything in it works. Name the file with your name and student id. Reflect on the configuration experience by explaining what kind of problems you

Scott Tyree (2002)

You have been asked to conduct research on a past forensic case to analyze how digital data was used to solve the case Scott Tyree (2002). Summarize the case, pertinent actors, evidence, and facts. Outline the specific digital evidence used in the case. Describe the procedures and tools used to