4.
We wish to develop a database to keep track of persons, their children and their cars.
For this purpose, we will use the following relation:
PersonData(pNbr, pName, pAddress, cNbr, cName, cAddress, aLic, aMake)
pNbr, pName, pAddress is the person number, name and address of a person. cNbr,
cName, cAddress is the corresponding information for a child. Each person has exactly
one address. aLic, aMake is the license number and make of a car. A car may be owned
by more than one person
a) What are the functional dependencies in this relation? Find the keys of the relation.
b) Is this relation in BCNF? Justify. If not, decompose it into relations that are in BCNF.