Database Management

95-703

Units: 12

Description:

Databases systems are central to most organizations’ information systems strategies. At any organizational level, users can expect to have frequent contact with database systems. Therefore, skill in using such systems – understanding their capabilities and limitations, knowing how to access data directly or through technical specialists, knowing how to
effectively use the information such systems can provide, and skills in designing new systems and related applications – is a distinct advantage and necessity today. The Relational Database Management System (RDBMS) is one type of database systems that is most often used these days, and is the primary focus of this course.

Further, to provide students with opportunity to apply the knowledge they learn from the lectures, various homework assignments, SQL assignments, and a database implementation project will be given.

Learning Outcomes:

Objective  (How Assessed)

  • Gain good understanding of relational data model in terms of data structure, data integrity, and data manipulation.  (Homework Assignments, Final Exam)
  • Understand and create conceptual database models utilizing entity-relationship modeling.  (Homework Assignments, Final Exam)
  • Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology.  (Homework Assignments, Final Exam)
  • Understand the theory behind the relational data model as it applies to interactions with current database management systems.  (Homework Assignments, Final Exam)
  • Read and interpret a given data model to query the database and transform the data into information using Structured Query Language (SQL).  (SQL Assignments, Project)
  • Implement a data model in a current relational database management system.  (Project)
  • Create reports, based on transactional data, including elements such as data groupings and summary values.  (SQL Assignments, Project)

Syllabus: