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

School: School of STEM
Department: Computer Information Systems
Discipline: CIS

Last Revision Date Effective: 2017-03-03 20:29:54
Course Review & Revision Year: 2025-2026

Course Type:
Program Requirement- Offering designed to meet the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1

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.

Approved for Online Delivery?: Yes

Course Outline:
I. Fundamental Principles of Database Design and Development
II. Building Data Models
III. Transforming Data Models into Data Designs
IV. Transforming Data Designs into Physical Databases
V. Populating and Querying a Database using SQL
VI. Designing a Database using Normalization
VII. Designing a Database through Redesign
VIII. Managing Multi-user Databases

Mandatory CLO Competency Assessment Measures:
None

Name of Industry Recognize Credentials: None

Instructional Strategies:
Lecture: 30-60%

Facilitated discussion: 0-20%

Group work: 0-10%

Applied work: 10-40%

Mandatory Course Components:
None

Academic Program Prerequisite: None
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corerequisite(s): None
Course-Specific Placement Test: None
Course Aligned with IRW: IRW 98, IRW 99
Consent to Enroll in Course: No Department Consent Required

Total Lecture Hours Per Week: 3
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.

Maximum Course Enrollment: 24
Equivalent Courses: None
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit:
Programs Where This Courses is a Requirement:
Data Science Certificate, Pre-Computer Science, A.S. (General Transfer), Computer Programming, A.A.A.S.
People Soft Course ID Number: 102840
Course CIP Code: 11.9999

High School Articulation Agreements exist?: None