Introduction
  • Welcome
  • What Is A Database?
  • Different Types of Databases?
  • Benefits of Relational Databases
Data Modelling Process
  • What Is Data Modelling And The Design Process?
  • Determine The Goal Of The Database
  • Consider the Current System
  • Gathering Requirements of the Database
  • Finding Exceptions to the Rules
  • Identifying Entities
  • Defining the Attributes
Database Design
  • Normalisation
  • First Normal Form
  • First Normal Form: Student
  • First Normal Form: Subject
  • First Normal Form: Teacher
  • First Normal Form: University
Second Normal Form
  • Relationships
  • Second Normal Form
  • Second Normal Form: Student and Subject
  • Second Normal Form: Teacher
  • Second Normal Form: University
Third Normal Form
  • Third Normal Form
  • Third Normal Form: Student and Subject
  • Third Normal Form: Teacher and University
  • Third Normal Form Completed
Design Considerations
  • Data Types and Precision
  • Integrity Constraints
  • Naming Conventions
  • Lookup Tables and Auditing
  • Auditing Tables
  • Implementation and Next Steps