You are here

COSC 3P32

Introduction to Database Systems

COSC 3P32 - Spring 2017

General Information | Course News| Course Information | Course Materials | Assignments


General Information

Lectures: Tuesday and Thursday 15:00-17:00, WH208

Instructor: Cale Fairchild

Office Hours: Tuesday and Thursday 14:00-15:00, MCJ305 (or by appointment)


Course News

  • The second part of the project has been uploaded and will be due at the end of term
  • Assignment 3 has been posted
  • The first part of the project has been uploaded as well as the lab excercise.
  • There will be a tutorial during your lab time in the week of the June 12th. Attendance in one of the labs that week is mandatory.
  • The date for the Midterm has been set to June 8th
  • Assignment 2 has been posted
  • Assignment 1 has been posted
  • The scheduled lab times will be used later in the term for tutorials, as needed (you will receive advanced notice)

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 Outline

The course outline can be downloaded here


Course Materials

Textbook

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

Additional Resources

Please Note: Access to slides are limited to the Brock network


Assignments

  • Assignment 1 (Due May 23) PDF
  • Assignment 2 (Due June 5) PDF
  • Assignment 3 (Due July 4) PDF

Group Project

  • Lab Activity PDF (data file populate_mysql.txt)
  • Part 1 - Schema Design (Due June 20) PDF
  • Part 2 - Implementation (Due Date TBD) PDF

Tests

  • Midterm - June 8, 2017, in class
  • Final Exam - July 8,2017 - 12:00 (Registrar's page)