Using the types of entities found in the attached database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form, justify your answer and show how to convert to the higher forms
Using the types of entities found in the attached database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form, justify your answer and show how to convert to the higher forms
Normalization and Normal Forms - Normalization in the database is a process to reduce and remove redundancy in other words it is a process to divide a large table into smaller tables. There are four types of Normal forms 1NF, 2NF, 3Nf and BCNF. A normalized database removes undesirable anomalies from the database.
A relation that contains atomic values is said to be in 1NF form. 1NF form does not allow multiple values for a single attribute. Whereas if a relation is in 1NF and all non-key attributes are fully functional dependent on the primary key then this type of relationship is said to be in 2NF.
Step by step
Solved in 3 steps
