MIS710Module1bRelationalModelandNormalization.pptVIP

MIS710 Module 1bRelational Model and Normalization Arijit Sengupta Structure of this semester Today’s Buzzwords Relational Model Superkey, Candidate Key, Primary Key and Foreign Key Entity Integrity Rule Referential Integrity Rule Normalization First, Second, Third, and Boyce-Codd Normal Forms Unnormalization Objectives of this lecture Understand the Relational Model and its properties Understand the notion of keys Understand the use and importance of referential integrity Provide an alternative way to design relations using semantics rather than concepts Take an existing “flat file” design a