Relational Database Design

2015
2:28 hours

Section 1: Introduction
1 Welcome
2 Things You Should Know Before Starting This Course
3 Tools You Need For Database Design
4 How To Set Up MySQL Workbench
Section 2: Database Basics
5 What Is A Database?
6 Different Types of Databases?
Section 3: Relational Databases
7 Store Data for Each Component
8 Removes Duplicate Information
9 Ensure Records are Complete
10 Prevent Inconsistent and Conflicting Data
11 Combine Different Data Sets Easily
12 Increased Security
Section 4: Data Modelling Process
13 What Is Data Modelling And The Design Process?
14 Determine The Goal Of The Database
15 Consider the Current System
16 Gathering Requirements of the Database
17 Finding Exceptions to the Rules
Section 5: Database Design
18 Identifying Entities
19 Defining the Attributes
20 Normalisation
21 First Normal Form – Part 1
22 First Normal Form – Part 2
23 Relationships
24 Second Normal Form – Part 1
25 Second Normal Form – Part 2
26 Third Normal Form
Section 6: Design Considerations
27 Data Types and Precision
28 Integrity Constraints
29 Naming Conventions
30 Lookup Tables and Auditing
Section 7: Conclusion
31 Implementation and Next Steps