Using MySQL 8.xx create a database with the following characteristics. DO NOT USE WORKBENCH FOR THIS LESSON.

A. Your design MUST meet the requirements for Third Normal Form, see videos related to this section to determine what makes a database meet these standards.

B. Create a database (you will need multiple tables) to store employee information. This information will include:

Employee Number, First Name, Last Name, Date of birth, Address, city, state, zip, department, job title, supervisor, health insurance number, health insurance provider, dental insurance number, dental insurance provider, spouse/partner, children, children's ages.

C. Populate the table with multiple records which will cover all possible relations.

Note: Determine which fields are required and which fields are optional. Determine the correct data types and sizes for each field. Include the 'relationships' between the tables. Hint: You will need some secondary key fields to link tables together.

What to turn in:

Screenshots (only)

1. Database table metadata showing table names, column names, data types, and sizes.

2. Map of relations between tables (tables with arrows between them).