I. Match the terms on the left-hand side with the correct definition on the righ
ID: 3542184 • Letter: I
Question
I. Match the terms on the left-hand side with the correct definition on the right-hand side
1. ___degree
2. ___cardinality
3. ___relation
4. ___instance of relation
5. ___primary keys
6. ___ foreign keys
7. ___alternate keys
8. ___database management system
9. ___database
10. ___database application
11. ___ view
12. ___ record
a. It is a virtual or derived relation that is dynamically created from the under-lying base relation( s) when required.
b. It is a copy of the base-relation
c. It is a program that interacts with the database, at some point in its execution.
d. The number of attributes in a relation
e. An attribute, or set of attributes, within one relation that is the primary key of another relation.
f. Software that manages and controls access to the database.
g. Is an attribute, or set of attributes, that identifies tuples of a relation uniquely.
h. A tuple, or row of a relation
i. Collection of logically-related data
j. Any subset of the Cartesian product of the domains of the attributes.
k. The candidate keys not chosen for identification of tuples
l. The number of tuples or rows in a relation
Explanation / Answer
1- d
2 - l
4 - b
5 - g
6 - e
7 - k
8 - f
9 - i
10 - c
11 - a
12 - h
3 - j