CMSI 486: Welcome to Week 07

This Week's Class Agenda

Topics we've covered:

What *is* a database? Is it necessary? Where did they come from?
Advantages and disadvantages
Relational Algebra
Select, project, rename, joins, union, cross product
Database Keys
Primary key, foreign key, candidate key, composite key
ANSI SPARC model: three layer view, who uses what, advantages and disadvantages
Entities, Attributes, and Relations
Schemas, Data Definition Language [DDL], Data Manipulation Language [DML]
Cardinality and Arity
Entity-Relationship Diagrams [ERDs]
Entities, Attributes, multi-valued attributes, derived attributes, primary key indication, relations, weak entities
ACID: Atomicity, Consistency, Isolation, and Durability
CRUD: Create, Retrieve, Update, Delete
Normalization: normal forms, what are the steps, which are most used
Transaction processing
Locking
Indexing