Database Management

Get Started. It's Free
or sign up with your email address
Database Management by Mind Map: Database Management

1. Data

1.1. Hierarchy

1.1.1. Character

1.1.2. Field Field name Field size Data type

1.1.3. Record Primary key

1.1.4. Data file

1.2. Maintaining Data

1.2.1. File maintenance Adding records Modifying records Deleting records

1.2.2. Validation Alphabetic/Numeric Check Range check Consistency check Completeness check Check digit Other checks

2. Database Management Systems

2.1. Data dictionary

2.1.1. contains data about each file in the database and each field in those files

2.2. Query language

2.3. Form

2.3.1. is a window on the screen that provides areas for entering or modifying data in a database

2.4. Report generator

3. Relational, Object-Oriented, and Multidimensional Databases

3.1. Data model

3.2. Relational database

3.2.1. stores data in tables

3.3. Relationship

3.4. Structured Query Language (SQL)

3.4.1. a query language that allows users to manage, update, and retrieve data

3.5. Object-oriented database (OODB)

3.5.1. stores data in objects

3.6. Multidimensional database

3.6.1. Sometimes known as a hypercube

3.6.2. Can consolidate data much faster than a relational database

3.7. Data warehouse

3.7.1. is a huge database that stores and manages the data required to analyze historical and current transactions