Exam 8: Data Abstractions

Describe the distinction between a traditional database and a data warehouse.

Given the relation Employees containing the attributes Name, Address, and CurrentJobID and the relation Jobs containing the attributes JobID, SkillRating, Department, what question is answered by the following sequence of operations?

Given the two relations X and Y below draw the relation Result that would be produced by the following statements? Temp $\leftarrow$ JOIN X and Y where X.A > Y.D Result $\leftarrow$ PROJECT X.B, Y.C from Temp

Given the relation X below what value will be extracted by the following query? TEMP $\leftarrow$ SELECT from X where B > C RESULT $\leftarrow$ PROJECT A from TEMP

Given the relation X below what value will be retrieved by the following query?

Identify two database models. ____________________ ____________________