Faculty Contact Information:
e-mail: lcalabresi@faculty.ed.umuc.edu
work phone: +39 081 842 7128
|
|
Consultation:
Before or after each class meeting, or by appointment.
Class meetings are Tuesdays and Thursdays, 17.30 - 20.30, starting March 30th and ending May 20th.
|
|
Required Texts and Readings:
|
Rob, P., and Coronel, C. (2004). Database Systems: Design, Implementation, and Management (6th ed.). Boston, MA: Course Technology.
|
|
Supplementary Readings:
The standard for papers in the graduate program is the APA style. All participants in this course and all graduate INSS, MGMT, PUAD, and ECON courses should have a copy of the style guide:
American Psychological Association. (2001). Publication Manual of the American Psychological Association, 5th Edition. Washington DC: Author.All graduate students should be prepared to utilize the UMUC online library at http://www.umuc.edu/library/. The library contains a large number of full text academic journals that are free of charge and immediately available. The library homepage also contains a number of links related to improving students' research and writing skills.
|
|
Recommended Journals:
|
Publications of the various professional societies (such as ACM -- the Association for Computing Machinery, the IEEE Computing Society, and the various management professional societies) are strongly recommended. In addition, there are many trade journals (such as eWEEK) that MIS professionals should become familiar with, many of these being published both weekly and on-line.
|
|
Course Description:
|
3 semester hours credit. Prerequisite: Either INSS 510, INSS 520, INSS 530, or permission of the Program Director. Examines database concepts and practices as they relate to business environments. Various database structures including relational and object-oriented are discussed. Concepts of distributed database architecture are explored. Design, development, and implementation of databases are examined. Organizational issues concerning the implementation of databases and the role of data in the decision-making process are examined. Decision support system architecture is reviewed with emphasis on the database component. Issues of intelligent databases are discussed. A database project is required.
|
|
Course Goals:
Upon completion of the course, participants should:
1. Understand and apply database concepts and practices
2. Understand relational and object-oriented database models, and how they compare to "traditional" models such as hierarchical and network.
3. Design and implement a relational database.
4. Understand and discuss issues associated with Internet database development.
|
|
Course Objectives:
At the conclusion of this course the student will be able to:
1. Describe, compare, and use tools of database design development and implementation, such as: Entity Relationship Diagrams (ERD), Relational schema, Table normalization, Structured Query Language (SQL), and ANSI/SPARC 3-level architecture - subschemas.
2. Discuss the advantages and issues of distributed database architecture and two- and three- tier database architectures,
3. Concurrency control and transaction management, .
4. Compare and contrast approaches to Security of databases
5. Define organizational issues and the responsibilities associated with database administration.
6. Discuss the role of data and information in decision making, and techniques such as data mining and data warehousing as used for decision support.
|
|
Grading Information:
Grades for this course will be assigned as follows:
A 92 – 100%
B 80 – 91%
C 70 – 79%
F Below 70%
Please note that Bowie State University does not use "D" for graduate students. The grade F(a) is used to designate academic failure. F(n) is used to designate failure for non-completion. Grades of Incomplete or Withdrawal are governed by UMUC-Europe policies. For further details, please refer to the UMUC-Europe Graduate Catalog, available in your local Education Center or online at http://www.ed.umuc.edu/general_info/publications/catalogs.
|
|
Course Requirements:
Graduate school at the masters level focuses on helping students obtain the education needed for success as professionals in their chosen fields. Thus, UMUC-Europe Graduate Programs and Bowie State University share the common goals of promoting excellence in academic scholarship through thoughtful inquiry and the skillful application of knowledge and theory for the betterment of society.
In order to maximize your graduate educational experience in general and this course in particular, you are required to:
10% - homework and class participation
15% - Write graduate level paper or case study and orally/visually present prepared material
20% - Complete a project, including design report and documentation
25% - Complete a Midterm examination
30% - Complete a Final examination (Comprehensive)
|
|
Description of Course Requirements:
* It will be to the your advantage to attend all classes. When absence is unavoidable, it is your own responsibility to makeup any work missed before the next class session. For administrative purposes, attendance will be recorded. If you are expecting or experiencing long absences during the term then you should contact the faculty.
* Participate in classroom discussions: You are expected to come to class prepared to engage in all discussions in a professional and informed manner.
* Write graduate level projects, papers or case studies: You are required to conduct professional-level research, including appropriately citing works of others and avoiding plagiarism. Plan on committing a considerable amount of time over the duration of this course producing professional level deliverables for your papers or case studies.
* Orally/visually present prepared material: You are required to present your results in a professional manner. In a face-to-face course, this typically means an oral presentation accompanied by appropriate visual material.
* Offline discussions will be held during class sessions as needed. Their purpose is to give you options to discuss the topics covered. You are expected to come to class prepared to engage in all discussions in a professional and informed manner. Usually this requires two to three hours for every hour of a face-to-face class.
* Complete one or more written examination(s): The examination process in this class will assist you in developing the writing and critical thinking skills necessary for successfully passing the comprehensive exam required of all graduate students. The examination questions used for this course will either be taken directly from past comprehensive exams or written as though to be included on a comprehensive exam.
* Project descriptions: bring a one-paragraph proposal describing the database you intend to design, and telling what software you will use to implement it, the night of the midterm. I can read them and approve/disapprove/request further input while you are taking the test.
If you do not have database software at home, please try to make plans to do the actual implementation in a UMUC computer lab. Most of your design work, the most critical part of the project, will not require use of the database software.
The goal is for everyone to get at least a prototype of your database working, but please remember that the heaviest emphasis is on the DESIGN (which we'll be seeing in detail in chapters 6, 7, and 8).
Don't just put the following items in for the sake of having them there, they need to actually fit "naturally" into the project -- a good rule of thumb regarding project size is to have a minimum of 3 tables, 3 forms, 3 reports, 3 queries. Note that these should not just be trivial variations of basically the same query/report/form.
|
|
Course Schedule:
Session Topics (read chapters BEFORE class!)
1. Course presentation, Review of syllabus, Clarification of goals, objectives and requirements, Orientation to subject.
Introduction File Systems and Databases (Ch. 1)
2. Data Models (Ch. 2),
Session Topics (read chapters BEFORE class!)
1. Course presentation, Review of syllabus, Clarification of goals, objectives and requirements, Orientation to subject.
Introduction File Systems and Databases (Ch. 1)
2. Data Models (Ch. 2),
3. The Relational Database Model (Ch.3), Homework 1
4. Entity Relationship (ER) Modeling (Ch. 4)
Paper topic proposal due.
5. Normalization of DB Tables (Ch. 5), Homework 2
6. Intro. to SQL (Ch. 6)
7. Questions, Midterm Exam, Project Proposals
8. Database Design (Ch.8)
Reading Extras Appendix D, E
9. The Data Warehouse (Ch. 12), Homework 3
Rough draft of paper due.
10 Databases in E-Commerce (Ch. 13)
11. Web Database Development (Ch. 14)
Topic Presentations
Project Design Documents
12 Advanced SQL (Ch. 7), Homework 4
Project Design Documents
13 Transaction Management and Concurrency Control (Ch. 9)
14. Distributed Database Management Systems (Ch. 10), Homework 5
Final version of paper due.
15. Database Administration (Ch. 15)
Review,
Paper Presentation.
16 Projects and Written Documentation, Paper Presentation,
Questions, Final Exam.
|
|
Academic Policies:
Academic Policies: Please refer to the UMUC - Europe Graduate Catalog, available online at http://www.ed.umuc.edu/general_info/publications/catalogs/index.html or from your local Education Center, for information on the following:
Academic Integrity
Course Load
Exception to Policy
Grade Appeal Process
Make-up Examinations
Nondiscrimination
Students with Disabilities
|
|
Faculty Bio:
Leonello Calabresi was born in Aversa (CE), Italy in 1966. He received the Doctor Degree in Computer Science in 1997 at University of Salerno. He works as a researcher for Advanced Systems s.r.l. in Naples.
Since 1994 he has contributed in the creation of Advanced Systems’ Software Development Environment, developing client / server software components, based on Internet Technology, and defining the general guidelines for the development of Multi-Tier and Web based Applications in that Company.
He has a broad range of experience on research projects in the field of Data Warehousing, that were developed on several of the most diffused OSs – going from IBM operating systems such as MVS and OS/400, through Microsoft Windows Platforms.
Nowadays he is a reference point in Advanced Systems in the field of Object Oriented Programming and Object Oriented Design, using C++ and Object Pascal.
Since May 2002 he is the head of the Quality System Program in Advanced Systems.
He has been teaching for UMUC undergraduate programs since March 2001 and in May 2003 he joined teaching for UMUC graduate programs.
|
|