Search
MyUMUC
WebTycho| Rota, Spain (Rota Education Center) | Weekend B, Saturdays & Sundays |
| 2001-2002/Term 1 | 9:00 to 16:00 |
| Lecturer: Ed Deaton |
| Description | Objectives | Text | Grading | Communication | Schedule |
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.
Text
Database Systems: Design, Implementation, and Management,by Peter Rob & Carlos Coronel, 4th edition, 2000, 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 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: 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.
Students are encouraged to work in teams of two.
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.| 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
| Weekend | Topics | Activities | Assigned Chapters |
|---|---|---|---|
| 1 25/26 August |
DATABASE CONCEPTS
File Systems and Databases The Relational Database Model Entity Relationship Modeling |
Assign the Database Projects. Discuss the self directed database project in groups E-R modeling exercises will be assigned |
1,2,4 |
| 2 15/16 September |
DESIGN CONCEPTS
An Introduction to Structured Query Language Normalization of Database Tables |
Project Reports, Milestone I due Saturday morning SQL exercises will be assigned on Saturday. Normalization exercises will be assigned on Sunday. |
3,5 |
| 3 29/30 September |
ADVANCED DESIGN AND IMPLEMENTATION
Database Design ADVANCED DATABASE CONCEPTS Transaction Management and Concurrency Control NEW DEVELOPMENTS Object Oriented Databases |
MIDTERM EXAM 29 September 0900-1200, chapters 1-5. Project Reports, Milestone II
|
Read 6,9,10
Skim 7,8 |
| 4 13/14 October |
The Data Warehouse
Databases and the Internet Database Administration Course Review |
FINAL EXAM 14 October. 1300-1600, Chapters 6-14 Project Reports, Milestone IV due Saturday morning Project Reports, Milestone V due Sunday morning |
11,12,13, 14 |
| Top | Description | Objectives | Text | Communication | Grading |