The Database Design Methodology

Overview/Description
To describe and apply the techniques of the database design life cycle to build a relational database

Target Audience
Anyone wanting to understand the concepts and practices of relational database design

Prerequisites
An understanding of fundamental database concepts.

Expected Duration
240 Minutes

Objectives:

The Database Design Methodology

  • outline the three-stage process of gathering and analyzing business requirements for database design.
  • use interviewing techniques to gather requirements from users to facilitate the information system analysis and database design process.
  • describe how to generate a conceptual Entity-Relationship diagram (ERD) to support the functional specification for a database system.
  • develop a conceptual Entity-Relationship (ER) model based on a given business requirements document.
  • use Entity-Relationship (ER) modeling to design a relational database.
  • develop an initial logical database design using simple Entity-Relationship (ER) modeling techniques.
  • define normalization and describe how to apply it to the Entity-Relationship (ER) model to eliminate redundant data.
  • describe how to use advanced Entity-Relationship (ER) modeling techniques to define complex real-world scenarios.
  • analyze a complete Entity-Relationship Relationship (ER) model based on a given set of requirements.
  • develop a complete logical database design using advanced Entity-Relationship (ER) modeling techniques.
  • describe how to create the physical database design based on the logical database model.
  • develop the physical database design based on the logical database model.


    • Course Number: 78580_eng