INSS 550 / IFSM 410

DATABASE MANAGEMENT

and

INFORMATION SYSTEMS

Term II-(2000-2001)

Instructor: N. Filiz Gungordu

LOCATION:. SHAPE Education Center, Belgium

WEEKENDS: 28 & 29 October, 11 & 12 November

2 & 3 December and 16 & 17 December

TIME: 9:00 -16:00

COURSE DESCRIPTION: (3 credits): 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 are also examined. The role of data in the decision-making process is examined. Decision support system architecture is reviewed with emphasis on the database component. Issues of intelligent databases are discussed

REQUIRED TEXT:

Database Systems: Design, Implementation, and Management, Peter Rob and Carlos Coronel, Fourth Edition, Course Technology, 2000

OBJECTIVES. This course enables students to understand:

	data as a valuable organizational resource requiring management to further the objectives of the organization
	the importance of designing good and useful databases
	the logical structure of relational models
	how to use a powerful and useful query language (SQL) for information extraction
	how to evaluate and design good “table” structures to control data redundancies
	what a Database Life Cycle is and why databases are subject to constant evaluation
	the transaction properties of databases and how SQL can be used to represent transactions
	why concurrency control is important in databases
	the importance of Distributed Database Systems (DDBMS)
	the basic features of an Object Oriented Database management systems (OODBMS)
	the impact of Client/Server architecture on database design
	the function of data warehouses and how On=line analytical processing (OLAP) systems can be used to extract information from data warehouses
	how Internet components are fit into database environment and the basics of database architecture
	the basis for a successful database administration strategy

COURSE EVALUATION: Grades for this course will be based on

15% Assignments (Asg#1-5% & Asg#2-10%)
30% Project
25% Midterm Exam
30% Final exam

and will be assigned as follows:

A ( 90 to 100), B ( 80 to 90 ), C ( 70 to 80 ), D ( 60 to 70 ), F Less than 60

Class attendance is required. There will be two assignments. The assignments will be announced each week during the class.

COURSE SCHEDULE:

Dates

Chapters Assignments & Exams

28 & 29October

PART I: DATABASE CONCEPTS Chapters 1-3
File Systems and Databases
The Relational Database Model
Structured Query Language (SQL)
Assignment # 1 Due on 2 November 2000

Announcement of Projects – Due Date 16 December

2 & 3 November

PART II: DESIGN CONCEPTS Chapters 4-8
Entity Relationship (E-R) Modeling
Normalization of Database Tables
PART III: ADVANCED DESIGN & IMPLEMENTATION
Database Design
The University Lab: Conceptual Design
The University Lab: Conceptual Design
Verification, Logical Design, and
Implementation
Assignment # 2 Due on 11 November 2000

11 & 12 November

Midterm – 11 November, 2000 A.M.

PART IV: ADVANCED DATABASE CONCEPTS Chapters 9 & 10
Transaction Management and Concurrency Control
Distributed Database Management Systems
PART V: NEW DEVELOPMENTS Chapters 11 & 12
Object-Oriented Databases
Client/Server Systems

16 & 17 December

Presentation of projects

The Data Warehouse - Chapter 13
Databases and The Internet - Chapter 14
PART VI: DATABASE ADMINISTRATION – Chapter 15
Database Administration

Final Exam – 17 December P.M.