ECET 450: Laboratory 2 Lab 2 involves two parts. involves normalizing a small part of a DB. The steps to complete this exercise include getting the data items into 1NF, 2NF, and 3NF. The final step is to generate the ERD for the table or tables that are in the dependency diagram in 3NF. provides practice in the creation of realistic tables and their relationships using Oracle SQL*Plus and introduces writing SQL*Plus script files. This laboratory exercise creates a relatively simple invoice system using SQL statements. This DB schema is used throughout the next several weeks of laboratory exercises. The final product is an SQL script that makes it possible to initially create and re-create, if need be, the DB schema in order to do to the later laboratory exercises. Part A:This exercise involves normalizing a small part of a DB. The steps to complete this exercise include getting the data items into 1NF, 2NF, and 3NF. The final step is to generate the ERD for the table or tables that are in the dependency diagram in 3NF.Some small business wants to keep track of office furniture, computers, printers, etc. A sample of the ITEM records is shown below: Part B:This laboratory provides practice in the creation of realistic tables and their relationships using Oracle SQL*Plus and introduces writing SQL*Plus script files. This laboratory exercise creates a relatively simple invoice system using SQL statements. This DB schema is used throughout the next several weeks of laboratory exercises. The final product is an SQL script that makes it possible to initially create and re-create, if need be, the DB schema in order to do to the later laboratory exercises. Using your assigned user name, password, and host string, log in to Oracle SQL*Plus. Record your dialog with a spool file.Following the four requirements below, create the 5 tables shown later in this laboratory exercise, and enter all data as shown. Be sure to record your interactions with SQL*Plus using the spool command. REP Table CUSTOMER Table PRODUCT Table INVOICE Table LINE Table