Database
A presentation of the fundamental concepts used in data modeling and database implementation. The data modeling process, basic relational concepts, and the process of normalization, relational algebra, SQL, and guidelines for mapping a data model into a relational database will be covered. Students will model a multimedia and/or text-only problem and implement it on a single machine with a commercially available database package. Prerequisite: CIS 112, or CIS113, or CIS 125, or CIS 215, or CIS 219.
Subject Code: CIS
Course Number: 208
Credits: 3
Lecture Hours 3
Course Learning Outcomes:
1. Create a variety of relational databases
2. Create a table using the SQL language
3. Populate data into a table using SQL
4. Map an entity-relationship (ERD) model diagram into a relational database.
5. Create a variety of forms
6. Create a variety of reports
7. Create queries through a GUI
8. Create queries using SQL
9. Apply normalization to a relational model that results in a set of normalized relations to the level of BCNF
Effective Term: Fall 2025
Tutoring Services
Tutoring for all GCC students is available free of charge by professional and peer tutors. We are offering tutoring online for: accounting, math, writing, chemistry, physics, general biology, anatomy & physiology, American Sign Language, and success skills.
