The justification for relational database schema for task $2$ should be shown as follows:

Rule $1$:

Show your workout as shown in relational database schema lecture$/$tutorial $($obviously$,$ you have a different scenario, but that$$s how you show it$)$

Hints: e$.$g$.$ what is it$?$ what are you looking for this rule? Find and highlight them as below & show the relation...

image.png

A general hint:

You can use windows Snipping tool to insert your diagrams in Word document $($seek help from your tutor if still unsure$).$

image.png

Rule $2$:

Show your workout as shown in relational database schema lecture$/$tutorial $($obviously$,$ you have a different scenario, but that$$s how you show it$)$

Rule $3$:

Show your workout as shown in relational database schema lecture$/$tutorial $($obviously$,$ you have a different scenario, but that$$s how you show it$)$

Rule $4$:

Show your workout as shown in relational database schema lecture$/$tutorial $($obviously$,$ you have a different scenario, but that$$s how you show it$)$

Rule $5$:

Show your workout as shown in relational database schema lecture$/$tutorial $($obviously$,$ you have a different scenario, but that$$s how you show it$)$

Then, put all relations as one schema and create your final schema, showing relationships, FKs$,$ PKs and other constraints:

Note: For Task $2,$ the relational schema must be discussed and entered using the horizontal notation taught in lectures and tutorials. You should annotate the basic relational schema $($as discuss in lecture$)$ to ensure all the ORM constraints and subtype definitions are captured.

Other notations$/$forms will not be accepted.

image$-4.$png