ICT 214 - 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: 3)


Total Weeks: 15





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:
- Understanding of 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
- Gain hands-on experience with 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


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