The IT business world relies on solid database design and management. This four-credit course will give you a strong theoretical background in database design. You will work with entity-relationship diagrams (ERD) and learn how to implement basic database design. You will also use normalization principles to enhance and further develop database design, as well as apply the design principles to actually create and develop a working database using Oracle 10g SQL. You will use a data-modelling tool to design the ERD for a database and then create the required SQL commands from this design to implement a database. This course is designed to help you integrate theoretical material with practical knowledge to implement a database. You will also use SQL commands to query single and multiple tables. Single and group functions will also be used in addition to subqueries to query data. This course is equivalent to CPAN 115 Relational DB Design and Implementation. Prerequisite(s): CPAN 110 Critical Thinking and IT Concepts Credential: This course is eligible for Computer Programming Certificate.
Contact: Faculty of Media & Creative Arts
416.675.6622 ext. 4508
Courses may not be offered each semester. To verify whether this course is being offered this semester and the fees, please contact the Registrar's Office at 416-675-5000 or check the website http://humber.ca/search/ce/courses.html for further information.