Chapter 7 vocab Flashcards
A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users.
Database
Data that is produced by an organization’s everyday operations. It’s gathered in real time to provide a snapshot of what’s happening in the present.
Operational Data
Historical data that is used to help people make decisions in the present. It’s various categories include market data, transactional data, sensor data, natural language, and machine data.
Analytical Data
Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.
Database Management System (DBMS)
A data structure in a relational database that is comprised of fields (columns) and records (rows).
Table
A method of asking questions about the data stored in a database.
Query
A graphical interface that allows users to query a database by filling in information on the form
Form
An easy-to-read listing of the results of a query.
Report
A database that holds data on multiple related tables.
Relational Database
A single attribute of each record in a table.
Field
A single instance of an entity stored in a database table.
Record
A field in a table that uniquely identifies a record.
Primary Key
A field that corresponds to the primary key field in another table.
Foreign Key
a computer language used by most relational databases for creating queries.
SQL (Structured Query Language)
Database commands that change the structure, or schema, of the database
Data Definition Language (DDL)
