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
Objectives
- Gain an understanding of relational data models in terms of data structure, data integrity, and data manipulation.
- Understand and create conceptual database models utilizing entity-relationship modeling.
- Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology.
- Understand the theory behind the relational data model as it applies to interactions with current database management systems
- Read and interpret a given data model to query the database and transform the data into information using Structured Query Language (SQL).
- Implement a data model in a current relational database management system.
- Create SQL queries, based on transactional data, including elements such as data groupings and summary values.
Prerequisites Description
There are no pre-requisites for this class.