Overview Objective Materials grading Exam ELI Policies and Procedures Contacting the Instructor Beginning the Course
ITD256 -Advanced Database Management - 3 Credits


In this course, you will learn about the basic models and capabilities of standard database management systems (DBMS) packages. Included in the course is an overview of database principles, file-level models, data-level models, operation. The course also emphasizes implementation, maintenance and security considerations. You will will study and use methods of DBMS selection and evaluation to implement the design for your proposed database project solution.

Prerequisite : The prerequisite for the course is ITE 115. Students must also be able to read and write at the college level and must have a working knowledge of the WINDOWS environment.




Upon completion of this course, students will be able to:

  • Define essential database vocabulary
  • Effectively apply data relationships and normalization techniques
  • Describe the transformation of database design from a conceptual user model (e.g., an ERD) to a normalized relational model
  • Explain and apply Structured Query Language (SQL) in a database environment
  • Describe the methods available for minimizing DBMS risks and security failures
  • Characterize the roles and responsibilities of the Database Administrator (DBA)
  • Apply fundamental database concepts to an information systems problem




Possible Assignments Include: (Subject to change each semester. The actual assignments are available in the Syllabus in the Blackboard course site on the first day of classes.)

Student Intro Letter 5
Project Plan Document 45
Logical Model and Physical Design Document 100
Implementation & Maintenance Plan 50
Field Research Discussion 100
Exams 500

Your final grade may be based on the following scale.

Grade Points
A 720-800
B 640-719
C 560-639
D 480-559
F 0-479



There are 3 proctored exams and 2 take-home exams in this course.


ELI Policies and Procedures


Beginning the Course