Create a scalable database that will grow as the company grows. (An inner join combines records from two tables based on a join predicate and returns rows from columns specified in the SELECT statement that satisfy that predicate). Grey shaded area should represent values that are returned by an inner join. Duplicate values might be returned.

You need to create and submit spreadsheets in Microsoft Excel that accomplish the following:

Display a database table in first normal form that will store all of the information listed above. Identify a field or fields to act as the primary key by bolding that field name. Enter all of the provided information into the table in the spreadsheet.

Save your spreadsheet as M3_A2_Lastname_Firstname_FirstNormalForm.xls.

Decompose the table you created in Step 1 to second normal form. Place each table in its own sheet within the spreadsheet. Identify a field or fields to act as the primary key in each table by bolding that field name. You may insert a new field to act as the primary key if you feel it is warranted. Enter all of the provided information into the appropriate table in the spreadsheet.

Store the following information within the database:

Information Required	Maximum Value
Employee ID	6 integers
Employee Last Name	30 characters
Employee First Name	30 characters
Street Address	60 characters
City	30 characters
State	2 characters
ZIP Code	5 integers
Department	30 characters
Manager	60 characters
Position	30 characters
Salary	8 integers