MIS 710 Database Management

* Home  * Description  * Overview  * Schedule *
* Projects  * Grades  * Discussions *

Offered by the ISOM Department, Raj Soin College of Business at Wright State University

Catalog description

MIS 710 Database Management (4.0 cr.)

Database concepts, data modeling using ER and 00 approaches, relational model, relational database design, structured query language, database system implementation, distributed database concepts, and role of commercial databases in application environments.

Pre-requisites: None

Experience with programming: it is expected that you are already familiar with Java and the process of writing moderate sized programs (100-200 lines) with Java.

Course Objectives

The primary objective of this course is to provide students with the knowledge required for designing, developing, implementing and administering database systems for common business functions. In this process, the students will learn concepts related to database design, development, querying, and programming.

Upon successfully completing this course, the student will:

1. learn how to design and understand conceptual data models using the Entity-Relationship approach;
2. understand the concepts of data normalization and logical and physical data models;
3. learn how to query a database using SQL, and how to improve query performance;
4. learn how to develop database applications through a high level programming language as an SQL interface;
5. learn how databases can be used to solve common business problems;
6. learn some of the advanced concepts in databases, including but not limited to: query processing and optimization, transaction management, data mining and warehousing, distributed databases, etc.