Understanding Core Database Concepts Flashcards
1
Q
A Field
A
location in a record in which a particular type of data is stored
2
Q
Column
A
attribute for a row or record
3
Q
Row
A
record within a table
4
Q
Table
A
Database object consisting of rows and columns
5
Q
Record
A
Data Structure that is a collection of fields
6
Q
Relational Model
A
data is organised in relational tables
7
Q
Primary Key
A
Unique Identifier
8
Q
SQL
A
Structured Query Language, used to queries on relational database tables
9
Q
DML
A
Data Manipulation Language, insert, update and delete data
10
Q
DDL
A
Data Definition Language, Create, Modify or Drop databases objects
11
Q
Schema
A
description of a database to a DBMS
12
Q
CREATE
A
adds database or objects
13
Q
ALTER
A
changes database or objects
14
Q
DROP
A
Removes database or objects
