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, Pre-Computer Science, A.S. (General Transfer), Computer Programming, A.A.A.S.

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:
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

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

AP Min. Score: n/a
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: IRW 98, IRW 99

Mandatory Department Assessment Measures:
None

Course Type:
Program Requirement- Offering designed to meet 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
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.

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