SQL Vocab Flashcards
(16 cards)
a piece of information
Datum
Plural form of Datum
Data
A two-dimensional grid consisting of rows and columns
Table
Table AKA
Base Relvar
Data that describes the structure and formatting of the data itself
MetaData
Collection of data arranged for ease and speed of search and retrieval by a computer
Database
AKA for Rows in a Table
Records
AKA for Columns in a table
Fields
AKA for Fields/Columns
Attributes
A Database design conceived by Edgar F Codd
Relational Database
The unique identifier for the record in the table
Primary Key
Things a Primary Key must be
unique, record by record, and must not be null
in a relational database, tables are often referred to as
“Relations”
A field within a table that is acting as the primary key in another table in the dataset
Foreign Key
Schema AKA
entity relationship diagram (ERD)
