Capture a screenshot demonstrating the successful installation of the software, including login$,$ and showcase the execution of SELECT and DESCRIBE commands on various tables of View Ridge database. Formulate assumptions regarding the data types employed for each column in these tables $(7$ marks$).$

Marking Criteria:

$-$ Successful Login $(1$ mark$)$ using mysql $-$u root $-$p

$-$ Software installation $(1$ mark$)$ use the version command from the lab guide to show successful installation. A screenshot should be provided.

$-$ Select $(2\mathrm{.}5$ marks$)$ provide with screenshot for each entity $(0\mathrm{.}5$ marks$)$ The screenshot should display the query, results grid,and action output. Refer to example below.

$-$ Describe $(2\mathrm{.}5$ marks$)$ screenshot $($each entity $0\mathrm{.}25$ marks$)$ and assumptions $($each entity $0\mathrm{.}25$ marks$)$ should be provided.

$2.$ Elaborate on the View Ridge database in the context of its constituent entities, primary keys, foreign keys, and the relationships among them, all as covered during the lab $(3$ marks$)$

Marking Criteria:

$-$ Primary key $(1$ mark$)$

$-$ Foreign Key $(1$ mark$)$

$-$ Relationships $(1$ mark$)$

Note: Make sure to include all $5$ entities and consider the relation from $1$ to M$,1$ to $1,$ M:N$.$