COURSE Code: CPAN 260
4 Credits
Course Description
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 strong theoretical background in database design. The student will work with entity-relationship diagrams (ERD) to learn and implement the basic database design. Students will also use the normalization principles to also to enhance and further develop the database design. Using Oracle 10g SQL, the students will apply the design principles to actually create and develop a working database. The students will use a data-modeling 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 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 in addition to subqueries to query data. Manipulating of data in the database is also covered.
