Definition
_________consists of raw facts
Data
A field or set of fields that uniquely identifies the record
Primary Key
A characteristic of an entity
Attribute
DBMS
Database Management System
This contains Rows and Columns
A table
A name, number, that describes a business object or activity
Field
ETL
•Extract •Transform •Load
A person, place, or thing for which data is collected
Entity
ERD
A graphical representation to show the organization of and relationships between data
Adding and modifying data is a type of __________
Database Activity
A collection of related data fields
Record
Foreign Key
A field in one table, that refers to the PRIMARY KEY in another table.
This represents an entity in a table
Table
SQL
Structured Query Language
Microsoft Access
A DBMS
A collection of related records
File
Three Database operation
UPDATE; INSERT; DELETE
This represents an attribute of an entity in a table
Column
DDL
Data definition language
•(DaaS) Example
Database as a Service: Amazon
A collection of integrated and related files
Database
QBE
Query by Example
Range of allowable values for a data attribute
Domain
DD
Data Dictionary: A description of all the data used in the database
Three characteristics of big data
•Volume •Velocity •Variety