CIS-445: Class Schedule

DATE	TOPIC	READING ASSIGNMENT	HOMEWORK ASSIGNMENT
6-08 Tue	Orientation Basic DBMS Concepts	Syllabus Pre-Test Pre-Survey Four Major Systems Functions {ppt}	none
6-09 Wed.	File-based vs. Database systems Data hierarchy Objectives of DBMS - Review Bank Case	R&C Chap 1, 14.1, 14.2 Bank Case R&C Table 1.1 (p.10) R&C 1.4.3 Nine Objectives of DBMS Design {ppt}	none
6-10 Thur	Objectives of DBMS - Student Recap of 9 Objectives - Discuss Bank Case Phases of Database Design - Process - Goals & Objectives	Bank Case Nine Objectives of DBMS Design {ppt} Three Phases of DB Design (Overview) {ppt} Three Phases of DB Design (Process) {ppt}	RQ 1.1, 1.2, 1.3, 1.4, 1.8 (p. 47)
6-11 Fri	Data Independence E-R Model	R&C 1.3.2 Data Independence {ppt} R&C Chap 4 E-R Model {ppt}	none
6-14 Mon	Relational Model 4 rules of Relational Models Relational Model - Key Fields - Terms - Key Fields - Concepts	R&C Chap 2; 1.5.3 Relational Models -- Four Rules {ppt} Key Fields [concepts] {ppt} Key Fields [terms] {ppt}	RQ 4.2, 4.7, 4.12 (p. 269-270) Prob 4.1 (p. 272) handout midterm Midterm Exam Sample RQ 2.1, 2.7, 2.11 (p. 95-96)
6-15 Tue	Normalization	R&C Chap 5; 1.3.4-1.5 Normalization {ppt} in class (groups)	Prob 2.1 thru 2.16 (p. 98-101)
6-16 Wed	Normalization - Normalization Cases (1&2)	Cases	RQ 5.8, 5.9 (p. 308) In-class normalization case / project [Cases #1 & 2]
6-17 Thur	Normalization - Normalization Case #3	In class Case	Prob 5.1 thru 5.5 (p. 308-309) Normalization case #3 Assign Database Project Groups Database project guidelines
6-18 Fri	NO CLASS	ACBSP Conference	none
6-21 Mon	NO CLASS	ACBSP Conference	none
6-22 Tue	ACCESS: - Query, Report Generator, Form - Create a database	ACCESS Chap 1,3 (p. A1f)	Prob 5.14 thru 5.17 (p. 311)
6-23 Wed	ACCESS: - Print, Form, Graph - Database Maintenance - Query	ACCESS Chap 2,4	Normalization Case #4: (Ye Olde Genreal Store)
6-24 Thur	ACCESS: -Reports & Forms - Advanced Techniques: Meeting the 9 Objective - Comprehensive Case	ACCESS Chap 4, 5	In-class ACCESS case
6-25 Fri	SQL	R&C Chap 3 R&C Chap 9	SQL Online Reference Book 14 example queries using PREMIER database
6-28 Mon	File / Record Locking Concurrent Processing Database Administration - Data Warehouse - Data Repository	R&C Chap 6 & 9 "Vault" article R&C Chap 13 & 14 Security (Traditional) Model	Emerging Technology Guidelines Database project due
6-29 Tue	Security - Introduction / Security Model - Business/Disaster Recovery - Passwords	Disaster Model Password Case Study Access Matrix Model	Prob 6.1 (p. 362-363) RQ 14.1, 14.4, 14.6, 14.7, 14.8 (p. 793-794)
6-30 Wed	Emerging Technologies OOPS, C/S, Internet PRESENTATIONS: Emerging Technologies & DBMS	R&C 11 & 12 Presentation Instructions	RQ 14.18, 14.19, 14.20, 14.23, 14.26 (p. 794-795) RQ 11.1 thru 3 (p. 606-607)
7-01	FINAL EXAM	Multiple Choice Comprehensive In-class	Sample final exam

CIS-445 / Database Management Class Schedule - Summer 1999 Dr. Tommie Singleton

CIS-445 / Database Management
Class Schedule - Summer 1999
Dr. Tommie Singleton