The lists given below show the types of functional dependencies and normalized forms.

•Functional Dependencies

1. Full functional dependency (FFD)

2. Partial functional dependency (PFD)

3. transitive functional dependency (TFD)

•Normalization

0. Unnormal Form (UNF)

1. First Normal Form (1NF)

2. Second Normal Form (2NF)

3. Third Normal Form (3NF)

Task: Your are required to find functional dependencies in each table in your data model. Then apply the process of normalization to refine the data model up to the third normal form (3NF).

Note: Please must mention the functional dependencies and then normalize data.

 

Note: Above is my Relational Schema You need to create tables and put your data as you want and then answer From it as per the requirement asked in a Task. You can simply use MS Word to create tables and to answer the question also you can give the handwritten answer or any other as your own choice. Please provide a complete, answer and with reasons so it will be easy to understand Thank you.

In some tables, things are created 2 times like in the reservation table cus_id two times you can consider one time as a foreign key only. Other table also have double attributes you can ignore 

Reservation reservation_id room_id check_in_date check_out_date hotel_id cus_id room_id (FK) cus_id (FK) Customer cus_id name country email Invoice invoice_id status amounts date cus_id payment_method payment_date description cus_id (FK) TodayPrice category_id available_rooms hotel_id (U) price date category_id hotel_id (FK) (FK) room_id Rooms category_id hotel_id (U) hotel_id (FK) category_id (FK) Rooms category category_id name Hotel hotel_id id name location