Lessons:16Length:1.5 hours
- Overview
- Transcript
2.2 Codd's Twelve Commandments
Back in the 1980s, Edgar F. Codd wrote a list of thirteen criteria that a database must meet in order to be considered relational. While these rules aren’t hard and fast, they are good guidelines, and they’re a great way to start looking at the ideas of relational theory.
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
