Database Systems Concepts: Exercises | Saylor Academy

Home Specialization Programs Help

Read this chapter. Pay attention to the properties of a database and DBMS. Then, complete the exercise at the end of the chapter.

Exercises

What is a database management system (DBMS)?
What are the properties of a DBMS?
Provide three examples of a real-world database (e.g., the library contains a database of books).

Course Introduction

Course Syllabus

Unit 1: Introduction to Data Management

1.1: Data Management

Data and Databases

1.1.1: Data Lifecycle Management

Research Data Management 101

1.1.2: Value within Data Management

Data Governance

1.1.3: Research Data

Managing Research Data

Basics of Research Data Management

1.2: Data Management Plans

Data Management Planning

Data Management Plans

1.3: Data Management Careers

The Evolving Role of the Data Architect

1.3.1: Data Consultant

Data Consultants and Architects

1.3.2: Operations Analyst

Operations Analysts

1.3.3: IT Systems Analyst

IT Systems Analysts

1.3.4: Database Administrator

Database Administrator

Unit 1 Study Resources

Unit 1 Review Video

Study Guide: Unit 1

Unit 1 Assessment

Unit 1 Assessment

Unit 2: Understanding Databases and DBMSes

2.1.1: Database Design and terms

Database Systems Concepts

2.1.2: Database Software

Characteristics and Benefits of a Database

2.1.3: Data Administration

O*NET Online Summary Report for Database Administrators.

2.2.1: The Essentials

Introduction to Database Management System (DBMS)

2.2.2: How Organizations Use DBMS

Combining Data Management with Organizational Change

Unit 2 Study Resources

Unit 2 Review Video

Study Guide: Unit 2

Unit 2 Assessment

Unit 2 Assessment

Unit 3: Data Models

3.1: Types of Data Models

Data Modeling

Types of Data Models

Data Modeling and Metadata Management

3.1.1: Conceptual Models

Data Modelling

3.1.2: Logical Models

Types of Data Models

3.1.3: Physical Models

Physical Data Models

3.2: Data Model Advantages and Disadvantages

Lessons in Data Modeling

What are the Advantages of a Relationship Model?

3.3: The Enhanced E-R Model and Business Rules

The Entity-Relationship Model

Business Rules

3.3.1: Supertypes and Subtypes

The Enhanced Entity-Relationship Model

3.3.2: How Business Rules are Used

Integrity Rules and Constraints

3.4: Database Security

Database Security

Unit 3 Study Resources

Unit 3 Review Video

Study Guide: Unit 3

Unit 3 Assessment

Unit 3 Assessment

Unit 4: Big Data Processing and Cloud Computing

4.1: Big Data

Introduction to Big Data

4.1.1: Big Data Storage

Infrastructure for Big Data

4.1.2: Big Data Analytics