Lessons:16Length:1.5 hours
- Overview
- Transcript
3.3 Foreign Keys and Relationships
You already know that you can have multiple tables in your database. Now we need a way to show relationships between records in different tables. This is where foreign keys come in. However, just like primary keys, there are certain rules you should follow. Of course, it’s all in this screencast.
1.Introduction
1.1Introduction01:31
1.1
Introduction
01:31
2.History and Terms
2.1A History Mini-Lesson04:09
2.1
A History Mini-Lesson
04:09
2.2Codd's Twelve Commandments08:21
2.2
Codd's Twelve Commandments
08:21
2.3Terminology04:36
2.3
Terminology
04:36
3.Relational Components
3.1Data Types08:07
3.1
Data Types
08:07
3.2Primary Keys07:36
3.2
Primary Keys
07:36
3.3Foreign Keys and Relationships07:46
3.3
Foreign Keys and Relationships
07:46
3.4Normalization07:31
3.4
Normalization
07:31
3.5Queries07:40
3.5
Queries
07:40
4.Database Usage
4.1Views06:09
4.1
Views
06:09
4.2Database Servers and Users03:08
4.2
Database Servers and Users
03:08
4.3Designing a Data Model04:55
4.3
Designing a Data Model
04:55
4.4A Practical Look at SQLite: Part 107:13
4.4
A Practical Look at SQLite: Part 1
07:13
4.5A Practical Look at SQLite: Part 206:44
4.5
A Practical Look at SQLite: Part 2
06:44
4.6Other Database Models01:41
4.6
Other Database Models
01:41
5.Conclusion
5.1Conclusion00:18
5.1
Conclusion
00:18
