Search
MyUMUC
WebTychoMaryland in Europe Graduate Programs
Bowie State University
Database Management and Decision Systems
INSS 550
Term III: 20 January 2003 - 14 March 2003
Course Dates: 1/2/15/16 February, 1/2/15/16 March
SHAPE
9:00 - 16:00
|
Instructor: |
N. Filiz Gungordu |
|
Mailing Address: |
Brussels Education Center, Attn: Gungordu, PSC79/UMUC, APO AE 09714 |
|
Email Address: |
fgungord@faculty.ed.umuc.edu |
|
Consultation: |
Before or after class and by appointments. |
Course Description: Prerequisite: Either INSS 510, INSS 520, INSS 530, or permission of the instructor. 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/Objectives: At the conclusion of this course the student will understand and be able to explain:
|
1. |
Database concepts and practices | |
|
2. |
The relational database model | |
|
3. |
Other database models – hierarchical, network, object-oriented etc. | |
|
4. |
Design development and implementation | |
|
|
a. |
Entity Relationship Diagrams (ERD) |
|
|
b. |
Relational schema |
|
|
c. |
Table normalization |
|
|
d. |
Structured Query Language (SQL) |
|
|
e. |
ANSI/SPARC 3-level architecture - subschemas |
|
|
f. |
Other design methods |
|
5. |
Concepts of distributed database architecture | |
|
6. |
Two- and three- tier database architectures | |
|
7. |
Internet database development | |
|
8. |
Concurrency control and transaction management | |
|
9. |
Security of databases | |
|
10. |
Organizational issues – database administration | |
|
11. |
Role of data and information in decision making | |
Text: Rob, P., and Coronel, C. (2002). Database Systems: Design, Implementation, and Management (5th ed.). Boston: Course Technology.
Grading Information: Grades for this course will be assigned as follows:
Please feel free to modify the following for your own breakoffs, but maintain the grades of A, B, C, F(a), and F(n)
|
|
A |
92% + |
C |
70 – 79% |
|
|
B |
80 – 91% |
F |
Below 70% F(a) or regular non-attendance F(n) |
Course Requirements:
Grades for this course will be based on:
|
Assignments (2- each 10%) |
20% |
|
Group Project |
30% |
|
Class Participation & Class Work |
10% |
|
Mid-term exam |
20% |
|
Final exam |
20% |
Project Description: The demand for employees with the knowledge and skills for operating in a DBMS environment is increasing rapidly. The goal of the project for this course is to help students to relate the textbook concepts to a simplified real world problem. This includes planning, collecting data, organizing data and implementing appropriate database structures for storage and retrieval. Besides the course textbook, you are encouraged to use other reading materials, tools and skills to complete the task.. Students will work in groups on the selected topic. The group size will not exceed 3 members.
Course Schedule:
|
Date / Time |
Topics/Assigned readings |
Assignments due dates |
|
Feb. 1 (Morning) |
Chapter 1- File Systems and Databases |
|
|
Feb. 1 (Afternoon) |
Chapter 2 - The Relational Database Model |
|
|
Feb. 2 (Morning) |
Chapter 3 - Entity Relationship (E-R) Modeling |
|
|
Feb. 2 (Afternoon) |
Chapter 4 - Normalization of Database Tables Project topic selection |
|
|
Feb. 15 (Morning) |
Chapter 5 - Structured Query Language (SQL) |
Assignment 1 |
|
Feb. 15 (Afternoon) |
Chapter 6 - Database Design |
|
|
Feb. 16 (Morning) |
Chapter 7 & 8 The University Lab Project Discussions |
|
|
Feb. 16 (Afternoon) |
Midterm Exam |
|
|
March 1 (Morning) |
Chapter 9 - Transaction Management and Concurrency Control |
|
|
March 1 (Afternoon) |
Chapter 10 - Distributed Database Management Systems |
|
|
March 2 (Morning) |
Chapter 11 - Object-Oriented Databases |
|
|
March 2 (Afternoon) |
Chapter 16 - Database Administration Project Discussions |
Project Phase 2 |
|
March 15 (Morning) |
Chapter 13 - The Data Warehouse |
|
|
March 15 (Afternoon) |
Chapter 14 - Databases in Electronic Commerce Chapter 15 - Web Database Development, |
|
|
March 16 (Morning) |
Presentation of projects |
Project Phase 3 |
|
March 16 (Afternoon) |
Final Exam |
|
IMPORTANT NOTE : Database Management and Decision systems is a combined course. The class meetings will be held together with IFSM 410 students. Both of the groups are expected to participate in the class discussions. However, the assignments, project requirements and the exams will be prepared according to the differing expectations of graduate vs. undergraduate courses. The projects for INSS 550 will be more in depth than those required for IFSM 410. Graduate exams will be 30% vocabulary, and 70% comprehensive exam type questions. The comprehensive exam type questions will be graded 75% for content, 25% for English and organization. The assignments for graduate students will be writing papers on selected current topics and preparing presentations..
About Your Instructor: Associate professor. Bachelor of Science in Electrical Engineering, and Master of Science in Computer Science, both from Bosphorus University, Istanbul, Turkey. She worked in the computer industry as systems analyst, programmer and database administrator. Computerized all the business processes of a company including sales, payroll, accounting and inventory and wrote the programs to manage the databases. She has taught at Bosphorus University, Istanbul, Turkey, European Business School, Brussels, Belgium, City Colleges of Chicago, Brussels, Belgium. She has been teaching with UM since 1988 and with Bowie State University Graduate MIS program since 1999.