Logical Data Modeling and Relational Database Design Overview

Summary

This is a high-level, practical overview of the concepts, notation, and techniques of logical data modeling and relational database design. The course also includes a discussion of scalability and how to achieve scalability in design.

Prerequisites

Familiarity with computing systems and programming concepts is strongly recommended. Prior knowledge of the relational database model is helpful. Overhead projector, whiteboard, flipcharts.

Course Objectives

On completion of this course, the student should be able to

Understand modeling techniques used in relational database design
Describe logical data modeling techniques
Create, interpret and apply entity-relationship diagrams
Describe relational database design concepts
Recognize the implications of scalability for modeling during the design phase

Length

1 Days

Format

Instructor-led course, with practical written exercises.

Course Outline

Introduction
Modeling Concepts
- Introduction to modeling
- Modeling definitions and considerations
- Levels of modeling
- Types of modeling
- Zachman framework
- Modeling the system
- identifying models
Logical Data Modeling
- Introduction to logical data modeling
- Logical data modeling approaches
- Developing a data dictionary
- Entity-Relationship modeling
- E-R modeling concepts
- Developing E-R models
Introduction to relational database design
Scalability
- Scalability concepts
- Conclusion

Hardware and Software Requirements

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 3

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 4

Notice: Undefined variable: REMOTE_USER in /var/www/datadeliverance/inc/trademarks.inc on line 7

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 7

Oracle and Java are registered trademarks of Oracle and/or its affiliates. PL/SQL and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries. MVS is a registered trademark of the International Business Machines Corp. in the U.S. or other countries or both. Motif, OSF/1, UNIX, and the "X Device" are registered trademarks and IT DialTone and The Open Group are trademarks of The Open Group in the U.S. and other countries. All other trademarks are the property of their respective owners.