Comp 305-001/405-001: Database Administration

Spring 2024: MWF

Week 8


Exam study guide

ER diagrams

ER diagrams, invoices and other ternary relationships

    Invoice and Dellstore

Password dataset

Wednesday: continue with password dataset



Indexing

    B-trees

Friday: Continue with Indexing

Query Trees and Query optimization

    Join algorithms
    index selection


Explain

    Start with joins
    Dell assignment

Very Slow Query

Window functions

Normalization

Transactions