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


CPSC 101 or ITEC 150 or permission of Chair


Non-Course Prerequisites:




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.