COMP3311 Week 03 Lecture
Exercise: 3-way relationship
Exercise: Better prescription model
Exercise: Disjoint subclasses
Exercise: Overlapping subclasses
Exercise: Subclasses + relationships
Relational DBMSs
What is an RDBMS?
Description of Data
RDBMS Operations
RDBMS Architecture
PostgreSQL Architecture
SQL
SQL
SQL Syntax
Types/Constants in SQL
Exercise: Defining domains
Exercise: Enumerated types
Tuple and Set Literals
SQL Operators
SQL: Schemas
Relational/SQL Data Definition
Primary Keys
Referential Integrity
Other Attribute Properties
Mapping ER to Rel to SQL
Exercise: SQL Schema (1)
Exercise: SQL Schema (2)
Exercise: SQL Schema (3)
Building Databases
Creating Databases
Bulk Insertion Methods
Saving/Restoring Databases
Produced: 26 Mar 2009
![[index]](icon/up.gif){kind=icon}