Database Management

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

1. Databases,Data,and Information

1.1. Database

1.2. Data

1.3. Information

2. The Hierarchy of Data

2.1. A character is one byte

2.2. A field is a combination of one or more related characters

2.3. A record is a group of related fields

2.4. A data file is a collection of related records

3. Maintaining Data

3.1. File maintenance

3.1.1. Adding records

3.1.2. Modifying records

3.1.3. Deleting records

3.2. Validation

3.2.1. compares data with a set of rules or values to find out if the data is correct

4. File Processing Versus Databases

4.1. File processing system

4.1.1. Each department has its own set of files

4.1.2. Used for many years

4.1.3. Have data redundancy

4.1.4. Isolate data

4.2. Database approach

4.2.1. Programs and users share data

4.2.2. Reduce data redundancy

4.2.3. Improve data integrity

4.2.4. Share data

4.2.5. Allows easier access

4.2.6. Reduces development time

4.2.7. Can be more vulnerable

5. Database Management Systems

5.1. A data dictionary

5.2. A query language

5.3. Query by example(QBE)

5.4. A form

5.5. A report generator

6. Relational,Object-Oriented,and Multidimensional Databases

6.1. A data model

6.2. A relational database

6.2.1. Each rowhas a primary key

6.2.2. Each columnhas a unique name

6.3. A relationship

6.4. Structured Query Language(SQL)

6.5. An object.oriented database (OODB)

6.6. A multidimensional database

6.7. A data warehouse

7. Web Databases

7.1. Databases on the Web allow you to

7.1.1. Shop for products or services

7.1.2. Buy or sell stocks

7.1.3. Search for a job

7.1.4. Make airline reservations

7.1.5. Register for college classes

7.1.6. Check semester grades

8. Video:How a Photo Sharing site Keeps Its Data

9. Database Administration

9.1. It is important to have a carefully designed database

9.2. Employees should learn how to use the data in the database effectively

9.2.1. Interact with database

9.2.2. Identify new data for the database

9.2.3. Maintain the database