Logical Data Modeling and Relational Database Design Overview
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.
Familiarity with computing systems and programming concepts is strongly
recommended. Prior knowledge of the relational database model is
Overhead projector, whiteboard, flipcharts.
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
Instructor-led course, with practical written exercises.
Introduction to modeling
Modeling definitions and considerations
Levels of modeling
Types of modeling
Modeling the system
Logical Data Modeling
Introduction to logical data modeling
Logical data modeling approaches
Developing a data dictionary
E-R modeling concepts
Developing E-R models
Introduction to relational database design
Hardware and Software Requirements
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.