You are here


Introduction to Database Systems

COSC 3P32 - Spring 2018

General Information | Course News | Course Information

General Information

Lectures: Tuesday and Thursday 13:00-15:00, STH215 (Academic South)

Instructor: Cale Fairchild

Office Hours: TBA

Course News

  • The official course website is available on Sakai

Course Information

In this course we will look at file organization and data access methods which are scalable for large data sets. We will study fundamental database concepts such as: requirement specifications, model designs (focusing on relational models), relational schemas and normalization, the SQL language (used for maintaining and querying our data) and if time permits we will also look at issues like concurrent access and security.

Course Content

  • Introduction to Database Systems
  • The Entity-Relationship (ER) Model
  • Introduction to the Relational Model
  • Schema Refinement and Normal Forms
  • Query Languages: Relational Algebra and SQL
  • Storage and Indexing
  • Transaction Management

Course Materials

Database Management Systems, 3rd edition, Raghu Ramakrishnanan & Johannes Gehrke, McGraw-Hill, ISBN: 0-07-246563-8