Lecture 5

Purpose

Relational Database Illustrated & Language to Access Data

*Primary Key

*Other Keys

Data Integrity (Constrains) Rules

*Transforming ER to Relational Model

*Subtype Mapping

Lecture 6

Just quickly glance the very first sections Focus on the clauses and statements (syntax)

What is SQL?

Why SQL?

Features of SQL

SQL: Language Breakdown

Basic Steps in Query Processing

Summary of Intro to SQL

*SQL Basic Data Types

Domain