Relational DB Design and SQL

Course Code: CPAN 152

Academic Year: 2024-2025

The study of database design and management of a database is an essential component of the business IT world today. Through this course the student will gain a background in database design. The student will work with entity-relationship diagrams (ERD) to learn and implement the basic database design. Using Oracle SQL, the students will apply the design principles to actually create and develop a working database. This course is designed to help students integrate theoretical material with practical knowledge to implement a database. Students will also use SQL commands to query single and multiple tables. Single and group functions will also be used to enhance queries. Subqueries will be used to enhance data retrieval. Data manipulation of data will also be covered to change the data in the database. We will discuss the connection of an application program to the database to store and retrieve data.