|
|
|
|
|
|
|
|
|
|
|
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
-
Introduction to logical data modeling
Logical data modeling approaches
Developing a data dictionary
Entity-Relationship modeling
E-R modeling concepts
Developing E-R models
-
Scalability concepts
Conclusion
Hardware and Software Requirements
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.
For comments or problems, please mail
webmaster@datadeliverance.com