CIS 218 - Database Concepts

5 Credits

Introduction to the relational model and database design principles. Design and create a database and application using a relational database system. Learn Structured Query Language, including inserting, updating, deleting, and selecting data, and table joins.

FeesCF

Quarters Typically Offered

Fall Day

Designed to Serve Students enrolled in Web/Database Developer; students enrolled in the Database Certificate program; professionals wishing to add database concepts and design to their technical skillset.
Active Date 2015-09-25

Grading Basis Decimal Grade
Class Limit 30
Contact Hours: Lecture 55 Lab 0 Field Studies 0 Clinical 0 Independent Studies 0
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
Course Outline
I.Database terminology
II.Database design
III.ER (entity-relationship) modeling
IV.Normalization
V.Relationships and cardinality
VI.Forms
VII.Reports
VIII.Queries
IX.SQL (Structured Query Language): SELECT, INSERT, UPDATE, DELETE, joins

Student Learning Outcomes
Design a database and create an ER diagram.

Create database tables and the relationships between them.

Learn to gather and analyze business requirements.

Write basic SQL SELECT queries to retrieve, sort, and filter data. Use relational and logical operators.

Add, edit and delete table data.

Define important database terms and concepts.

Create and implement an E-R model.

Understand and enforce referential integrity.