King's  Logo

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 Assignments15%
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.

© The King's University
Maintained By Institutional Research