CMSC1216 Database Modeling I

Course Description

Databases are an integral part of computer applications. This course is an introductory database modeling course. Using a relational database, this course introduces the student to relational database concepts. Data definition language constructs as well as data manipulation concepts show the student how to insert, read, update and display data in the relational database management system.

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.
  • Write SQL scripts to create stored procedures, triggers and user defined functions to retrieve, insert, update and delete data from SQL Server databases.
  • Determine differences between different relational databases as well as to how relational and ORM/NoSQL databases differ.
  • Explain user roles in a relational database environment.

Prerequisite

Please see eServices for section availability and current pre-req/test score requirements for this course.

3 credits: 2 lectures / presentations, 1 lab, 0 other