Map the following EER diagram into a relational schema and specify all primary keys and foreign keys. While hand$-$drawn responses are permissible, the use of computer$-$aided design tools, including draw.io and Visio, is strongly encouraged to accurately illustrate your mapping results.