Relational Database Modelling and Design

This covers the Data Modelling and Database Development process and the models that are used at each phase of the lifecycle. Learn through interactive instruction and hands-on exercises.

On successful Completion of this course you will be able to:

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Create an Entity Relationship Diagram
• Identifying entities, attributes, relationships and constraints
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the ER Diagram to utilize several data modeling techniques
• Create a Data Flow Diagrams
• Identifying processes, external agents, information stores and information flows
• Create a Data Flow Diagram that show how the information flows
• Show how a Data Flow Diagram is transformed
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL