Description

Overall Course Objective: Gain two essential skills to become a Business Analyst Data modelling Relational Database Design Learning Outcomes (LOs): Understand Database and Relational Database Understand Data Modelling Learn to Develop Entity Relationship Diagram (ERD) Design Database Analyze real life business/organizations to model data requirement Course Outline: Database and Relational Database Tables (database tables and its elements) Case Study Analysis (real life scenario analysis) Entity Relationship Diagram (ERD) Anomalies (Insert, Update, Delete) Dependency (Functional, Partial and Transitive) Normalization (UNF, 1NF, 2NF and 3NF) Database Development Steps