CS652
Data Management I
| Course | Room | Day | Time |
| CS652 100 | SMI 218 | Tues. | 6:00 – 9:30 |
INSTRUCTOR: Dr. Mary Ann Robbert
HOMEPAGE: HTTP://CIS.BENTLEY.EDU/MROBBERT
EMAIL: MROBBERT@BENTLEY.EDU
0FFICE: Smith 415
PHONE: 781 – 891 - 2175
OFFICE HOURS:
| Tuesday | 3:30 – 5:30 |
| Wednesday | 4:30 –6:30 |
| Thursday | 3:30 – 5:30 |
Other times by appointment.
CATALOG DESCRIPTION: The architecture of current database systems is examined, beginning with the differences between database and file processing systems and continuing through object-oriented and client/server models. The course covers techniques for managing the design and development of large database systems, including creating and using logical data models, concurrent processing issues and database administration. The Oracle multi-user DBMS supports the class work.
COURSE OBJECTIVES: This course is designed to increase awareness of the variety and complexity of current database management systems. Students will learn database architectures and be able to select appropriate systems to meet requirements. Students will model and construct databases and analyze results produced by various conditions. Students will study data management issues and be able to provide solutions for cases.
TEACHING METHODOLOGY: Database architectures and concepts are presented and illustrated using text and lecture material describing the components and variations of current databases. SQL examples are used to exemplify implementation problems. Discussions of reading assignments and in class group work will allow sharing of information. Computer assignments and a project implemented in Oracle, will be used to reinforce the presented concepts and gain businesslike experience.
PREREQUISITE: CS651
COMPUTER USE: Computers linked to the Bentley network through either the LAN or the Internet will be used to access course databases on Oracle8i.
REQUIRED TEXTS:
EVALUATION: The final course grade will be determined by the following:
| Item | % | Comments |
| Class Participation & Homework | 15 | Analysis assignments and discussion of readings |
| Database Project | 35 | Oracle implementation and presentation |
| Exam 1 | 25 | Material covered first 5 weeks |
| Exam 2 | 25 | Comprehensive |
Tentative Schedule of Topics
| WEEK | DATE | TOPICS | ASSIGNMENT DUE |
| 1 | 5/22 | Introduction to database systems. Comparison of DBMS's, relational in particular. Data base architecture, Client/server ANSI/SPARC levels What makes a database relational ? Overview of relational concepts Review of SQL, PARTS database |
Chapt. 1, 2, 3 Create PARTS database |
| 2 | 5/29 | Identifying anomalies and dependencies- Functional
dependencies Normalization- Designing and normalizing relational tables |
Chapt. 10, 11, 12 Readings |
| 3 | 6/5 | Data Modeling- Entity- Relationship model Project assignments |
Chapt. 13
Normalization homework |
| 4 | 6/12 | Organizing data for global information- Domains, relations, data types, essentiality, Outer joins Relational Integrity. Analysis of Missing Information- Nulls and their effect on the integrity of the DB. Using Oracle Developer. | Chapt.5, 8 & 18 Data Models
|
| 5 | 6/19 | EXAM 1 Project Reviews |
|
| 6 | 6/26 | Exam Review
Views, when to use, limitations-Denormalization, Optimization- indexing, optimizers Transaction Processing System- Backup and recovery. Designing an organization recovery plan |
Chapt. 9 & 14, 17
Project Milestone 1 |
| 7 | 7/10 | Concurrency Control- Managing concurrent transactions through
locking and timestamps
Accessing databases through the web |
Chapt. 15 Project Milestone 2
|
| 8 | 7/17 | Privacy and Security- Levels of security, Securing system
through access control and application design
Object Oriented Databases- Database objects and processes, Inheritance |
Chapt. 16 Project Milestone 3 |
| 9 | 7/24 | Compare OO databases and object/relational databases. Oracle objects.
Project Presentations. |
Chapt. 12, 25 |
| 10 | 7/31 | Project presentations, Project Reflections Exam 2 |
|