Answer the following questions based on the database you created in Question $1.$ Submit a PDF with your answers.

$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, with the customers' last names in descending order, and add a screenshot of the result. $(4$ marks$)$

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

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

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