OMIS 452 | 40 Quiz Questions on Keys, Dependencies, Normal Forms, Anomalies

This document includes 40 fully solved quiz questions and answers from Quizzes 3 and 4 of OMIS 452 at Northern Illinois University. It serves as a targeted study resource for understanding relational database structures and data integrity principles. The content focuses on key foundational topics like primary keys, foreign keys, surrogate keys, composite keys, and candidate keys, as well as functional dependencies and referential integrity constraints. Advanced normalization concepts are also covered in depth—from 1NF to 5NF, BCNF, and domain key normal form. Definitions of important terms such as tuple, relation, entity, and determinant are included alongside insights into modification anomalies (insertion, deletion, update), normalization procedures, and denormalization practices. Special topics like multi-valued dependencies, empty sets, and null values round out the guide for comprehensive conceptual review. This document is ideal for: OMIS 452 students preparing for mid-semester quizzes or exams Business, MIS, IT, or Computer Science majors focusing on database theory Learners preparing for certifications or technical interviews that require understanding of data modeling, keys, and normalization Educators or tutors looking for verified question sets on relational design and constraints Whether you're reviewing ER-to-relational transformations or tackling advanced normalization forms, this study set offers a clear, accurate, and well-organized resource. Keywords: primary key, foreign key, surrogate key, composite key, candidate key, referential integrity, functional dependency, normalization, 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, modification anomalies, denormalization, null values, OMIS 452, Northern Illinois University