DATABASE

1
Chapter 10

• DATABASE
• MANAGEMENT

2

• Data and Information
• Database
• DBMS
• Data Integrity
• The Hierarchy Of Data
• Database-File-Record-Field-Char
• Primary key
• Maintaining Data
• Adding Records
• Changing Records
• Deleting Records

3

• Data Validation
• Alphabetic/Numeric Check
• Range Check
• Consistency Check
• Completeness Check
• Check digit
• File Processing Vs Databases
• File Processing Systems
• Data Redundancy
• Isolated Data

4

• The Database Approach
• Front-End
• Back-End
• Overcomes drawbacks of filesystems
• DBMS
• Data Dictionary
• Metadata
• FileMaintenance and Retrieval
• Query Language
• Query-By-Example
• Form
• Report Generator

5

• Data Security
• Backup and Recovery
• Relational DBMS
• Data Model
• Relation/Tuple/Attribute
• Table/Row/Column
• Relationship
• Normalization
• Relational Algebra
• Projection
• Selection

6

• Join
• Structured Query Lang.
• Object-Oriented DBMS
• Object Query Lang.
• Web DataBases
• Database Server
• Common Gateway Interface Script
• DataBase Administration