Mediascripting on the Web (CSC 195 2014F) : EBoards

CSC 195 2014S, Class 12: Relational Databases





Basic concepts: Databases, Database management system, Relational database

What is a database?

A sample relational database

Suppose we want to represent information on courses at Grinnell College

How do we keep track of what courses a student is in?

Option 3 is preferred * Course id: 21512 * Student id: 43452

SELECT (Student.LName,Student.FName) from (Courses,Students,Option3) where (Courses.DEPT="CSC" and Courses.Number=195, and ...)

Key idea: Tables that join information together

Core database operations

Database design

Database design

What makes a good database?

An exercise in database design

Copyright (c) 2014 Samuel A. Rebelsky.

Creative Commons License

This work is licensed under a Creative Commons Attribution 3.0 Unported License. To view a copy of this license, visit or send a letter to Creative Commons, 543 Howard Street, 5th Floor, San Francisco, California, 94105, USA.