IT 3233 Database Design and Implementation ****Normalization****

This project is based on Eagle Hotel International once again.

For problem 1 answer/do the following based on the relations provided below:

a) Label the type of dependencies that have already been identified.

b) Identify what normal form the relation is in and explain why. c) Identify a set of 3NF relations (draw the relational schema).

Create a Word document for your answers.

Problem 1: GENERAL_TABLE

Eagle Hotel would just like to see if you can normalize a relation by testing you with the following scenario.

If possible please draw out the Parts A,B, &C

Problem 1: GENERAL_TABLE Eagle Hotel would just like to see if you can normalize a relation by testing you with the following scenario. A B D F 1