ITEC 210 - Database Design

This course will provide a practical foundation of database design and implementation.  The course will cover relational modelling, relational design, normalization, functional dependencies, requirements gathering to design a solid database and SQL.  The SQL component will introduce the student to inserting, editing, deleting and retrieving data from the database.  There will be a strong hands-on component that includes real-world examples and exercises.

 

Credits: 3

 

Hours: 45 (Lecture Hours: 30, Laboratory Hours: 15)

 

Total Weeks: 15

 

Prerequisites:
CPSC 101 or ITEC 150 or permission of Chair

 

Non-Course Prerequisites:
None

 

Co-Requisites:
None

 

Course Content: 
- Introduction to Databases, Database Environment
- The Relational Model
- ER Modeling
- Normalization, Functional Dependencies
- SQL: Data definition
- Creating databases, tables
- Constraints, Data integrity, Introducing Scripting
- Database Life Cycle
- SQL Basics
- SQL: Update, Delete, Insert
- Views

 

Learning Outcomes:
Upon successful completion of this course, the student has reliably demonstrated the ability to: 
- Explain the role of database systems in organizations
- Perform data modeling using the entity-relationship data model
- Use the principles of systems analysis, analyze business process to construct a database solution
- Demonstrate competency using MS Access, MYSQL, or SQL Server
- Apply stochastic methods to model real world situations

 

Grading System: Letters

 

Passing Grade: D (50%)

 

Percentage of Individual Work: 100

 

Text Books:
Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.