database 2

1

Assignment #3 Fundamentals of Databases

Deadline: December 14, 2016

Question 1: What do you understand by normalization? (1 Point)

Question 2: Convert following un-normalized table into normalized tables. (2 Point)

Question 3: (2 point )

Consider the relational database of the above, where the primary keys are underlined. Give an expression in tuple relational calculus and Domain Relational Calculus for each of the following queries: a. Find all employees who work directly for “STC” b. Find all cities of residence of all employees who work directly for “STC”