Common Course Outline

Catalog Description

Course Description

This course introduces database design and implementation concepts. Students will learn how to design, build, and use databases utilizing a relational Database Management System (RDBMS) such as Microsoft SQL Server, MySQL, Oracle, or PostgreSQL. Topics include relational database design principles, Entity-Relation (ER) diagrams, and Structured Query Language (SQL). Students will use SQL to create, retrieve, update, and delete database tables and records. They will design and implement their own relational databases. College level reading is required.

Date Last Revised (Month, year)

December, 2022

Outline of Major Content Areas

1. Relational database design
2. Entity-relationship diagrams
3. Other data models
4. Structured Query Language (SQL)
5. Data types
6. Creation of new tables and records
7. Retrieving records
8. Updating tables and records
9. Deleting tables and records
10. Other SQL functions
11. Analysis of SQL query results

Learning Outcomes (General)

The student will be able to:

1. Explain and apply the basic concepts of the relational data model
2. Explain how relational DBMSs are used in industry and research
3. Design databases and implement them on a relational DBMS system.
4. Enter and retrieve information from databases
5. Create and interpret Entity-Relationship Diagrams
6. Use SQL commands to create queries.
7. Analyze query results.

Learning Outcomes (MnTC)

NA

Methods for Evaluation of Student Learning

Methods may include but are not limited to:

• Tests
• Assignments
• Labs
• Database design and implementation

RCTC Core Outcome(s)

This course contributes to meeting the following RCTC Core Outcome(s):

Critical Thinking

Students will think systematically and explore information thoroughly before accepting or formulating a position or conclusion.

Special Information (if any)

None