Department Surname FirstName Address Sales 6 High Street Eas

Department Surname FirstName Address Sales 6 High Street Eastland Fred Purchasing Eastland Fred 6 High Street Accounts Watson Ethel 27 Acacia Avenue. Personnel Eastland Sydney 27 Acacia Avenue Table 1: Relation for Problem 2

Solution

dependencies:

Department -> Surname

Department -> firstname

Department -> address

Surname -> firstname

Surname -> address

FirstName -> address

Decomposition1: R1(Department, firstname, Surname) R2(Surname, address)

Department -> Surname

Department -> firstname

Surname -> address

These are the three dependencies that we are getting from two separate table

Departmet-> address can be derived

but firstname -> address can\'t be dervied

it is not preserving all the dependencies.

Decomposition2: R1(Department, firstname, Surname) R2(Surname, firstname, Address)

Department -> Surname

Department -> firstname

FirstName -> address

Surname -> address

Department -> address

Surname -> firstname

All dependency can be derived