Comp 305-001/488-305: Database Administration

Spring 2018: Tuesdays, 4:15-6:45, Comm 013

Week 2

Uber and the switch from Postgres to MySQL

Installing Postgres on Windows

Introduction to Relational Databases

  1. Entity-Relation (ER) diagrams (done)
  2. The Company DB
  3. Relational Math
  4. concepts: self-describing, transactions

The company database: create table and insert statements.

Continuation: sql1.html, up to but not including A Look At Constraints.

Installation assignment:

    Install PostgreSQL on your own machine