Question

Database Design

Design a database and show the relationship between each tables. I need multiple tables. *Must meet the requirements for Third Normal Form.

These are the information for employee DB.

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.

Answer 1

Here is the design of the database

From the design of database, it can be said that above tables are not inter related to each other primarily but they can be joined to get the required data .

The tables are in the third normal form as

a) It is in second normal form.
b) All non primary fields are dependent on the primary key.
The above design confirms that.