Noted that the first word in each entity denotes the entity name in Figure $1.$ Convert

the ER into the $3^{rd}$ normalization form $(3$ NF $)$ relations. Indicate the primary and

foreign keys for each relation.

$(10$ Marks$)$

Figure $1$ The partial ER diagram