CMSC 1216Database Modeling I
St Cloud Technical and Community College · 3 credits

Catalog
Databases are an integral part of modern computer applications. This course introduces students to basic relational database concepts, relational database terminology, and data modeling concepts. Students will create a conceptual data model using entity-relationship diagrams, understand the importance of referential integrity, and learn how to enforce data integrity constraints when creating a database. SQL Data Manipulation Language and Data Definitions Language will be used to create database objects and to insert, read, update, and display data in a relational database management system. An introduction to NOSQL databases will also be covered. Student Learning Outcomes: * Install and configure a relational database in a Virtual PC environment. * Employ database normalization techniques. * Create and maintain relational databases, tables and other objects using Structured Query Language (SQL). * Write SQL statements to create indexes, views, referential, entity, domain and user-defined constraints on database tables. * Write SQL statements and scripts to insert, delete, update and retrieve data in tables. * Write SQL statements to extract and manipulate data from database objects using joins. * Determine differences between different relational databases and not-relational databases
Recent sections
Spring 2027 · 1 section
Jan 11 – May 14
| Section | Days & time | Location | Instructor |
|---|---|---|---|
| 22Class #000483 | Time not published | MISC NON-BLDG INTERNE | Rachel Gramann |
| 22 notes: Source meeting: {"start_date": "2027-01-11", "end_date": "2027-05-14", "days": null, "times": null, "room": "MISC NON-BLDG INTERNE", "instructor": "Gramann, Rachel"} | |||