MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Relational Database Design

Course Summary

In this course, you will learn all the skills required to design good databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the informati


  • +

    Course Syllabus

    ● Introduction
        ◦ Outline
        ◦ Development of Storage Hardware
        ◦ Database Technologies
        ◦ The Relational Model
        ◦ Data Modeling
        ◦ Summary
        ◦ References
    ● ER Modeling
        ◦ Outline
        ◦ ER Modeling (overview)
        ◦ Entity Types
        ◦ Attributes
        ◦ Relationships
        ◦ Identifying Relationships
        ◦ Special Relationships (1)
        ◦ Special Relationships (2)
        ◦ Special Relationships (3)
        ◦ Subtypes
        ◦ Summary
        ◦ References
    ● Gathering Information
        ◦ Outline
        ◦ Introduction
        ◦ Analyzing a Mission Statement
        ◦ Interviews
        ◦ Counter Examples
        ◦ Summary
    ● Creating The Initial ER Model
        ◦ Outline
        ◦ Generalizing Fact Types
        ◦ Finding Entity Types
        ◦ Identifying Fact Types
        ◦ Entity Types
        ◦ Attributes
        ◦ Relationships
        ◦ Artificial Entity Types
        ◦ Summary
    ● Converting to Relational
        ◦ Outline
        ◦ Different Representations
        ◦ Representing a Relational Design
        ◦ ER to Relational: Entity Types
        ◦ ER to Relational: Candidate Keys
        ◦ ER to Relational: One-to-many Relationships
        ◦ ER to Relational: Many-to-many Relationships
        ◦ ER to Relational: Other Constraints
        ◦ ER to Relational: Demo
        ◦ Relational to ER: First Draft
        ◦ Relational to ER: Variations
        ◦ Relational to ER: Demo
        ◦ Summary
    ● Basic Normalization - Part 1
        ◦ Outline
        ◦ Why Normalize?
        ◦ Functional Dependencies
        ◦ First Normal Form
        ◦ Find Functional Dependencies 1: Are Candidate Keys Minimal
        ◦ Find functional Dependencies 2: Missing Candidate Keys
        ◦ Demo: Verify that Attributes are Atomic
        ◦ Demo: Verify that Candidate Keys are Minimal
        ◦ Demo: Check for Missing Candidate Keys
        ◦ Summary
    ● Basic Normalization - Part 2
        ◦ Outline
        ◦ Second Normal Form
        ◦ Find Functional Dependencies 3: Dependencies on Subsets of Keys
        ◦ Demo: Dependencies on Subsets of Candidate Keys
        ◦ Third Normal Form
        ◦ Find Functional Dependencies 4: Verify Third Normal Form
        ◦ Demo: Verify Third Normal Form
        ◦ Summary
        ◦ References
    ● Higher Normal Forms
        ◦ Outline
        ◦ Boyce-Codd Normal Form and Elementary Key Normal Form
        ◦ Fourth Normal Form
        ◦ Fifth Normal Form
        ◦ Domain/Key Normal Form
        ◦ Sixth Normal Form and Optimal Normal Form
        ◦ Denormalization
        ◦ Standard Solutions for Non-standard Patterns
        ◦ Summary
        ◦ References
    ● Other ER Methods
        ◦ Outline
        ◦ Many Methods
        ◦ Entity Types
        ◦ Attributes
        ◦ Relationships
        ◦ Crow's foot Notation
        ◦ Special Relationships
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top