Test 2 Review

Bring a GradeMaster form and a pencil to the test. The test will take 40 minutes.

Database Development

Know information from the “Database Development” and “Modeling Tips” lecture notes

Entity-Relationship Modeling

• Given an E-R diagram, be able to interpret relationships using sentences such as “a pipe organ consists of zero to many pipes.”
• Given an E-R diagram and a narrative, be able to identify diagram and design errors
• Given an E-R diagram, be able to design a corresponding database schema, specifying foreign keys

Data Integrity

Know the various techniques for enforcing data integrity in databases