Consider the table above.

Identify the tables in their current normal forms (1, 2, 3 or no forms).

Follow the stepwise process an normalize the table and create a relations between the tables.

You are only responsible up to 3NF. Show step by step process.

Create dependency diagrams

Use conventional methods (all caps) to write the table name, primary key/s, functional

dependencies, partial dependency and transitive dependency. Purpose: Comprehend the normalization concept and implement in designing database.

Table name: RPT FORMAT PROU NUM PROU NAME EMP NMEMP NAME Evergreen 103 105 Alce K hnson . Database Designer ' 18 Amber Wave 114 Anne K. Ramoras Systems Analyst olling Tide 105 113 Delbert K. Joenbrood Applications Designer$48.10 236 107 Ralph B.Washington Systems Analyst 9 Consider the table above. Table name: RPT FORMAT PROU NUM PROU NAME EMP NMEMP NAME Evergreen 103 105 Alce K hnson . Database Designer ' 18 Amber Wave 114 Anne K. Ramoras Systems Analyst olling Tide 105 113 Delbert K. Joenbrood Applications Designer$48.10 236 107 Ralph B.Washington Systems Analyst 9 Consider the table above