Information Management
Table of Contents
(2 / 42)
List of Figures
Table of Contents
List of Figures
List of Tables
I
.
Introduction
1
.
Basic Concepts
1.1
.
What Is a Database?
1.2
.
What Is a Database Management System?
1.3
.
Business Applications and Information Systems
2
.
Key-Value Stores
2.1
.
Retrieving All Key-Value Pairs and Listing Them in a Table
2.2
.
Adding a Key-Value Pair in a User Interface
2.3
.
Deleting a Key-Value Pair
2.4
.
Updating a Key-Value Pair
3
.
Relational Databases
3.1
.
Creating a Relational Database
3.2
.
Querying a Relational Database
II
.
Information Modeling
4
.
Conceptual Information Modeling
4.1
.
Ontological Principles of Information Modeling
4.2
.
Modeling EntityTypes as Classes
4.3
.
Associations between Entity Types
4.4
.
Specialization and Generalization
4.5
.
Questions and Exercises
5
.
Making an Information Design Model
5.1
.
Using OOP Naming Conventions
5.2
.
Defining the Range of an Attribute
5.3
.
Uniqueness Constraints and Standard ID Attributes
5.4
.
Add Further Integrity Constraints
5.5
.
Questions and Exercises
6
.
Case Studies
III
.
Relational Databases and SQL
7
.
The Relational Database Model
7.1
.
Basic Concepts
7.2
.
Integrity Constraints
7.3
.
Inserting, Updating and Deleting Records
8
.
Database Queries
9
.
Database Design
9.1
.
Using Platform-Specific Datatypes
9.2
.
Deriving a Table Model from an Information Design Model
9.3
.
Coding Table Models
Index