Logical Data Modeling and Relational Database Design Overview

Click for printer-friendly version
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

Notice: Undefined index: printer in /var/www/datadeliverance/inc/trademarks.inc on line 11

Go to course catalogue

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.