Course Description

This course examines fundamental database concepts including specification, design and applications; various models including the relational model; normal forms, efficiency considerations, queries using SQL, database administration and security.

Credit Hours: 36
Location: TH245
Period: Jan 10, 2022 to Apr 08, 2022
Time: Monday: 8:00 am to 9:30 am, Friday: 8:00 am to 9:30 am
TAs: Mrittika Ferdous (mf21ql@brocku.ca) and Mubashir Murshed (mm19ak@brocku.ca)
Prerequisite: COSC 2P03 (minimum 60%)
Exclusions: Completion of this course will replace previous assigned grade and credit obtained in COSC 2P32.

  • Database Management Systems, 3rd edition, Raghu Ramakrishnanan & Johannes Gehrke, McGraw-Hill, ISBN: 0-07-246563-8.
  • Database System Concepts, 7th edition, Avi Silberschatz, Henry F. Korth and S. Sudarshan, McGraw-Hill ISBN 9780078022159. Online source: https://zyBooks.com

Tentative Outline

  • Introduction to Database Systems
  • The Entity-Relationship (ER) Model
  • Introduction to the Relational Model
  • Query Languages: Relational Algebra and SQL
  • Schema Refinement and Normal Forms
  • Storage and Indexing
  • Transaction Management
  • Optional Topics, including (but not limited to) Query Evaluation, Security.

Office hours

  • Monday and Friday 10:00 am to 11:00 am
  • Offline questions: by email
  • Online session: by appointment