Dive into a comprehensive 2.5-hour exploration of database systems, covering essential topics such as database schema, SQL, normalization, and hypermedia systems. Learn about Query By Example (QBE), its development rationale, design principles, and relationship to SQL. Understand the concepts of primary and foreign keys, and explore practical examples using loans and flight databases. Gain hands-on experience in identifying data redundancy, building database schemas, and crafting SQL queries to effectively manage and retrieve information from relational databases.
Overview
Syllabus
Database Schema.
SQL.
Database Normalisation.
Hypermedia Systems.
QBE: Why "Query By Example" Was Developed.
QBE: A Concrete Example.
QBE's Design Principles.
QBE's Relationship To SQL.
Primary & Foreign Keys.
Loans Database: Data Redundancy.
Loans Database: Identifying the Tables.
Loans Database: Building the Schema.
Flight Database: Identifying Records.
Flight Database: SQL Query.
Taught by
Eddie Woo
