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.