Relational Database Design and Modeling for Software Engineers
Vote

0% completed

​

Introduction to Normalization

A college keeps one table for every enrolment. It holds which student takes which course. The course title and the instructor's office are copied into every row.

Dr Rao teaches Databases, and forty students take it. His office number, B-204, is now stored forty times.

Three things go wrong because of that one design choice, and all three have names.

You cannot insert a new course until a student joins it. The key is (Student_ID, Course_ID), so a course with nobody enrolled has no row to live in. This is an insertion anomaly.

**Moving Dr Rao to a new office means updating forty rows

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content