CS3710 - Database Systems (Winter 2020)

Course Objectives

This course introduces the fundamental concepts necessary for the design, use and implementation of database systems. Topics discussed include logical and physical organization of data, database models, design theory, data definition and manipulation languages, constraints, views, and embedding database languages in general programming languages.

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.

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 o 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, 9:30 - 12:30, CASS 407

• Lectures
• M W F 8:30-9:20, CSH104
• Prerequisite
• CS2920
• 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 signed 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