Introduction to Database Management Systems

CMPS182: Introduction to Database Management Systems

ANNOUNCEMENT 04/02: Good news! We have been assigned a larger room. For today (04/02), we will meet at Natural Science Annex 102. For Thursday (04/04) onwards, we will meet at Physical Sciences 130.

Instructor: Wang-Chiew Tan (

Where: On 04/02: Natural Science Annex 102. From 04/04 onwards: Physical Sciences 130

When: Tuesdays and Thursdays 2:00pm to 3:45pm

Office Hours: E2 343BTuesdays 3.45-4.45pm, Thursdays 1:00pm to 2:00pm, or by appointment.

Teaching Assistant: Jian Wang (

TA Office Hours: E2-475, Monday and Wednesdays 1pm-2pm

Lab Sections: Social Science I Mac (Room 135), Mondays/Wednesdays, 2-3.45pm  

Course Description:  This course covers concepts, approaches, tools, and methodology of database design. Topics include the relational data model; normal forms; commercial languages such as SQL (SQL constraints, SQL triggers, and update languages); query-by-example (QBE); semi-structured data models such as XML or JSON data model, and XML query language (XQuery); as well as APIs to access databases from applications and advanced topics in big data and data integration (time permitting). This course involves a database-application development project through a series of lab assignments.

Prerequisite(s): course 12B. Course intended for non-majors; computer science majors should enroll in course CMPS180. 

Please log on to for further information about this course. 

Instructors and Assistants