Course Code
Academic Year
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