UMUC Europe
SearchSearch Contact UsMyUMUC Site MapWebTycho  

 

Maryland in Europe -- Graduate Programs
Bowie State University -- Management Information Systems

INSS 550 -- Database Management and Decision Systems



 

Rota, Spain (Rota Education Center)

Mondays and Wednesdays

2002-2003/Term 2

6:45 to 9:30 pm

Lecturer: Ed Deaton

 

Credit

3 semester hours of credit
Prerequisites: Either INSS 510, INSS 520, INSS 530 or permission of the instructor.

Course Description

This course examines methods of designing and developing databases to create a data resource for an organization, and to provide information in support of management decision-making. Concepts to be covered include data modeling and database design, using structures such as the relational model, object-oriented databases and in-memory databases. The course deals with the organizational and technical problems of implementing databases, including those used in client/server architectures. Management information requirements are discussed, as well as the decision support capabilities of data warehousing and data mining.  A significant database project is part of the course.  The SQL language will be introduced and used in the project.

Text

Database Systems: Design, Implementation, and Management,
by Peter Rob & Carlos Coronel, 5th edition, 2002, Course Technology.

Course Evaluation

Grades for this course will be based on:

 

Homework Exercises

15%

 

Database Project

40%

 

Midterm Examination

20%

 

Final Examination

25%



Computation of Final Grades

 

A

90 to 100

 

B

80 to 89

 

C

70 to 79

 

F

below 70

 

 

 

Instructor: Edmund I. Deaton

Dr. Deaton received his Ph.D. in Mathematics from The University of Texas. He was professor of mathematics and served as chair of the Department of Mathematics and Computer Science at San Diego State University.  He was a visiting professor of Computer Science at Oklahoma State University in 1980-1982 and again in 1992.   He has been teaching and doing research in Computer Science since 1980. After many years at San Diego State University he was a visiting professor at Hope College, Holland, Michigan during 1993-1995. He has been with the University of Maryland, European Division since 1995. He teaches in the graduate MIS program and also teaches undergraduate computer science courses. His academic specialty is database design. His primary hobbies are hiking and Alpine climbing. Home address: Avenida de Sevilla, 11, 1 8 I, Rota, Telephone: 956 81 38 51

Objectives

Students successfully completing this course should gain an understanding of:

  • How a database turns large collections of data into a valuable organizational resource.
  • Management information as a form of decision support.
  • How models of database requirements are developed.
  • How databases are designed and implemented using database management software.
  • Concepts of database operations and administration.
  • Current trends in the technical and managerial aspects of databases.

Minor Assignments

Minor assignments will be drawn from, or similar to, textbook end-of-chapter problems, in order to reinforce technical database concepts.

Project

A database project is required. This will involve modeling, designing and implementing a database, using one of the currently available languages or DBMS software packages. In addition, students will explain the operational and managerial use of their database, and where its technical aspects fit in the current state of the industry. There are five milestones in the project; the due dates are in the schedule. 

Policies

Class attendance is expected. Students are responsible for all material covered during lectures as well as assigned textbook readings. Lectures and class discussions will be conducted on the assumption that students have read the material in the current reading assignments and are prepared to bring their observations and questions to class.

On such matters as exceptional grades, academic dishonesty and attendance, the policies of the current Graduate Catalog of the University of Maryland in Europe will apply.

Office Hours and Communication

Students may request individual discussions before or after class, or by appointment.  The instructor will always be available at the end of each class session. Other office hours will be announced and posted.  Students are encouraged to meet with the instructor frequently.

 

e-mail:

edeaton@faculty.ed.umuc.edu

 

U.S. Mail:

Ed Deaton
University of Maryland
PSC 819 Box 54
FPO AE 09645

 

Web site:

http://faculty.ed.umuc.edu/~edeaton


Tentative Course Schedule

Day

Topics

Activities

Assigned
Chapters

October 28

DATABASE CONCEPTS
File Systems and Databases
The Relational Database Model

Introduction to the course. Introduction to various database models.

1,2

October 30

DESIGN CONCEPTS AND IMPLEMENTATION
Entity Relationship Modeling

Assign the Database Projects.
Discuss the self directed database project in groups

3

November 4

Normalization of Database Tables

 

4

November 6

Structured Query Language

 

5

November 11

Structured Query Language (continued)

Project Reports, Milestone I

5

November 13

ADVANCED DESIGN AND IMPLEMENTATION
Database Design

 

6

November 18

Review and study

Project Reports, Milestone II

Skim 7,8

November 20

 

Mid term exam, chapters 1 - 6

 

November 25

ADVANCED DATABASE CONCEPTS
Transaction Management and Concurrency Control

Project Reports, Milestone III

9

November 27

Distributed Database Management Systems

 

10

December 2

NEW DEVELOPMENTS
Object Oriented Databases

 

11

December 4

Client/Server Systems
The Data Warehouse

Project Reports, Milestone IV

12,13

December 9

Databases in Electronic Commerce

Web Database development

 

14, 15

December 11

DATABASE ADMINISTRATION

Database Administration

 

16

December 16

 

Project Reports, Milestone V

 

December 18

 

FINAL EXAM, Comprehensive

 

 

Accreditation | Contact Us | Catalogs | Worldwide Locations | Press Room | Nondiscrimination |  ©2008