Logical Data Modeling

    

Summary:
This course will describe the process of designing a database for a relational system. The first part will present an approach to develop a semantic data model which identifies attributes and relationships relevant to the organization's operation. The next part will describe the process of transforming the semantic model to a relational design such as a set of database tables. Throughout the course, emphasis will be placed on developing an accurate model of the organization. The material presented is reinforced through a series of case studies and exercises. This course in not Oracle specific but applies to any relational database.

Duration:
2 Days/Lecture & Lab

Audience:
This course is designed for Programmers, Analysts and Database Administrators responsible for the design of relational database systems.

Topics:

• Overview of database design
• Objectives of the process
• Examples of good and bad designs
• Design methodologies
• Conceptual design
• Extended Entity Relationship (EER) model
• Methodology of EER design
• Pragmatic issues
• Integrity constraints and business rules
• Design verification
• Relational design
• Transforming an EER model to a relational model
• Pragmatic Relational design

Prerequisites:
Before attending this course, students should take ProTech's Oracle9i Concepts and Facilities, Microsoft SQL Server Concepts, or have an understanding of relational database systems.

Last Update: May 22, 2012