ICT 214 Database Design

Credits: 3

Course Content:
This course provides a practical foundation of database design and implementation. The course covers 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.

Course Format:

  • Approximately 45 hours to complete and scheduled over a 15-week period.

Course Prerequisites:
ICT Diploma Program Admission

Transfer Credits:
For current information and details on transfer credit for this and other courses, check the BC Transfer web site at http://bctransferguide.ca/.

Learning Outcomes:
Upon successful completion of the course, students will be able to:

  • Understand 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.

Required Materials/Texts:
Database Design - Open source, no purchase required.

Evaluation Profile:

Assignments/Exercises
10-20%
Quizzes/Exams
20-30%
Projects (2)
30-40%
Final Exam
20-30%
TOTAL 100%

Grading Profile:
Percentage grades will be converted to letter grades at the home institution.

Syllabus:

Module
Topics
1 Course Outline
2 Introduction to Databases, Database Environment
3 The Relational Model
4 ER Modeling
5 Normalization, Functional Dependencies
6 SQL: Data definition
Creating databases, tables
7 Constraints, Data integrity, Introducing Scripting
8 Database Life Cycle
9 SQL Basics
10 SQL: Update, Delete, Insert
11 Views

Operational Details:

College Policies: Academic Appeals (including appeal of final grades), Student Conduct, Cheating and Plagiarism, Academic Probation and other educational issues. Copies of these and other policies are available in the College Calendar.
Attendance: As this is an on-line course, attendance requires participation in the course, not time in a classroom. However, students must ensure that they complete their required participation in online discussions and other similar assignments.
Occasionally, online meeting/discussion forums times may be arranged in conjunction with the students availability.
Missed Exams: Quizzes and periodic tests must be written when scheduled for the class. This policy may be modified should the student submit written documentation, acceptable to the department, supporting a valid reason for missing the quiz or test (i.e. family or personal emergency, etc.).
Late Assignments: Late assignments will not be marked without the student having made prior arrangements with the instructor.
Cheating/Plagiarism: Plagiarism is the presentation of another person's words, ideas, interpretations, insights, or order of points as one's own. All work submitted must be the student's own words and content, and not written by a tutor or friend. If external sources are used for an essay or assignment, they must be documented to avoid plagiarism.