Part II: Relational DB design by ER and EER to relational Mapping $(5$ Points$)$

Q$3.$ After mapping the following ERD to a relational model, answer the next $3$ questions. $(2$ Pnts$)$

The relational model contains relations.

The relational model contains composite primary keys.

The relational model contains foreign keys.

The relational model contains non$-$null foreign keys.