Database Management

Database Management

by peerawut smithiphechawong

1. databases, data, and information

1.1. Database

1.1.1. Database Management System

1.1.1.1. Create a computerized database

1.1.1.2. Add, modify, and delete data

1.1.1.3. Sort and retrieve data

1.1.1.4. Create forms and reports from the data

1.2. Data

1.2.1. Text

1.2.2. Numbers

1.2.3. Images

1.2.4. Audio

1.2.5. Video

1.3. Information

1.3.1. Documents

1.3.2. Audio

1.3.3. Images Video

2. The Hierarchy of Data

2.1. Data is organized in layers

2.1.1. Files

2.1.2. Records

2.1.3. Fields

2.1.4. Characters

3. Maintaining Data

3.1. Adding records

3.2. Modifying records

3.3. Deleting records

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 dat 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. Relational, Object- Oriented, and Multidimensional Databases

5.1. Data model

5.2. Relational database

5.3. Relationship

5.4. Structured Query Language(SQL)

5.5. Object-Oriented Database(OODB)

5.6. Multidimensional Database

5.7. Data Warehouse

6. Web Databases

6.1. Shop for products or services

6.2. Buy or sell stocks

6.3. Search for a job

6.4. Make airline reservations

6.5. Register for college classes

6.6. Check semester grades