Review - PowerPoint PPT Presentation

About This Presentation
Title:

Review

Description:

Functional dependency (FD); Un/Satisfaction of FD by a relation; Properties of FDs; entailment of a FD by a set of FDs; equivalence between two sets of FDs; ... – PowerPoint PPT presentation

Number of Views:13
Avg rating:3.0/5.0
Slides: 4
Provided by: scie208
Category:
Tags: class | review

less

Transcript and Presenter's Notes

Title: Review


1
Review
  • ? Only two chapters (6 7)
  • Normalization Theory
  • Triggers

2
Chapter 6
  • Functional dependency (FD)
  • Un/Satisfaction of FD by a relation
  • Properties of FDs entailment of a FD by a set of
    FDs equivalence between two sets of FDs
  • Projection of FDs
  • Normal forms (BCNF, 3NF, 4NF)
  • Decompositions (lossless and lossy, dependency
    preserving)
  • Multivalued dependency (MVD) properties of MVDs
  • Algorithms BCNF, closure computing, 4NF

3
Chapter 7
  • Define triggers
  • Determine results of certain events
  • Need to remember a little bit of SQL
Write a Comment
User Comments (0)
About PowerShow.com