I.   Course Syllabus

II.  Database Systems: A Practical Approach to Design, Implementation, and Management

• Chapter 1: Introduction to Database
• Chapter 2: Database Environment
• Chapter 3: The Relational Model
• Chapter 4: Relational Algebra
• Chapter 5: SQL - Data Manipulation
• Chapter 6: SQL - Data Definition
• Chapter 8: Oracle 9i
• Chapter 9 & 10 Database Planning and Design
• Chapter 11 & 12: Entity-Relationship Modeling
• Chapter 13 & 14: Normalization
• Chapter 15 & 16: Conceptual and Logical Database Design
• Chapter 17 & 18: Physical Database Design and Monitoring
• Chapter 19: Security
• Chapter 20: Transaction Management
• Chapter 25, 26, & 27: Object-Oriented DBMS
• Appendix C

III.  Normalization

• Normalization Problems
• Normalization Problem Solution

IV.  Project

• Term Project
• Term Project Questions
• Term Project Data

• Exam

VI.   Oracle Assignment

• SQL data file