Introduction to data models, normalization, and SQL

Data Abstraction and Data Independence

Schema and Instances

E-R Model

Strong and Weak Entity Sets

Attributes and Keys

and E-R Diagram

Different Normal Forms

1st

2nd

3rd

BCNF

Functional Dependencies

Integrity Constraints and Domain Constraints

Relations

Joined

Derived

Queries under DDL and DML Commands

Views

Assertions and Triggering

Relational Algebra

Query Cost Estimation

Query Operations

Evaluation of Expressions

Query Optimization

Query Decomposition.