Database Systems

Here are some nice links for important contents about database systems.

A nice and succinct tutorial on ERDs is as follows.

What is entity relationship diagram? – Definition from WhatIs.com

A Quick Guide to Database Normalizing with First Normal Form (1NF)

Valuable tutorials about normalization.

Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database

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.

1NF, 2NF, 3NF and BCNF in Database Normalization | DBMS Tutorial | Studytonight

 

Here is a very nice course about database systems by MIT OCW.

Database Systems

 

Here is a nice course on Database management by Coursera.

Database Management Essentials – University of Colorado System | Coursera

A nice tutorial on 4NF.

Database Normalization: 4th Normal Form

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.

Database Normalization: 5th Normal Form and Beyond

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 (5NF) – 5NF in DBMS – 5NF in Database

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.

Photo by benjami

If you found an error, highlight it and press Shift + Enter or click here to inform us.

CC BY-NC-ND 4.0 Database Systems by Psyops Prime is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

16 comments

  1. “Your style is so unique in comparison to other people I’ve read
    stuff from. Thanks for posting when you hav the opportunity,
    Guess I will just bookmark this page.”

  2. Definitely believe that which you stated. Your favorite reason seemed to be on the net the easiest thing to be aware of. I say to you, I definitely get annoyed while people think about worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks

  3. Thanks for some other informative web site. The place else
    could I am getting that type of info written in such
    an ideal means? I have a venture that I am just now working on, and I’ve been on the glance
    out for such information.

  4. I will immediately snatch your rss as I can not find your e-mail subscription hyperlink or newsletter service. Do you’ve any? Please permit me recognise in order that I may just subscribe. Thanks

Leave a Reply