INSS 550

20 January, 2003 – 14 March, 2003

Heidelberg High School

Tuesday and Thursday 1845-2130

Instructor:	Susan T. Dean
Mailing Address:	UMUC – Unit 29216, APO AE 09102
Email Address:	sdean@faculty.ed.umuc.edu
Consultation:	In classroom 30 minutes before class, other times by appointment. Home Phone: 49(0)6224/929773

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 (5^th ed.). Boston: Course Technology.

Grading Information: Grades for INSS 550 will be assigned as follows:

	A	90% +	C	70 – 79%
	B	80 – 89%	F	Below 70% F(a) or regular non-attendance F(n)

Course Requirements: (for INSS 550)

	Midterm Examination:	30%
	Final Examination:	30%
	Project:	25%
	Current Topic paper and Presentation:	15%

Note that graduate students will have (a) take-home question(s) in addition to in-class midterm and final examinations. Graduate students will not have the same in-class exams as undergraduate students, as graduate students are expected to master the course material at a deeper level and will be tested accordingly.

Project Description:

“Project” requires proposal, design, development, and documentation of a non-trivial database project. Details will be given during the first week of class.

“Current Topic paper and Presentation” requires proposal of a topic related to database systems, research and writing a paper on that topic, and presentation of a summary of this work in class to teach the others (and the professor) about it. Details will be given during the second week of class, and the presentations will take place during the 6^th and 7^th weeks of class.

Homework:

The undergraduates will have weekly homework assignments. Graduate students are not required to do these assignments, but may do them and submit them to be “graded” for feedback. Graduate students will not receive any points toward the course grade for doing these assignments.

Course Schedule:

Date	Topics	Assigned readings/assignments due
Tu 21 Jan	Introduction; File Systems and Databases (Ch.1); The Relational Database Model (Ch. 2).
Th 23 Jan	Entity Relationship (E-R) Modeling (Ch.3)
Tu 28 Jan	Normalization of DB Tables (Ch. 4)	Undergrad Hwk 1
Th 30 Jan	Structured Query Language (SQL) (Ch. 5)
Tu 4 Feb	SQL – cont’d; Database Design (Ch. 6)	Undergrad Hwk 2
Th 6 Feb	Database Design (Ch. 6, 7, 8)
Tu 11 Feb	Questions; Midterm Exam
Th 13 Feb	Transaction Management and Concurrency Control (Ch. 9)
Tu 18 Feb	Distributed DBMS (Ch. 10)	Undergrad Hwk 3
Th 20 Feb	Object-Oriented Databases (Ch. 11)
Tu 25 Feb	Client/Server Systems (Ch. 12); Topic Presentations	Undergrad and Grad Project Design Documents
Th 27 Feb	Data Warehousing (Ch. 13); Topic Presentations	Undergrad Hwk 4
Tu 4 Mar	Electronic Commerce (Ch. 14); Topic Presentations
Th 6 Mar	Web Database Development (Ch. 15); Topic Presentations	Grad Current Topic Papers
Tu 11 Mar	Database Administration (Ch. 16); Review
Th 13 Mar	Questions; Final Exam	U’grad and Grad Projects and Written Documentation

About Your Instructor: Susan T. Dean

Dr. Dean earned the BA in Mathematics from Vanderbilt University, and the MS and PhD in Computer Science from the University of Alabama in Birmingham. She has worked at various times as a programmer, programmer/analyst, systems analyst, and project manager in the areas of medical information systems, small business support, and life insurance. Since 1975, she has been involved in teaching and curriculum development in computing, most recently at Samford University in Birmingham, AL. She has served on the Board of Directors and as President of the Consortium for Computing Sciences in Colleges (previously known as the Consortium for Computing in Small Colleges). She serves on the Steering Committee of the CCSC Southeastern Conference. Her areas of interest include curriculum development, database management systems, programming languages, and operating systems.