Home » Undergraduate Students » 2nd Year

COSC/APCO 2P32

Printer-friendly version

File and Database Systems

COSC/APCO 2P32 - Winter 2012

General Information | Course Information | Course Materials | Assignments

General Information

Lectures: Monday 17:00 - 18:20 TH255, Thursday 17:00-18:20 TH257

Instructor: Cale Fairchild, MCJ305

Office Hours: Monday and Thursday 16:00 - 16:50 or by appointment

Course Information

In this course we will look at file organization and data access methods which are scalable for large datasets. We will study fundamental database concents such as: requirement specifications, model designs (focusing on relational models), relational schemas and normalization, the SQL language (used for maintaining and querying our data) as well as 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
  • Security

Course Outline

The course outline can be downloaded in the following formats. PDF

Assignments

Tests

  • Test 1 - Feb 13th (in class)
  • Test 2 - TBD (in class)
  • Final Exam - TBA

Course Materials

Textbook

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

Additional Documentation

Oracle has most their user manuals published online at: http://docs.oracle.com

The documentation for Oracle Forms is here (we will be using version 10G release 2).

The documentation for Oracle Reports is here, and there is a tutorial here.

There are a couple documents which may be helpful for getting to know Form Builder. Creating a Form and basing form data on a join.

Lecture Material

The slides written by the authors of the book are located on their web site, which is linked below, but there are many chapters where the slides presented in class will differ significantly from those posted. You will be tested on the material presented in class not just the material found in the book or on the slides provided by the book. Please note: Any slides posted here will only be available for download from Brock's network.

Additional Resources