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
- Entity-Relation (ER) diagrams (done)
- The Company DB
- Relational Math
- 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