Introduction to Database Systems

General Terms

Data: Facts that can be recorded and accessed.
- Data formats: Various forms including text, numbers, figures, graphics, images, audio/video recordings, etc.
- Importance: Recorded data is kept due to its utility to an intended user.
Information: Data accessed for a specific purpose.
- Requirement for access: This often requires actions such as searching, processing, or manipulating the data.

Metadata

Definition: Data that describes the structure and properties of other data.
- Essential function: Crucial for understanding and proper use of data.

Database Definitions

Database: A structured collection of related data stored on a computer medium.
- Organization: Data is organized to facilitate efficient access to captured information.
Database Metadata: Structure of the database providing essential details like:
- Names of data structures.
- Data types.
- Data descriptions.
- Other characteristics.

Definition: Software for:
- Creation of databases.
- Insertion, storage, retrieval, updating, and deletion of data.
- Maintenance of databases.
Database System: A computer-based system enabling efficient interaction between users and database information.

Front-end applications: Mechanisms allowing user interaction with DBMS.
End-users: Individuals using database systems in their tasks.
- Direct interaction: Users communicate directly with DBMS.
- Indirect interaction: Users interact through front-end applications.

Step 1: Requirements Collection, Definition, and Visualization
- Outcome: Specification of data and system capabilities.
- Documentation: Clearly defined requirements in written form and visualized.
Step 2: Conceptual Database Model
- Definition: Visualization of requirements using conceptual data modeling techniques (e.g., entity-relationship modeling).
Step 3: Database Modeling (Logical Database Modeling)
- Purpose: Creation of a model implementable by DBMS software.
- Relation to Steps: Follows the conceptual database modeling phase.
Step 4: Database Implementation
- Process: Using a DBMS to create the actual database.
- Common software: Most modern databases use relational DBMS (RDBMS) and employ Structured Query Language (SQL).
Step 5: Front-End Application Development
- Design: Creating applications for indirect end-user interaction.
- Components: Includes interfaces (forms, reports) accessible via navigation mechanisms.
Step 6: Database Deployment
- Description: Releasing the database for end-user use.
Step 7: Database Use
- Operations: Insertion, modification, deletion, and retrieval of data.
- Example: Demonstrations of how data can be manipulated within the database.
Step 8: Database Administration and Maintenance
- Activities: Supporting end-users, addressing technical issues, ensuring data security, providing backup and recovery procedures.

Database Analysts: Involved in requirements collection, definition, and visualization.
Database Designers: Also known as modelers/architects who conduct the database modeling phase.
Database Developers: Implement the database model using DBMS software.
Front-end Applications Analysts: Gather and define application requirements.
Database Administrators (DBAs): Oversee maintenance and administration of the database.
Database End Users: Use the system for work-life tasks; vary in sophistication and data frequency access.

Operational Information (Transactional Information)
- Definition: Information used in daily operational needs within businesses.
- Operational Database: Collects operational information for day-to-day processes.
Analytical Information
- Definition: Information collected for analytical tasks, informed by operational data.
- Analytical Database: Organized to support analytical functions.

Chapters 2-6: Issues in development and use of operational databases.
Chapters 7-10: Issues in development and use of analytical databases.
Chapter 11: Overview of functionalities of RDBMS packages and maintenance of databases.