Here are some nice links for important contents about database systems.
A nice and succinct tutorial on ERDs is as follows.
Valuable tutorials about normalization.
Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let’s discuss about anomalies first then we will discuss normal forms with examples. There are three types of anomalies that occur when the database is not normalized.
Here is a very nice course about database systems by MIT OCW.
Here is a nice course on Database management by Coursera.
A nice tutorial on 4NF.
Let’s look at the situation where redundancies can creep in even though a table is in Boyce-Codd normal form. Let’s take the student / instructor / course example used in that article, but change one of the initial assumptions.
A nice tutorial on 5NF.
There are normal forms beyond 4th that are mainly of academic interest, as the problems they exist to solve rarely appear in practice. This series won’t discuss then in detail, but for those interested, the following example provides a taste.
Fifth Normal Form – A database is said to be in 5NF, if and only if it is in 4NF anlong with additional conditions which are explained here.
If you found an error, highlight it and press Shift + Enter or click here to inform us.