
|
Maryland in Europe -- Graduate
Programs 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: |
|
|
|
U.S. Mail: |
Ed Deaton |
|
|
Web site: |
Tentative Course Schedule
|
Day |
Topics |
Activities |
Assigned |
|
October 28 |
DATABASE CONCEPTS |
Introduction to the course. Introduction to various database models. |
1,2 |
|
October 30 |
DESIGN CONCEPTS AND
IMPLEMENTATION |
Assign the Database
Projects. |
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 |
|
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 |
Project Reports, Milestone III |
9 |
|
November 27 |
Distributed Database Management Systems |
|
10 |
|
December 2 |
NEW DEVELOPMENTS |
|
11 |
|
December 4 |
Client/Server Systems |
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 |
|