Question: 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?Can you help me to solve this database query? Question 2 Forthe following User View, determine the UNF, 1, 2 and 3NF Kitchen

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!