CS 330
Lecture 12
- Short video: database errors; societal impact; maintaining database
integrity.
- Preview of hw5 and Oracle topics.
Give Oracle account and pword.
- Next time: Ch. 14, textbook.
Conceptual Database Design. The Entity-Relationship
model. Student presentations of a short assigned topic. Click
here for the assignement.
- Ch 15, textbook: Schema Refinement and Normal Forms. Start
15.2, Functional Dependencies.
- Functional dependencies: generalization of the concept of
key. Used for specifying integrity constraints and
for refining a database design to incorporate certain types of integrity
constraints.
- Definition of a -> b
Ileana Streinu