Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me to solve this database query? Question 2 For the following User View, determine the UNF, 1, 2 and 3NF Kitchen Utensils

Can you help me to solve this database query?image text in transcribedimage text in transcribed

Question 2 For the following User View, determine the UNF, 1, 2 and 3NF Kitchen Utensils report MODEL#SERIAL# PRICE COLOR NAME YEAR 342 347 410 347 390 1234 1234 1234 1465 1465 1465 1465 1465 1623 1623 1623 1623 1623 1654 13.25 13.25 14.23 9.45 9.82 9.82 9.82 9.82 22.34 30.21 28.55 28.55 28.55 28.55 blue red red black black red red blue blue blue 392 401 409 311 pot pot pot pan pan pan pan pan kettle kettle kettle kettle kettle kettle 1974 1974 1975 1974 1976 1976 1976 1976 1973 1976 390 black 1975 410 423 428 435 black blue red 1975 1975 1975 UNF: 1NF: 2NF: 3NF: Question 3 For the following User View, determine the UNF, 1, 2 and 3NF Movie rental report FULL NAMES MOVIES RENTED SALUTATION PHYSICAL ADDRESS First Street Plot No 4 Janet Jones Ms. Robert Phil 3rd Street 34 Pirates of the Caribbean, Clash of the Titans Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Mr. Robert Phil 5th Avenue Mr. UNF: 1NF: 2NF: 3NF: Question 2 For the following User View, determine the UNF, 1, 2 and 3NF Kitchen Utensils report MODEL#SERIAL# PRICE COLOR NAME YEAR 342 347 410 347 390 1234 1234 1234 1465 1465 1465 1465 1465 1623 1623 1623 1623 1623 1654 13.25 13.25 14.23 9.45 9.82 9.82 9.82 9.82 22.34 30.21 28.55 28.55 28.55 28.55 blue red red black black red red blue blue blue 392 401 409 311 pot pot pot pan pan pan pan pan kettle kettle kettle kettle kettle kettle 1974 1974 1975 1974 1976 1976 1976 1976 1973 1976 390 black 1975 410 423 428 435 black blue red 1975 1975 1975 UNF: 1NF: 2NF: 3NF: Question 3 For the following User View, determine the UNF, 1, 2 and 3NF Movie rental report FULL NAMES MOVIES RENTED SALUTATION PHYSICAL ADDRESS First Street Plot No 4 Janet Jones Ms. Robert Phil 3rd Street 34 Pirates of the Caribbean, Clash of the Titans Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Mr. Robert Phil 5th Avenue Mr. UNF: 1NF: 2NF: 3NF

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Strayer University

1st Edition

0470603526, 978-0470603529

More Books

Students also viewed these Accounting questions

Question

Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago