Course code: OD01
This is a practical course covering the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle.
This is a practical course covering the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle. Participants use several real life examples to document business requirements, the flow of information through a particular process and what information needs to be captured to accomplish the business rules. Students create an Entity Relationship Diagram (ERD) and a Data Flow Diagram (DFD) in this phase of the course. Participants learn many techniques to revise and enhance their ERD such as normalizing the model, adding recursive and exclusive relationships, identifying entity hierarchies (subtypes/supertypes) and defining and using User Defined Data Types (Data Types Model). After the models have been validated, students map the objects and engineer the logical model to a relational model. The Relational Design is then optimized using many de-normalization techniques and adding some additional objects such as indexes and views to the Physical Design. Once the Relational Design has been validated, the Physical Model can be used to add all physical properties and finally generate the DDL to create the database objects.
Terms and Conditions
© 2019 iTrain. All rights reserved.