Question $1$

A database used in a European car registration system conation

and licences. The following relations are used:

Person $($Person if$\text{'}$ ino

Car $($Serial number, Plate, Name, Sumame, City, State, Country, Age, Sex$)$

Licence $($Licence number, Perser, person$\_$ID$\_$number, Type, Year, Colour$)$

Consider the following functional dependencies: Tabes in $3$NF will be as fallows:

Person$\_$ID$\_$number dots Name $($now

Person ID$\_$number $$ Surname $(n-a)$ ANomalization is the process of reducing

Person$\_$ID$\_$number cdots City$($bake$)$ duplication of data and ensule referent

Person$\_$ID$\_$number $-$ State $($lanyrism$)$

Person$\_$ID$\_$number $->$ Age

Person$\_$ID$\_$number $-.->$ Sex

City $$ State

State.$$ Country

Hele property ld transtivily depents custam

Plate$\_$number $...>$ Serial$\_$number

Plate$\_$number $--->$ person$\_$ID$\_$number

coutract, so avoid deperdency we sepera

Plate number $--->$ Type

Plate$\_$number $--->$ Year

Plate$\_$number $--->$ Colour

Serial$\_$number $-.->$ Type

Serial$\_$number $--->$ Year

tatyes into $3.$

Serial$\_$number $--->$ Colour

Licence$\_$number $>$ person$\_$ID$\_$number

Licence$\_$number $--->$ issue$\_$date

Licence$\_$number $--.>$ expiry$\_$date

Licence$\_$number $--->$ issue$\_$office

Transform these relations into $3NF.$ Please use only the attributes described in the text, a

not add any new attributes.