CS371 -- Database Systems (Winter 2017)

Course Objectives

This course introduces the fundamental concepts necessary for the design, use and implementation of database systems. Topics discussed include: Introduction, Relational Model, Structured Query Language, Data Modeling and the Entity-Relationship Model, Database Design, Database Administration, Database Processing Applications, and Advanced Topics.

Computer Requirement

To take this course, a student should have a personal computer which can be used to accomplish assignments and the project. Although University does have computer labs, a student's personal computer is still necessary for this course. The reasons are: (1) students cannot install software on lab computers; (2) students cannot safely keep their personal files on lab computers; (3) the required software packages are installed in one computer lab, but that lab is not always available to students.

This computer can be either a laptop or a desktop (tablets are not recommended), can run on different Operating Systems. Demos and software will be based on the Windows Operating System. Information on other Operating Systems will be provided when it is possible, but not guaranteed.

A student may take this course without such a computer, but the University and the Instructor are not responsible to provide such environment for his/her course work. The course evaluation will not be altered because a student does not have such computer.

Course Information

• Instructor: Yingwei Wang

• E-mail: ywang@upei.ca
• Web Page: www.csit.upei.ca/~ywang
• Office: CASS 407
• Office Hour: Monday, 11:20 - 12:20, CASS 407

• Lectures
• M W F 12:30-1:20, CSH104
• Prerequisite
• CS 261
• Textbook
• Database Concepts 7/E, David M. Kroenke and David Auer, ISBN-10: 0133544621, ISBN-13: 9780133544626, Pearson Education, 2015

Evaluation

• Assignments 30%
• Midterm 25%
• Final exam 35%
• Participation 10% (1% deduction for each absence. Maximal deduction is 10%. For compassionate reasons, no deduction for two absence. For health reasons, no deduction if a dated doctor's note is presented before or after; 0.5% deduction if no doctor's note but sent email to the instructor before class. No exception for other situations.)
• For whatever reasons, if 50% or more of the classes were missing, the mark of the course will be 0.

Topics

• Introduction
• Relational Model
• Structured Query Language
• Data Modeling and the Entity-Relationship Model
• Database Design
• Database Administration
• Database Processing Applications
• Advanced Topics