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.

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. Reaction Code Reaction Name L Like He Heart S Sad A Angry Hp Happy Description Default Reaction Positive Reaction Negative Reaction Negative Reaction Positive Reaction Your FB ID Your Friends Name 1 Bryan 5 Mike 1 Ana 1 Bell Your FB Name Christian King Christian Christian Friends Since 2/4/2015 12/19/2015 2/4/2015 5/4/2020 Flight Date Aircraft Code BOE123 BOE123 BOE123 Passenger Valid ID 1/1/2020 SSS1234 1/1/2020 TIN1234 1/1/2020 PHEALTH22 Passenger Name Mike Sandy Ryan Aircraft Code BOE123 BOE234 BOE234 Flight Date Number of passengers Aircraft 1/1/2020 100 Boeing 123 1/2/2020 120 Boeing 234 1/3/2020 130 Boeing 234 Flight Description Manila-London Manila-Perth Perth-Manila Function Room Capacity Wedding 100-150 Christening 10-40 Business 10-40 Capacity Type Large Medium Medium 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. Reaction Code Reaction Name L Like He Heart S Sad A Angry Hp Happy Description Default Reaction Positive Reaction Negative Reaction Negative Reaction Positive Reaction Your FB ID Your Friends Name 1 Bryan 5 Mike 1 Ana 1 Bell Your FB Name Christian King Christian Christian Friends Since 2/4/2015 12/19/2015 2/4/2015 5/4/2020 Flight Date Aircraft Code BOE123 BOE123 BOE123 Passenger Valid ID 1/1/2020 SSS1234 1/1/2020 TIN1234 1/1/2020 PHEALTH22 Passenger Name Mike Sandy Ryan Aircraft Code BOE123 BOE234 BOE234 Flight Date Number of passengers Aircraft 1/1/2020 100 Boeing 123 1/2/2020 120 Boeing 234 1/3/2020 130 Boeing 234 Flight Description Manila-London Manila-Perth Perth-Manila Function Room Capacity Wedding 100-150 Christening 10-40 Business 10-40 Capacity Type Large Medium Medium