Lecture 4 Part 3 SQL - Relational Database, Primary Key, Foreign Key, Normalization

In this last part of lecture #4, Prof. Malan talks about relational database, primary key, foreign key and the database normalization.

Course Web Site by CS75.tv
Course Sillabus (Opens in a PDF)
Course Sections Lead By TA
Course Projects
The course's own website is at www.cs75.net.
Google Discussion Group
PHP Manual

Lecture 0: HTTP

Lecture 1: PHP

Lecture 2: PHP, Continued

Lecture 3: MVC, XML

Lecture 4: SQL

Lecture 5: SQL, Continued

Slidesdownloadtorrent

Source Code

index

PDFdownloadtorrent

ZIPdownloadtorrent

Subtitles

Englishdownloadtorrent

Transcripts

Englishdownloadtorrent

Video

MP3downloadtorrent

MP4downloadtorrent

Lecture 6: JavaScript

Lecture 7: Ajax

Lecture 8: Security

Lecture 9: Scalability

htaccess-guide - how-to-use-htaccess

==================================================
From the lecture

"Select * " is a linear search - not efficient for a large data
With a primary key, the database builds up a binary tree. So after a
few search executions, a search will be performed much faster.

Data belongs the database, files belong the file system.

CDN - Content Delivery Network - used by Google, Facebook, Akamai, etc, to deliver static contents.