present three advantages of using a DB rather than using file systems in a computer. Question 2 (ULO3): The table Shopping, shown below, is clearly not in 3NF. For this question, you must apply Data...

present three advantages of using a DB rather than using file systems in a computer.

Question 2 (ULO3):

The table Shopping, shown below, is clearly not in 3NF.

For this question, you must apply Data Definition Language (DDL) and Data Manipulation Language (DML) commands.

For this scenario:

1. Normalise the existing one table into a DB of three tables with 3NF: Item, Price, and Retailer. 2. Write the create command to create those three tables. 3. Run on Deakin’s Oracle database to finish following tasks: o Turns on the echo, e.g., set echo on; o Applies your sequence of DDL and DML commands to complete the transformation o Displays the new item table, e.g., select * from item order by item_ID; o Displays the new price table, e.g., select * from price order by retailer_ID, item_ID; o Displays the new retailer table, e.g., select * from retailer order by retailer_ID; o Displays the details of the new item table, e.g., desc item; o Displays the details of the new price table, e.g., desc price; o Displays the details of the new retailer table, e.g., desc retailer; o Turns off the echo, e.g., set echo off;