CMSC1216

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