| Course | CISC 215 – Database Processing and Design |
| Date/Time | Monday / Wednesday 1400 – 1520 |
| Location | Meen 107 |
| Instructor | Walter Wimberly |
Course Description
This course covers the fundamentals of database systems essential for information management. Focusing primarily on relational databases, the course presents the entity-relationship model, query processing and normalization. It provides an understanding of data modeling, database design, database implementation, and other aspects of database management. The laboratory component utilizes Microsoft Access and the SQL language.
Course Tools
In this course, we will be utilizing MS Access and MySQL for our Database work, and LucidChart to develop ERDs. MS Access is available in all lab computers.
Course Outline
| Class Activities | Assignments |
| Introduction to CISC 215 Chapter 1: Database Systems | NA |
| Chapter 2: Data Models | Email your Instructor |
| Chapter 3: The Relational Database Model | |
| Chapter 4: Entity Relationship (ER) Modeling | |
| Entity Relationship Diagram (ERD) Video Series Go straight to the Series: Video Series on ERDs | |
| Chapter 5: Advanced Data Modeling | |
| Chapter 6: Normalization of Database Tables | |
| MS Access – Video Series | |
| Chapter 7 Introduction to Structured Query Language (SQL) | |
| Chapter 8: Advanced SQL | |
| MySQL/SQL Video Series | |
| Chapter 9: Database Design | |
| Chapter 10: Transaction Management and Concurrency Control | |
| Chapter 12: Distributed Database Management Systems | |
| Chapter 13: Business Intelligence and Data Warehouses | Final |
