CIS 171 - Database Design and Development

Description
Database Design and Development is the study of the rules and processes used to design and build relational databases. The course covers the creation of database designs using normalization of existing data as well as the development of data models. Database designs are then used in conjunction with the Structured Query Language (SQL) to build physical databases and populate them with data. It is recommended, but not required, that students have the knowledge and skills associated with taking a course on MS Access, computer programming, or algebra before taking this course.

Credit Hours: 3
Contact Hours: 3
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corequisite(s): None
Academic Program Prerequisite: None
Consent to Enroll in Course: No Department Consent Required
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit:
Programs Where This Course is a Requirement:
Data Science Certificate, Data Science, A.A.A.S., Computer Programming, A.A.A.S., Pathway Degree with Computer Information Systems Concentration, A.A.

Other Courses Where This Course is a Prerequisite: CIS 247
Other Courses Where this Course is a Corequisite: None
Other Courses Where This course is included in within the Description: None

General Education Requirement:
None
General Education Learner Outcomes (GELO):
NA
Course Learning Outcomes:

Explain the components of a relational database and the database management system that governs it.
Create a set of business rules given a knowledge of how an organization operates and the data it needs to persist.
Build a database model composed of an Entity-Relationship Diagram (ERD) containing entities, attributes, and relationships designed using business rules.
Normalize a relation to fourth normal form (4NF) or Boyce-Codd Normal Form (BCNF).
Use the Structured Query Language to build a physical database from a normalized set of relations or a data design document.
Use the Structured Query Language to populate a database with data, modify and delete that data, and query a database using joins and subqueries where appropriate.
Explain the challenges in maintaining, securing, and preserving a database in a multi-user environment.
Develop a plan to implement a solution to a problem or issue.
Identify quality sources for data and information pertinent to a problem or issue being examined.

Course Outline:

Database Systems
Database Models
The Relational Data Model
Entity Relationship (ER) Modeling
Advanced Data Modeling
Normalization of Database Tables
Introduction to Structured Query Language (SQL)
Advanced SQL
Database Design
Big Data and NoSQL

Approved for Online and Hybrid Delivery?:
Yes
Instructional Strategies:
Lecture: 30-60%

Facilitated discussion: 0-20%

Group work: 0-10%

Applied work: 10-40%
Mandatory Course Components:
None
Equivalent Courses:
None

Accepted GRCC Advanced Placement (AP) Exam Credit: None
Name of Industry Recognize Credentials: None

Course prepares students to seek the following external certification:
No
Course-Specific Placement Test: None
Course Aligned with ARW/IRW Pairing: ARW 100 (Previously IRW97/IRW98), IRW 101 (Previously IRW 99)

Mandatory Department Assessment Measures:
None

GRCC Course Type:
Program Requirement: Meets the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1
Total Lecture Hours Per Week: 3
People Soft Course ID Number: 102840
Course CIP Code: 11.9999
Maximum Course Enrollment: 24
Course Software Utilized: Microsoft Office, especially Access and Word; DB Browser for SQLite; Lucidchart; AWS Academy; MySQL

High School Articulation Agreements exist?: None
School: School of STEM
Department: Computer Information Systems
Discipline: CIS
Faculty Credential Requirements:
Master’s Degree (GRCC general requirement), Other (list below), Professionally qualified through work experience in field (Perkins Act or Other) (list below)
Faculty Credential Requirement Details:
The instructor must possess knowledge of relational database theory and experience in designing and developing relational database systems including normalization, development of ERD diagrams, and use of SQL DDL and DML language to build and query databases.

Major Course Revisions: N/A
Last Revision Date Effective: 20260220T14:28:36
Course Review & Revision Year: 2030-2031