final exam review #2

Question 1

Given the below functional dependency,

MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)

which of the following statements is not known to be true?

a. MedicineCode is a determinant
b. MedicineName is a determinant
c. Manufacturer is functionally dependent on Medicine Code
d. ShelfLife is functionally dependent on MedicineCode

Answer 1

b. MedicineName is a determinant

Question 2

One application of OLAP is

a. shipping of information
b. order processing
c. decision support
d. file updating

Answer 2

c. decision support

Question 3

An entity can represent which of the following

a. person
b. thing
c. event
d. all of the above

Answer 3

d. all of the above

Question 4

defines database structures

Answer 4

DDL (Data definition language)

Question 5

data definition and updating (insert/update/delete)

Answer 5

DML (Data manipulation language)