final exam review 5

Question 1

In the normalization process, if you find a candidate key that is not a determinant then you should NOT

a. place the columns of the functional dependency in a new relation
b. make the determinant of the function dependency the primary key of the new relation
c. rename the determinant to another attribute description
d. leave a copy of the determinant as a foreign key in the original relation

Answer 1

c. rename the determinant to another attribute description

Question 2

In moving your data model from the logical to the physical, which is NOT true

a. relations become tables
b. ID Dependent weak entities require referential integrity constraints
c. Attribute domains become intersection tables
d. all are true

Answer 2

c. attribute domains become intersection tables

Question 3

In many-to-many relationships in a relational database design

a. the intersection table is ID dependent on one of the parents
b. the intersection table is ID dependent on both of the parents
c. the minimum cardinality from the interaction table to each of the parents is one
d. b and c

Answer 3

d. b and c

Question 4

a virtual table that is constructed from other tables or views

Answer 4

SQL view

Question 5

entire area of one or both tables

Answer 5

union

Question 6

area in table A not in table B

Answer 6

Complement

Question 7

allows you to group rows in a data set and summarize values in designated columns. Can be used in conjunction with the aggregate function to group the result by one or more columns

Answer 7

GROUP BY

Question 8

A subquery that refers to values from the outer query in its execution.

Answer 8

Correlated subquery