Introduction to Database Management Systems

Spring 2017


Course Code:

CMPSC 431W (Spring 2017)

Course Title:

Introduction to Database Management Systems

Class Meetings:

Monday, Wednesday, Friday

Section 1: 9:05 – 9:55 a.m. at 103 Leonhard Building

Section 2: 10:10 – 11:00 a.m. at 109 Walker Building



Wang-Chien Lee


360D IST Building West

Office Hours:

M W F 8:00 – 8:50 a.m.


Course web site:

Canvas &

Teaching Assistant:

Yu-San Lin and Hui-Ju Hung


337 IST Building

Office Hours:

(L) M T F 11am – 12pm; (H) T W R 1:00 – 2:00 pm


(L); (H)


Course Description

This course introduces the student to the design, use, and application of database management systems. Topics include: the relational data model, relational query languages, design theory, and conceptual data design and modeling for relational database applications. Broad introduction of database internal issues that is important to database designers (such as views, integrity constraints, triggers, authorization, data storage, indexing, query processing, and transactions) will also be covered. If time allows, we will consider some new and advanced topics.

At the completion of this course, the students shall have a good understanding of relational model, how to transform Entity-Relationship designs to relations, learn the standard query language for relational databases, i.e., Structured Query Language (SQL), and how to use a relational database system to create a database applications. Students will be expected to form project teams to design and implement database applications. In addition, as part of the University’s writing across the curriculum, students are expected to report their project in a clear and well-written document.

Course Objectives

1.    Introduce the student to the design, use, and application of database management systems.

2.    Obtain broad knowledge in concepts of database management systems.


Intended Audience

Computer science and computer engineering majors, as well as others interested in studying the development of software applications with large data management requirements.


Exam Schedule


Presentations and Review


Course Information


Professional Responsibilities