CIS 445: DATABASE MANAGEMENT SYSTEMS
Teaching Notes - Spring 1999
Dr. Tommie Singleton

• ORIENTATION: Syllabus
• ORIENTATION: Pre-Test
• ORIENTATION: Pre-Survey
• INTRODUCTION: Four (4) Major Functions About Databases  {ppt}  [see R&C 14.1]
• INTRODUCTION: File-based systems versus Database systems (overheads)
• INTRODUCTION: Systems Model (pyramid) and Database -- [R&C 14.2 and figure 14.2 ( p.751)]
• INTRODUCTION: Definition of "Database System" -- [R&C 1.4.1]
• INTRODUCTION: Nine (9) Basic Objectives of Effective Database Design  {ppt}
• DATABASE DESIGN: Three (3) Steps in Database Design (process)  {ppt}
• DATABASE DESIGN: Three (3) Steps in Database Design (goals and activities) {handout}
• DATA INDEPENDENCE: Data Independence (includes chart)  {ppt}
• DATA MODELING: E-R Model  {ppt}
• DATA MODELING: Relational Model  {ppt}
• DATA MODELING: Key Fields - Terms  {ppt}
• DATA MODELING: Key Fields - Concepts   {ppt}
• NORMALIZATION: Normalization  {ppt}
• NORMALIZATION: Normalization Cases   [o:\cis445\...]
     1) UNA Intramurals
     2) Casum Payroll
     3) Premier Bookstore
     4) Review Homework 5.1
     5) Ye Olde General Store
• ACCESS: Textbook
• SQL: SQL Online Reference Book
• SQL: Redo Premier problems / queries [set of 14]
• CONCURRENT PROCESSING: example, file/record locking, deadly embrace, solution
• SECURITY: Security Model [handout by Dr. Singleton]
• SECURITY: Disaster Model  [diagram by Dr. Singleton]
• SECURITY: Business Recovery Plan / Disaster Recovery Plan/ Business Continuity Plan
  1) MIT's BC plan online
  2) Factory Mutual (insurance) BC plan online
  3) Disaster Recovery Journal -- online DR magazine with plans, archives, online/E-zine section
• PASSWORDS: Access Matrix Sample [Handout by Dr. Singleton]
• PASSWORDS: Password [email case study]
• EMERGING TECHNOLOGIES: in DBMS environments
• APPLICATIONS:
  Prison [Computerworld]

Last edited by Tommie Singleton on January 24, 1999