Relational Database Management System Flashcards
1
Q
Invented Relational Database Management System
A
Edgar F. Codd
2
Q
Commercial RDBMS products from numerous vendors started to appear about
A
1980
3
Q
Model of database consist of multiple relations/tables
A
Relational Database
4
Q
Relational Database Model consists of
A
- Data structure
- Data Manipulation
- Data Integrity
5
Q
Columns of data
A
Fields
6
Q
Rows of data
A
Records
7
Q
Synonym Table
A
Entity
8
Q
Using SQL to manipulate data
A
Data manipulation
9
Q
organized in table with rows and column
A
Data Structure
10
Q
business rules that maintain data integrity
A
Data Integrity
11
Q
Unique identifier
A
Primary key
12
Q
primary key that consists of more than one attribute
A
composite key
13
Q
copy key from other table or reference key
A
foreign key
14
Q
Description of overall structure of data base
A
Schema
15
Q
Set of valid atomic values for given attribute
A
Domain
