:Objective

This course provides an introduction to relational database concepts and terminology. Through a variety of exercises, you will learn how to model a business enterprise using the entity-relationship approach to relational database design. You will learn data normalization techniques and how to propose, evaluate, and choose between design alternatives. In addition, you will have hands-on experience creating a database and table using the Data Definition Language of SQL.

:Course outline

Main steps to design a database.

Entity-Relationship concepts and terminology.

Entity-Relationship diagrams.

Attribute specifications.

Informix data types.

Normalization.

SQL statements for creating a database.

Data integrity.

Using DB-Access to create the database schema.

Inserting and selecting data.