Databases store data structured into tables connected to one another by sharing one another's keys
techred home > database objectives > clip board databases

Clipboard databases

listContents

Materials and document links
Phase 1: Create room reservation database on clipboards!
Reverse engineering databases from query building forms

wb_incandescentIntroduction

To master the fundamental concepts of database design, we must decouple the complexities of database software from the principles of data organization into tables related to one another with foreign keys. We'll use a novel approach of creating a database on a set of 6x9 clip boards which are tactile, portable, and highly representative of how computer software implements database principles.

wb_incandescentMaterials

Secure the following supplies:

Sample room reservation database

Sample person table design and data view

sample room reservation database

Sample room table design and data view

sample room reservation database

Sample reservation table design and data view

sample room reservation database

Strings create foreign key relationships

sample room reservation database

Phase 2b (DAT-201): Digitize reservation database in PostgreSQL

PostgreSQL links

Phase 3b (DAT-201): Extracting structured data with queries