Relational Data Model and CREATE TABLE Statement

Lesson Objectives
Understand assignment 1 requirements
Study documentation about the assignment database (Intercollegiate Athletic Database)

Intercollegiate Athletic Work Flow

Intercollegiate Athletic Database Diagram

Assignment 1 Requirements
Install and use Oracle or MySQL
Write CREATE TABLE statements
Correct syntax
Appropriate data types
Named constraints
Write directly without using visual interface
Execute SQL INSERT statements to populate tables

Constraint Requirements
PK
FK
NOT NULL
CHECK
Names for at least PK and FK constraints