CSE-213

Discuss the Entity/Relationship (ER) model and its constraints

Design a relational database schema for a database application

Apply relations, attributes, dependencies and keys to a relational database design

Specify an object-oriented model using the Object Definition Language (ODL) including classes, types, relationships and methods

Utilize relational algebra expressions to write database queries and constraints

Implement queries, clauses, and data definition statements in Simple Query Language (SQL).

Entity Relationship Model

Relational Data Models and Functional Dependencies

Relational Database Design

The Object Definition Language

Relational Algebra

The Simple Query Language (SQL)

Sub-queries and relational operations

Views and Indexes