| Data Modeling and Relational Database Design |
|
Breza Software Engineering
“Objektno-orijentisana analiza IS i projektovanje bazepodataka" Data Modeling and Relational Database Design - code 20000 What you will learn: This course covers the use of Entity Relationship Modeling in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The second part of the course is about the design process and presents the considerations for creating a normalized, stable, maint ainable and well defined relational database, such as Oracle9i. Audience: Business Analysts Database Designers Database Administrators Prerequisites
Suggested Prerequisites: Basic understanding of relational database concepts Course Objectives: Recognize and use patterns in models Apply various techniques to optimize the design in an Oracle environment for performance and maintainability Transfer ER models into an initial relational database design Read, improve, create, use and judge Entity Relationship Models Capture business rules and constraints Course Topics: Entity Relationship Modeling Why create conceptual models? Distinguishing Data and Information Tracking Entities in various source materials Modeling Subtypes and Supertypes Creating appropriate Names for Entities, Attributes and Relationships Representing a Model in Diagrams Identifying Things in the Real World Establishing Unique Identifiers (UID) Relational Database Design Why create a Database Design? Creating well structured Names for Database Objects Establishing the Basic Mapping of an ER Model to Table Model Mapping Entities and Attributes Various ways of Denormalizing your Table Design Selecting the appropriate Oracle Data Type Recognizing Design Fossils like Generic Arcs Design for a Distributed Environment Breza Software Engineering
2 Suggested Next Courses: Oracle9i Designer: First Class Data Warehouse Database Design Oracle Database 10 g
: Administration Workshop I , Trening Centar : , Trening Centar |
