Revised March 3, 2015

CS 348: Introduction to Database Management


Watch a video introduction to this course on YouTube.

General description

This course covers the basic concepts and elements of database management by providing a "classic" introduction to the relational data model and its languages. The course also covers database design methodology.

Students gain experience using and building applications on top of a state-of-the-art commercial DMBS by completing several assignments. Students also gain hands-on experience with commercial database management systems (DBMS) by writing application programs using the commercial DBMS query languages. The main course topics are data models, architecture of database systems, data definition and manipulation languages, database design methods, and the theory of data dependencies and relational normalization.

Logistics

Audience

Normally available

Related courses

For official details, see the UW calendar.

Software/hardware used

Typical reference(s)

Required preparation

At the start of the course, students should be able to

Learning objectives

At the end of the course, students should be able to

  • Explain the principles of relational database management systems
  • Develop data models by constructing Entity-Relationship models from specifications and map them to relational tables in Boyce-Codd Normal Form
  • Interact with database management systems by means of their languages (in particular SQL), and other interfaces, such as ODBC and JDBC
  • Use and build database application programs
  • Typical syllabus

    Introduction (2) hours

    Relational database systems (6) hours

    Database design (7) hours

    SQL and interfaces (7) hours

    Database application development (5) hours

    Database tuning (3) hours

    Database administration (3) hours

    Current topics (6) hours

     


    Campaign Waterloo

    David R. Cheriton School of Computer Science
    University of Waterloo
    Waterloo, Ontario, Canada N2L 3G1

    Tel: 519-888-4567 x33293
    Fax: 519-885-1208

    Contact | Feedback: cs-webmaster@cs.uwaterloo.ca | David R. Cheriton School of Computer Science | Faculty of Mathematics


    Valid HTML 4.01!Valid CSS! Last modified: Friday, 17-Feb-2017 09:59:46 EST