Logical
Database Design
Length: 3 Days
Prerequisites:
None
OverviewLearn the basics
of designing a database from requirements gathering to
implementation. Our instructors are hands-on Database
Modelers.
They will share their experiences while
teaching the course material.
Key Benefits:
Learn Database Design
Outline
Chapter 1. Introduction to Databases
- Databases in General, Hierarchical Database,
Network Database,
- Flat File Databases, Relational Database,
Object Database
- Object Relational Database
Chapter 2. Data Dictionary
Chapter 3. Introduction to Relational
Database Design
- Design, Review of System Design
- Different Methodologies
- The Steps
- Design Bias
- RDB Design Methodologies
- 3-Levels
- CASE Tools
Chapter 4. Denormalization
- Performance Implications of a Physical Database
Chapter 5. Conceptual Design
- Inputs
- Outputs
- When it is Done
- Steps in Performing
Chapter 6. Distributed Database
- Design for a Multi-site Database
Chapter 7. Logical
Design
- Inputs
- Outputs
- When it is Done
- Entities
- Attributes
- Relations
- Keys
- Reviewing the Design
Chapter 8. Converting OO Design to
a Relational Database
- How it Differs from a Standard Database Design
Chapter 9. Normalization
- Mathematical Meaning
- Plain English Description
- 6 Standard Forms
- 1NF, 2NF, 3NF,
- Boyce-Code
- 4NF, 5NF
Chapter 10. Introduction to
Informational Modeling
- Understand Flow of Information at Your Site
- Physical Design
Back to Course Listing
