Course Description:

This course provides a solid foundation in the current database modeling techniques, database technologies and database design techniques.  This body of knowledge is essential to working on project teams with professional database designers and administrators.  Topics include entity-relationship and semantic data modeling techniques; relational, network and hierarchical database technologies; and normalization, data dependencies, resource sharing and distributed databases. Students participate in a project to design, implement and populate a database.

Required Materials:

Database Processing: Fundamentals, Design & Implementation w/CD, 8^th ed. David M. Kroenke, Prentice Hall

Various articles and supplemental readings will also be provided by the instructor.

Course Objectives:

1.      Learn the role of databases & database applications in organizations.

2.      Learn and practice data modeling using the entity-relationship and semantic object models.

3.      Learn and practice developing database designs.

4.      Understand the use of SQL and learn SQL syntax.

5.      Understand the special needs of multi-user database processing and learn technologies for controlling the consequences of concurrent data access.

6.      Know the features and functions of a commercial-duty DBMS product and understand how these are implemented in Oracle and SQL Server.

7.      Learn the need for both database administration and data administration.

8.1.Learn emerging Internet technology that is relevant to database processing including the use of XML, ASP, OLE DB, ADO, ODBC, JDBC, and JSP.

9.8.           Understand the issues involved in the enterprise data sharing and learn the nature of data warehouses.

10.9.       Learn the features and functions of OLAP and understand its relationship to database processing.

Key Topics:

Entity-relationship data modeling

Database design

Structured query language

Multi-user database processing

Database access standards

ODBC, OLE DB, ADO, and ASP
XML and ADO.NET
JDBC, Java Server Pages, and MySQL
Sharing Enterprise Data

Object-Oriented Database Processing

Data warehousing and data mining

Prerequisites:

Graduate Standing

Course Structure:

3-0-3 (class hrs/week – lab hrs/week – credit hours)

Coordinator:  John Traxler

Last Review:

                         By:

Last Revision:

                         By: