The lists given below show the types of functional dependencies and normalized forms. Functional Dependencies 1. Full
Question:
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
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill