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

SectionDays & timeLocationInstructor
22Class #000483Time not publishedMISC NON-BLDG INTERNERachel 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"}