C-ID Descriptor
Introduction to Database Management Systems

None

None

Business Information Systems/Computer Information Systems (C-ID ITIS 120 or C-ID BUS 140)

1. Introduction to Databases
   1. Databases and Database Users
   2. Database Systems Concepts and Architecture
   3. Data Management Strategy, Regulatory Compliance, and related Data Ethics
2. Conceptual Data Modeling and Database Design
   1. Data Modeling Using the Entity Relationship (ER) Model
3. The Relational Data Model and Structured Query Language (SQL)
   1. The Relational Data Model and Relational Database Constraints
   2. Basic SQL
   3. More SQL: Complex Queries, Triggers, Views, and Schema Modification
   4. Relational Database Design
4. Database Programming Techniques
   1. Introduction to SQL Programming Techniques
   2. Web Database Programming
5. Database Objects
   1. Object and Object-Relational Databases
   2. Object-based Application Programming Interfaces (APIs)
   3. XML: Extensible Markup Language
6. Database Design Theory and Normalization
   1. Basics of Functional Dependencies and Normalization for Relational Databases
7. File Structures, Hashing, Indexing, and Physical Database Design
   1. Disc Storage, Basic File Structures, Hashing, and Modern Storage Architectures
   2. Indexing Structures for Files and Physical Database Design
8. Query Processing and Optimization
   1. Strategies for Query Processing
   2. Query Optimization
9. Transaction Processing, Concurrency Control, and Recovering
   1. Introduction to Transaction Processing concepts and theory
   2. Concurrency control techniques
   3. Database recovery techniques
10. Distributed databases, NoSQL systems, cloud computing, and Big Data
    1. Distributed database concepts
    2. NoSQL databases, and Big Data storage systems and technologies
11. Advanced database models, systems, and applications
    1. Introduction to information retrieval and web search
    2. Data Mining concepts
    3. Overview of Data Warehousing and Online Analytical Processing (OLAP)
12. Database Administration
    1. User privileges
    2. Performance tuning
13. Business continuity
    1. Disaster recovery
    2. Database security
    3. Information assurance
    4. Data encryption

At the conclusion of this course, the student should be able to:

1. Define the role of databases, database management systems, and related ethics and risks in a dynamic global regulatory environment.
2. Understand basic database structure.
3. Design a relational database so that it is at least in 3rd Normal Form.
4. Implement a relational database design using a common database management system, including the principles of data type selection and indexing.
5. Use the data definition, data manipulation, and data control language components of Structured Query Language (SQL) in the context of one widely used implementation of the language.
6. Describe the role of databases and database management systems in the context of enterprise systems, including various cloud-based implementation models.
7. Describe the key principles of data security and identify data security risk and violations in data management system design.
8. Describe the fundamentals of Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP), and how they relate to business intelligence, data warehousing, and data mining.
9. Demonstrate the basics of monitoring, managing, backing up, restoring, and securing database instances.
10. Describe business continuity considerations related to database management.

Evaluation will include applied hands-on projects and a combination of examinations, presentations, discussions, or problem-solving assignments.

• Elmasri, R. & Navathe, S., Fundamentals of Database Systems, Pearson
• Kroenke, D. M. & Auer, D., Database Concepts, Pearson