to Introduction Database Systems
CS363/607* Lecture #21
Review Chapter 1.
Database management Systems (DBMS) Comparison with file systems Relational database systems Secondary and tertiary storage Clientserver systems Database languages Components of a DBMS
Storage manager The query processor The transaction manager
Review Chapter 2.
Data Models Relational model Schemas Keys Data Definition Altering schemas Relational Algebra
SQL
Selection, projection, joins, and constraints
Review Chapter 3.
Functional dependencies Keys of a relation Rules of functional dependencies BCNF, 3NF and 4NF Decomposing relations
Review Chapter 4.
The Entity/Relationship (E/R) model E/R diagrams Multiplicity of relationships Good design of E/R diagram Subclasses Weak entity sets Converting entity sets to relations Converting relationships to relations Converting Isa hierarchies to relations UML ODL
Review Chapter 5.
Relations as bags Extensions to relational algebra Grouping and aggregation Outerjoins
Chapter
Review 6.
SQL SelectFromWhere Queries Subqueries Set operations on relations Join expressions Null values Outer joins
Review Chapter 6. (Cont.)
The bag model of relations Aggregations Modification statements Transactions
Review Chapter 7.
Key constraints Referential integrity constraints Attribute and tuplebased check constraints Modifying constraints Assertions Invoking the checks Triggers
Review Chapter 8.
Virtual Views Updatable Views Insteadof triggers Indexes
Materialized Views
Choosing indexes Automatic index selection Maintenances Rewriting queries
Review Chapte...