S 380 - STUDY GUIDE

APPROXIMATE FORMAT

• 10 Multiple Choice
• 10 Matching
• Discussion Questions including designing and normalizing relations

CONTENT

1. Introduction to Database Processing
   1. Examples of Databases
   2. File Processing Systems
   3. Definitions
   4. History of Database
2. Introduction to Database Development
   1. Creating a Database
   2. Components of a DBMS
   3. Database Development Processes
3. Entity-Relationship Model
   1. Elements of the Entity-Relationship Model (entity classes and instances, relationship classes and instances)
   2. Examples
   3. You need to be able to model a database with an E-R diagram
4. Semantic Object Model
   1. Elements of the Semantic Object Model (object classes and instances, types of objects (simple, composite, compound, hybrid)
   2. Examples
   3. Comparing the Semantic Object Model and the E-R Model
   4. You need to be able to model a database with the Semantic Object Model
5. Relational Model and Normalization
   1. Relational Model
   2. Normalization (First-Fifth, Boyce-Codd)
   3. Domain/Key Normal Form
   4. You need to be able to normalize relations so as to remove anomalies
6. Database Design using E-R Models
   1. You need to be able to design a database from an E-R model
7. Database Design using Semantic Object
   1. You need to be able to design a database from an E-R model
8. Access
   1. You should be able to discuss how to create a database
   2. You should be able to discuss how to modify a table
   3. You should be able to discuss how to create a form
   4. You should be able to discuss how to filter/query a table
9. Salsa
   1. You should be able to discuss how to create a database using objects