Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Relational Database Design
Introduction
Welcome (3:55)
Things You Should Know Before Starting This Course (0:48)
Tools You Need For Database Design (2:24)
How To Set Up MySQL Workbench (3:30)
Database Basics
What Is A Database? (2:50)
Different Types of Databases? (2:30)
Relational Databases
Store Data for Each Component (2:30)
Removes Duplicate Information (2:50)
Ensure Records are Complete (1:52)
Prevent Inconsistent and Conflicting Data (4:43)
Combine Different Data Sets Easily (2:30)
Increased Security (2:12)
Data Modelling Process
What Is Data Modelling And The Design Process? (3:31)
Determine The Goal Of The Database (3:18)
Consider the Current System (3:34)
Gathering Requirements of the Database (4:10)
Finding Exceptions to the Rules (5:21)
Database Design
Identifying Entities (8:30)
Defining the Attributes (10:06)
Normalisation (2:40)
First Normal Form - Part 1 (9:31)
First Normal Form - Part 2 (9:34)
Relationships (3:26)
Second Normal Form - Part 1 (9:56)
Second Normal Form - Part 2 (12:55)
Third Normal Form (9:49)
Design Considerations
Data Types and Precision (6:38)
Integrity Constraints (2:53)
Naming Conventions (3:25)
Lookup Tables and Auditing (3:36)
Conclusion
Implementation and Next Steps (3:19)
Store Data for Each Component
Download
Complete and Continue