Database Basics


Data is numeric, textual, visual, or audio information that describes real-world systems.

  • varies by:
    • scope
    • format
    • access

Databases

A database is a collection of data in a structured format.

A database management system (DBMS) is software that reads and writes data in a database.

  • ensure data is secure, internally consistent, and available at all times

A database application is software that helps business users interact with database systems.

  • make it easier for non programmers to interact with data and databases

An information management system is a software application that manages corporate data for a specific business function.

  • include database system, user interface, business logic, and more

Database Roles

A database administrator is responsible for securing the database system against unauthorized users.

A database designer determines the format of each data element and the overall database structure.

A database programmer develops computer programs that utilize a database.

A database user is a consumer of data in a database.