Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Determine the functional dependencies and split them into different schemes to be in 2nd Normal Form. There are questions that are already in 2nd Normal
Determine the functional dependencies and split them into different schemes to be in 2nd Normal Form. There are questions that are already in 2nd Normal Form hence you don't need to split the scheme.
Provide description to your answers by explaining it and describing some assumptions you use to build your 2NF scheme. It is also important to determine the Primary Key.
Example:
1.
2.
3.
4.
5.
Thank you
Functional Dependencies Example: Price Quantity 50000 300 Order # Order Line Product Code 1 1 LAPTOP_ABC 1 2 MOUSE 1 1 3 KEYBOARD_A 2 1 EXTERNAL HD1 2 2 EXHAUST_234 2 3 FLASH D 800 Order Date 6 6/2/2020 4 6/2/2020 2 6/2/2020 6 9/9/2020 5 9/9/2020 2 9/9/2020 4000 500 550 Answer {Order #, Order Line} -> {Product Code, Price, Quantity} {Order #} -> {Order Date} In the original scheme, the Primary Key is a combination of Order # and Order Line Order Date only depends on Order # and not on Order Line, as there will be no instance to have different Order Date per Order line under same Order #. Imagine when you order multiple items in Fast Food, do you have many order dates in receipt? Only one order date will show there. Hence, Order Date does not depend on Order Line. Course Room 204 Course BSIT BSCS BSIT Section Code BSIT191 BSCS456 BSIT200 Course Name Adviser BS Information Technology Mr. Chu BS Computer Science Mr. Lee BS Information Technology Mr. Chu 300 204 School ID NU123 MU234 UP678 Campus Code NUF MUM UPD Location SM Fairview QC Intramuros Manila Diliman QC President/CEO Mr. Tan Ms. So Ms. Sy School Name National U Mapua U Univ of the Philippines Student ID 2020-001 2020-002 2020-003 First Name Mike Paul Ryan Last Name Santos Sy So Phone Number 19320484 43242352 24282474 Customer Date Inquiry Customer Time Inquiry Assigned Frontliner 3/4/2017 1:00 PM EMP11 3/4/2017 1:00 PM EMP09 3/6/2017 2:00 PM FMP11 Customer Inquiry Detail Room Change Room Change Function Room Reservation Frontliner Name Mike Ryan Sandv Price Category BFAST BFAST BFAST Type FISH VEG PORK Description Fish Silog Veggie Rice Fried Dumplings Type Name 200 Fish 130 Vegetables 80 Pork Category Name Breakfast Breakfast Breakfast Functional Dependencies Example: Price Quantity 50000 300 Order # Order Line Product Code 1 1 LAPTOP_ABC 1 2 MOUSE 1 1 3 KEYBOARD_A 2 1 EXTERNAL HD1 2 2 EXHAUST_234 2 3 FLASH D 800 Order Date 6 6/2/2020 4 6/2/2020 2 6/2/2020 6 9/9/2020 5 9/9/2020 2 9/9/2020 4000 500 550 Answer {Order #, Order Line} -> {Product Code, Price, Quantity} {Order #} -> {Order Date} In the original scheme, the Primary Key is a combination of Order # and Order Line Order Date only depends on Order # and not on Order Line, as there will be no instance to have different Order Date per Order line under same Order #. Imagine when you order multiple items in Fast Food, do you have many order dates in receipt? Only one order date will show there. Hence, Order Date does not depend on Order Line. Course Room 204 Course BSIT BSCS BSIT Section Code BSIT191 BSCS456 BSIT200 Course Name Adviser BS Information Technology Mr. Chu BS Computer Science Mr. Lee BS Information Technology Mr. Chu 300 204 School ID NU123 MU234 UP678 Campus Code NUF MUM UPD Location SM Fairview QC Intramuros Manila Diliman QC President/CEO Mr. Tan Ms. So Ms. Sy School Name National U Mapua U Univ of the Philippines Student ID 2020-001 2020-002 2020-003 First Name Mike Paul Ryan Last Name Santos Sy So Phone Number 19320484 43242352 24282474 Customer Date Inquiry Customer Time Inquiry Assigned Frontliner 3/4/2017 1:00 PM EMP11 3/4/2017 1:00 PM EMP09 3/6/2017 2:00 PM FMP11 Customer Inquiry Detail Room Change Room Change Function Room Reservation Frontliner Name Mike Ryan Sandv Price Category BFAST BFAST BFAST Type FISH VEG PORK Description Fish Silog Veggie Rice Fried Dumplings Type Name 200 Fish 130 Vegetables 80 Pork Category Name Breakfast Breakfast BreakfastStep 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