Preventing Data Anomalies
The database development life cycle ooutlines the steps to creating a well considered solution. Shortcutting the process can lead to undesirable results and wasted efforts. Careful consideration can actually protect the database from mistakes and discrepancies.
Removing duplicate infromation
inconsistencies and anomilies.
Duplicate records should be put into another table.
- We remove the column that is not dependent on the main topic of the table and place into the new table.
Remove the dependent column
- Then we make the copy of the column that it was dependent on and place that into the table alongside.
Copy the subject column