FACULTY MEMBER: Frank Richey TERM: Spring 2015
COURSE TITLE: Data Management
COURSE NUMBER: IST7000
COURSE SCHEDULE: Monday 1:30 am – 4:00 pm
TEXT BOOK: Title: Modern Database Management, 11th edition
Author: Jeffrey A. Hoffer, V. Ramesh, Heikki Topi
FACULTY CONTACT INFORMATION: frank.x.richey@wilmu.edu
Office hours: Are held in classroom an half hour before and after class.
COURSE DESCRIPTION: This course covers the concepts of databases and data base usage, database system concepts and architecture, data modeling using the entity-relationship model, record storage and primary file organizations, index structures for files, relational model concepts, SQL-the relational database standard, relational database design , examples of relational database management systems: Oracle, database design, database recovery techniques, database security and authorization, data warehousing and data mining.
This course provides an understanding of the issues in man aging database systems as an essential organizational Resource. Students learn the enterprise data architecture Components, data storage configurations, and information retrieval methods. Focus will expand from the relational model to the multidimensional l model, and include object-relational techniques, data security and data recovery.
COURSE OBJECTIVES:
MAJOR INSTRUCTIONAL GOALS
GOAL A: Understand concepts covered in class that relate to Data Base Management Systems (DBMS) in a contemporary business environment.
Learning Outcomes: The student will be able to:
A-1 Examine and research topics of current interest specific to data management concepts
A-2 Produce data reports
A-3 Distinguish between data models
A-4 Design a working database
GOAL B: Gain an appreciation of the technologies involved in data-based systems and applications.
Learning Outcomes: The student will be able to:
B-1 Identify through use, data modeling concepts
B-2 Distinguish between database