RATIONALE

In order to keep pace with an ever-advancing Internet and database technology, MIS professionals and students need to have a good understanding of  data modeling, database design, database implementation, database application using Internet technology, enterprise databases, and object-oriented database processing. A good understanding of these topics will prepare professionals and students for the dynamic information era in which we now exist.

COURSE DESCRIPTION

This course covers the concepts related to database management and design using a variant of MYSQL. With the use of database systems, students will understand the capabilities and limitations of a system.  Lectures will cover database relational database design, normalization, SQL queries, report, database data and documentation. In-class activities will focus on creating interactive and secure database applications.

GENERAL OBJECTIVES

At the end of this course students should be able to:

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