1. Database Administration
1.1. It is important to have a carefully designed database
1.2. Employees should learn how to use the data in the database effectively
1.2.1. Interact with database
1.2.2. Identify new data for the database
1.2.3. Maintain the database
2. Databases,Data,and Information
2.1. Database
2.2. Data
2.3. Information
3. Video:How a Photo Sharing site Keeps Its Data
4. Database Management Systems
4.1. A data dictionary
4.2. A query language
4.3. Query by example(QBE)
4.4. A form
4.5. A report generator
5. Web Databases
5.1. Databases on the Web allow you to
5.1.1. Shop for products or services
5.1.2. Buy or sell stocks
5.1.3. Search for a job
5.1.4. Make airline reservations
5.1.5. Register for college classes
5.1.6. Check semester grades
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. URK17CS065 A.KOUSHIK REDDY
8. The Hierarchy of Data
8.1. A character is one byte
8.2. A field is a combination of one or more related characters
8.3. A record is a group of related fields
8.4. A data file is a collection of related records
9. Maintaining Data
9.1. File maintenance
9.1.1. Adding records
9.1.2. Modifying records
9.1.3. Deleting records
9.2. Validation
9.2.1. compares data with a set of rules or values to find out if the data is correct
10. File Processing Versus Databases
10.1. File processing system
10.1.1. Each department has its own set of files
10.1.2. Used for many years
10.1.3. Have data redundancy
10.1.4. Isolate data
10.2. Database approach
10.2.1. Programs and users share data
10.2.2. Reduce data redundancy
10.2.3. Improve data integrity
10.2.4. Share data
10.2.5. Allows easier access
10.2.6. Reduces development time
10.2.7. Can be more vulnerable