Profile

e-Catalog

Contact

Search

Cart

Fundamentals of Database Design

Audience

Analysts, programmers, database designers, and database administrators working in a relational environment

Prerequisites

Completion of the courses Relational Principles and Database Fundamentals

Course Aim

To describe the typical database design processes and explain ERDs as a technique for data modeling

Learning Objectives

Explain the stages of database design. Understand database design in the context of a typical software development life cycle. Identify user data requirements. Construct a data model using entity relationship diagrams. Integrate different views of a data model into a single global schema.

Topics Covered

The database design process - Database design - Database design stages Entity relationship analysis - Introducing ER - Alternative ER notations - Exercise: Recognizing ER notation Constructing an ERD - Classifying data items - Exercise: Identifying data items - View integration - Exercise: Constructing a global schema Case study - Analyzing data requirements - Modeling data requirements - Integrating database views