Introduction to Databases Assignment Questions

Question One - Consider the following three relations:

For each of the following relational expressions, compute the result on the above relations and submit only the final answer. For example, for query: πB, D(S), the result should be entered as: {(a, x), (b, y), (b, x), (c, y)}.

a. πA, D(R×S)

b. πA, D(R∞S)

c. πE(T) - πE(S∞T)

Question Two - Consider the Bank database:

a. What are the appropriate primary keys in each relation?

b. Given your choice of primary keys, identify appropriate foreign keys.

Question Three - Consider the relational database of instructor:

a. Identify at least four possible super keys?

b. Identify at least three possible candidate keys?

Question Four - Employee (Id, emp_name, age, occupation_Id, city_Id)

Occupation (occupation_id, occup_name)

City (city_id, city_name)

Consider the above relational database. Give an expression in the relational algebra to express each of the following queries:

a. Find the names and ages of all employees who work in "New York".

b. Find the names and cities of all employees who work as "Software Engineer".