ICS 434-01
- Advanced Database Systems
Quiz # 1
1. Mark as True
or False
a.
Every relation is
an ordered set.
b.
Every relation
can be perceived as a table where duplicates are not allowed.
c.
SQL tables can
hold duplicate tuples.
d.
A composite foreign
key can have some (or all) components with A-marks.
e.
An
A-mark or an I-mark is treated as
a value.
f.
An expression
with A-mark and I-mark will be converted to A-mark during expression
evaluation.
2. Give a tautology that causes problems in evaluating
a three-valued logic.
3. Identify the three main goals of Codd’s Relational Model Version 2.
4. Mark the following as MAYBE_A, MAYBE_I, MAYBE:
|
Salary |
Bonus |
EMP [ (Salary < 7,000) and (Bonus <
1,000) ] |
EMP [ (Salary > 11,000) and (Bonus <
4,000) ] |
|
6,000 |
- I |
|
|
|
- A |
2,000 |
|
|
|
12,000 |
1,800 |
|
|
|
- A |
1000 |
|
|
|
15,000 |
- A |
|
|
|
- I |
-A |
|
|
2. Map the following EER diagram into a relational
databases schema using Options B and C:
Option
B
Option C