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.
ICT Diploma Program Admission
For current information and details on transfer credit for this and other courses, check the BC Transfer web site at http://bctransferguide.ca/.
Upon successful completion of the course, students will be able to:
Database Design - Open source, no purchase required.
Percentage grades will be converted to letter grades at the home institution.
|2||Introduction to Databases, Database Environment|
|3||The Relational Model|
|5||Normalization, Functional Dependencies|
|6||SQL: Data definition
Creating databases, tables
|7||Constraints, Data integrity, Introducing Scripting|
|8||Database Life Cycle|
|10||SQL: Update, Delete, Insert|
|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.|