Genesee Course Listing
Official Course Information
Please select a Course Section from the list below or search for a class by Course Title.
Computer Information Systems Courses:
CIS208 - Database
Catalog Description: 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.
Lecture: 3 hrs.
Course Learning Outcomes (CLOs):
Upon the successful completion of this course, a student will be able to:
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 2019