Answered step by step
Verified Expert Solution
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?
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: 3NFStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started