CMSC 127: Database Systems
Course Description
This is a 3-unit course that will discuss about data models: relational, network,
hierarchical model; database management system, data definition and manipulation
language; data security, integrity, synchronization, protection, and recovery;
principal database systems and query languages.
Course Learning Outcomes
After completion of the course, the student should be able to:
- Demonstrate an understanding on database concepts and structures;
- Explain terms related to database design and management;
- Explain data modeling and database development process;
- Design models and database systems;
- Write database queries using SQL; and
- Manage database system
Course Outline
UNIT 1. Introduction to Database Systems
- Database System Applications
- Purpose of Database Systems
- View of Data
- Database Languages
- Relational Databases
- Database Design
- Data Storage and Querying
- Transaction Management
- Data Mining and Information Retrieval
- Specialty Database Systems
- Database Users and Administrators
- Entity-Relationship Diagram
UNIT 2. Introduction to Relational Model
- Structure of Relational Model
- Database Schema
- Keys
- Schema Diagrams
- Relational Query Languages
- Relational Operations
UNIT 3. Introduction to SQL
- Overview of the SQL Language
- SQL Data Definition
- Basic Structure of SQL Queries
- Additional Basic Operations
- Set Operations
- Null Values
- Aggregate Functions
- Nested Subqueries
- Modification of the Database
UNIT 4. Intermediate SQL
- Join Expressions
- Views
- Transactions
- Integrity Constraints
- SQL Data Types and Schemas
- Authorization