CMPT 310 Outline

THE KING'S UNIVERSITY

COURSE NUMBER:

CMPT 310

COURSE TITLE:

Database Management Systems

NAME OF INSTRUCTOR:

Dr. Andrew Tappenden

CREDIT WEIGHT AND WEEKLY TIME DISTRIBUTION:

credits 3(hrs lect 3 - hrs sem 0 - hrs lab 3)

COURSE DESCRIPTION:

A study of the structures and implementations of database management systems. Topics include: data models, normal forms for data relations, data description languages and query facilities.

Prerequisites: CMPT 250 and 275

REQUIRED TEXTS:

Hoffer, J., Venkataraman, R. & Topi, H. (2015). Modern Database Management (12th Edition).
Prentice Hall.

MARK DISTRIBUTION IN PERCENT:


Lab Assignments	30%
Lecture Assignments	15%
Midterm Exam	20%
Final Exam	35%

	100%

COURSE OBJECTIVES:

The course is designed to introduce students to the databases in general and relational database
management systems. Upon completion of this course, students shall be able to:

Model and design databases using Entity-Relationship Diagrams;
Query a database using SQL;
Update a database using SQL;
Implement of database entities and relations using SQL;
Implement applications to interacting with a relational database; and
Describe the basics of data security and integrity.

COURSE OUTLINE:

Introduction to DBMS
Modeling Data
The Enhanced Entity-Relationship Model
Logical Database Design and the Relational Model
Physical Database Design & Performance
Introduction to SQL
Advanced SQL
Database Application Development
XML
Advanced Topics (Time Permitting)

Data Warehousing
Data and Database Administration
Data Quality and Integration
Big Data and Analytics

Required texts, assignments, and grade distributions may vary from one offering of this course to the next. Please consult the course instructor for up to date details.