Question 1: What do you understand by normalization?
Question 2: Convert following un-normalized table into normalized tables.
|
project
SD
|
- Project Title
|
Project Manager
|
Project
Budget
|
Employee No.
|
Employee Name
|
Department No.
|
Department Name
|
Hourly Rate
|
|
PC010
|
Pensions System
|
M Philips
Philips
|
24500
24500
|
510001
510030
|
A Smith rnones
|
1004
1023
|
IT
Pensions
|
22 00
18 50
|
|
PC010
|
Pensions ---"M System
|
|
PC010
|
Pensions System
|
M Philips
|
24500
|
521010
|
P Lewis
|
1004 |
IT |
21 00
|
|
PC045
|
Salaries System
|
H Martin
|
17400
|
510010
|
B Jones
|
1004 |
IT |
21 75
|
|
PC045
|
Salaries System
|
H Martin
|
17400
|
510001
|
' A Smith
|
1004 |
IT |
18 00
|
|
PC045
|
Salaries System
|
H Martin
|
17400
|
531002
|
T Gilbert
|
1028 |
Database
|
25.50
|
|
PC045
|
Salaries System
|
H Martin
|
17400
|
513210
|
W Richards
|
1008 |
Salary |
17 00
|
|
PC064
|
HR System
|
K Lewis
|
12250
|
531002
|
T Gilbert
|
1028 |
Database
|
23.25
|
|
PC064
|
HR System
|
K Lewis
|
12250
|
521010
|
P Lewis
|
1004 |
IT |
17.50
|
|
PC064
|
HR System
|
K Lewis
|
12250
|
510034
|
B James
|
1009 |
HR |
16.50
|
Question 3:
employee (personizame, street, city )
works (person_name, company_name, salary)
company (company:me, city)
manages (person_name, manager_name)
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"