Task $1,$ page name: task$1.$php$,$ chapter: $16,$ marks: $20$

Refer to the database design below:

$($a$)$ Explain briefly what each table represents $($i$.$e$.$ the entity it represents$).$ List all the primary and foreign keys for each table. $(10$ marks$)$

$($b$)$ Create a diagram for a database of music albums created by music artists. Each artist may have one or more albums, and each album may have one or more tracks. Keep track of this data, artist name, album name, album release date, track name and track time. $($Taken from the $3$rd edition of the prescribed book$)(10$ marks$)$

Note: No HTML form is allowed to obtain input from the user for this task.