Data Flashcards
What is the term for a system that converts large amounts of data into a usable format to help users make business decisions?
Database Management system
Most databases are what kind of database that is multi-dimensional, allowing information to be accessed from various views through linking between entries
Relational database
What traditional system for data is one-dimensional by presenting information from a single point of view and does not interact with other files?
Flat file systems
What integrates stored information from collections of data and maintains it?
Database system
What is the act of analyzing and converting data into information that can be used in decision-making?
Database research
What are the two major layers of a database management system?
An application layer
Database management layer
Which database management layer does not directly manipulate the data, but is used as a tool to obtain the results?
Application layer
The database management layer operates like a what in that it supports the application software?
Operating system
A database table known as a what is composed of records and fields that hold data
Datasheet
Data is store in records representing what in the data table?
Rows
A what is a single piece of data in a data sheet about the subject of record
Field
A what is a column in a data sheet
Field
Fields in a flat file are separated by what?
Delimiters like space or columns
Flat file, relational, hierarchical and object-oriented are some of the most common what?
Database models
In what database model is data organized in a tree-like structure much like an organization all chart
Hierarchical
What is a unique identifier in a relational database called?
Primary key
What code includes queries to identify what data should be retrieved or how the data should be manipulated?
Structured query language (SQL)
Which SQL operation takes rows from one table and creates a new table?
Select