CIS 452 Exam Review Guide Closed Book Exam Exam date and time: 10/19/23, Thursday, during the class time
Coverage:
• Relational Data Model
o Basics of The Relational Model
§ Attribute and Tuple
§ Relation Scheme
§ Database
§ Database Scheme
§ Domain
§ Keys
o Create Tables using SQL
o Declare keys, default values for Tables
• Entity-Relationship (E/R) Modeling
o E/R Diagrams
§ Entity Sets, Attribute, Keys
§ Relationship
• Relationship Set
• Multi-way Relationships
• Many-Many Relationship, Many-One Relationship, One-One Relationship
• Attributes on Relationship
• Cardinality
• Participation
• Relationship strength
o Design E/R Diagrams
o Entity supertypes and subtypes
o Design cases in Lecture 5
• Normalization
o Functional Dependency
o 1NF, 2NF, 3NF, BCNF
Question Types May Include:
1. Multiple Choice
2. True or False
3. Short answers
4. Design E/R Diagrams based on the given description
5. Optimize E/R Diagrams using normalization