This week we are covering one of the important database design concepts which is

Question

This week we are covering one of the important database design concepts which is normalization. Discuss the following topics:

1. Data Anomalies - Explain in your own words using tables from your lab project. Also describe how such anomalies could be prevented.

2. Normalization - Assume that you have not read this lecture and you have created your lab project (tables). Do you think your tables in your project are normalized? Explain how this session helped your project? What are your thoughts on normalization?

Explanation / Answer

1.Data anomalies are the issues or issues which can happen in un-normalized databases which might be ineffectively organized.This sort of databases can have every one of the Data put away in one table.Data irregularities can be of 3 sorts: embed, erase, and refresh.

I might want to talk about Insert Anomaly.It can happen when Data can not be embedded into a database because of other missing data.This is most basic for fields where an outside key must not be NULL, but rather does not have the suitable data.An case of this oddity can be clarified with a straightforward user databaseo

1.A user must have a gathering IDas a remote keyo
2.No gatherings have yet been createdo
3.Thus, a user can not be embedded in to the database as the gathering IDmust not be NULL

This can bring about Data repetition because of the oversight of Data.

Data Anomalies can happen when you don't completely design out the database and think about the setting of the data.A segment of Data or Data segment may cause a repetition on account of the absence of association with Data that is unavailableto the user.For case, inside my database if I somehow managed to erase tolerant going to dates then the protection guarantee association would wind up noticeably out of date on the grounds that keeping in mind the end goal to make a claim a date of arranged visit should be recorded.

2.Database normalization is the way toward arranging Data into tables such that the consequences of utilizing the database are constantly unambiguous and as intended.I believe that on the off chance that I have made the lab venture tables, at that point there are conceivable outcomes that they are not normalized.It may deliver the unambiguous or unintended outcomes.normalization is an efficient approach of breaking down tables to dispose of Data repetition and unwanted qualities like Insertion, Update and Deletion Anomalies.It is a multi-step process that places Data into forbidden frame by expelling copied Data from the connection tables.The primary objectives ofnormalization are to dispense with excess Data and to guarantee that Data reliance bodes well. i.e. Data is legitimately put away.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.