Phases For Designing A Database

Characteristics Of The Database Approach And Users

From Requirements Collection To Physical Design

ER Diagram: Entities And Attributes

ER Diagram: Relationships

ER Diagram: Cardinality Ratio

ER Diagram: Participation Constraints And Weak Entities

ER-To-Relational Mapping: Entities

ER-To-Relational Mapping: Weak Entities And Relationships

ER-To-Relational Mapping: Multivalued Attributes And N-ary Relationships

The Relational Model: Concepts ِAnd Characteristics

The Relational Model: Key Constraints

The Relational Model: Entity ِAnd Referential Integrity Constraints

The Relational Model: Semantic Constraints

The Relational Model: Handling Constrain Violations

SQL: Introduction

SQL: Create Table

SQL: Specifying Constraints 1

SQL: Specifying Constraints 2

SQL: Insert, Update, Delete

SQL: Basic Select Statement

SQL: Adding Where Clause

SQL: Nested Queries, Explicit Sets, Nulls

SQL: Joining Of Two Relations

SQL: Joining Of More Than Two Relations

SQL: Aggregate Functions

SQL: Group By And Having

SQL: Substring Comparison Using Like

SQL: Arithmetic Operations, Order By

SQL Summary And Course Wrap Up