Questions

416 289 5000
1-800-268-4419 (in Ontario)

P.O. Box 631 Station A
Toronto, ON, M1K 5E9

Introduction to Database Concept

Course Code CECP-102
Course Name Introduction to Database Concept
Category Information Technology & Computers
Description Introduction to Database Concepts introduces relational database concepts as related to personal, client server and enterprise database systems.

Through assignments, quizzes, class participation, a group project, and a mid-term and final exam, you will examine topics such as database and database management systems, data types, importance of a well designed database, table structure and relationships, field definitions and naming conventions, data access queries using QBE grid, SQL, data definition language (DDL) and data manipulation language (DML) commands; table creation using SQL statements, database security and evolution of data models. These concepts are reinforced using Microsoft Access for lab work and your group term project.

Oracle is also briefly introduced and used for queries. Meanwhile, Microsoft Visio is used as the diagramming tool to create entity relation diagrams.

This Introduction to Database Concepts course gives you the ability to:

• Explain the term database and database management system (DBMS) as well as the use of primary and foreign keys;
• Design simple table structures and associate them to a prescribed business problem;
• Determine cardinality between tables, and use cardinality symbols (Crow's Foot notation) to represent 1-1, 1-M and M-N relationships;
• Use cardinality symbols to draw ERDs to model tables and relationships;
• Explain fundamental differences between logical and physical database design;
• Interpret the SQL script generated in the creation of simple queries in an Access environment;
• Use SQL DDL to create simple relational databases;
• Use SQL DML to create and query sample data;
• Use normalization techniques to remove redundancies in tables;
• Apply security measures such as password, encryption and hiding database objects to secure data in Access databases.

Notes Prerequisite : CECP-101 Programming 1
Notes Register online : https://secure.centennialcollege.ca/webreg or call 416-289-5300

Email : infotech.PT@centennialcollege.ca
Contact Telephone 416-289-5207
Contact E-mail ce@centennialcollege.ca
Associated Programs
Register Online https://secure.centennialcollege.ca/webreg/
New Search
Section Cost Semester Start Date End Date Meeting Times Campus
801 $659.00 Fall 2022 2022-09-12 2022-12-05
Times Days
06:30 PM to 10:30 PM M
Progress Campus
821 $659.00 Winter 2023 2023-01-16 2023-04-10
Times Days
06:30 PM to 10:30 PM M
Progress Campus
841 $659.00 Summer 2023 2023-05-08 2023-08-07
Times Days
06:30 PM to 10:30 PM M
Progress Campus
Legend for Days
M - Monday T - Tuesday W - Wednesday R - Thursday F - Friday S - Saturday U - Sunday
TBA - To Be Announced
TOP OF PAGE