$2\mathrm{.}1$ Describe the functions of each table in your database.

$(6$ marks$)$

$2\mathrm{.}2$ Create relationships between the tables in MS Access and produce a screenshot of the relationship diagram.

$(4$ marks$)$

Please note: The relationship must be created in MS Access and should display referential integrity between the tables.

$2\mathrm{.}3$ Query the entire customers' table$($show all attributes$)$ in MS Access of the store's database, wi the customers' last names in descending order, and add a screenshot of the result.

$(4$ mark

$2\mathrm{.}4$ Query the full product table $($show all attributes$)$ in MS Access of the store's database in descenc order of product name and add a screenshot of the result.

$2\mathrm{.}5$ Create a report of the customers in the database, sort the report in ascending order of first $n$ and add a screenshot of the report.

$6$

$2\mathrm{.}6$ Identify and explain the relationships between the tblMajor and tbIStudent, tbIStudent and tblAdvisor.