Genesee Course Listing

Official Course Information

Please select a Course Section from the List below or use Search for a class by Title.

Fall 2018

Computer Information Systems Courses:

  or   List All Computer Information Systems Courses

CIS208 - Database

Credits: 3

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 successful completion of this course as documented through writing, objective testing, case studies, laboratory practice, and/or classroom discussion, the student will be able to:

1. Read and interpret an entity-relationship (ERD) model diagram, and map it into a relational model.
2. Apply the technique of normalization to a relational model that results in a set of normalized relations to the level of BCNF.
3. Map a relational model into a DBMS product through SQL DDL statements.*
4. Query a relational database implemented in a DBMS product through SQL DML statements.*

* This course objective has been identified as a student learning outcome that must be formally assessed as part of the Comprehensive Assessment Plan of the college. All faculty teaching this course must collect the required data and submit the required analysis and documentation at the conclusion of the semester to the Office of Institutional Research and Assessment.

Content Outline:
1. Conceptual Foundation of the DBMS
1.1 Terminology
1.2 DBMS components and basic architecture

2. Conceptual Foundation of the Relational Model
2.1 Terminology
2.2 Keys and Referential Integrity
2.3 Functional Dependencies and normalization

3. Data Modeling Techniques
3.1 The motivation for Data Modeling
3.2 Basic E-R elements and components
3.3 Basic relationships
3.4 Reading and Interpreting an E-R diagram

4. Relational Mapping and Normalization
4.1 Rules for representing E-R relationships with the relational model
4.2 Constructing a relational model from an E-R diagram

5. Relational Algebra review and SQL
5.1 General syntax rules
5.2 SQL DDL statements
5.3 Introduction to a DBMS product
5.4 Using SQL DDL statements to create a DB
5.5 SQL DML statements
5.6 Using SQL DML statements to query a DB

Effective Term: Fall 2013