Question $2$

$[30$ marks$]$ 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 tbIMajor and tbIStudent, tbIStudent and tbIAdvisor.

$(6$ marks$)$

$3$

HCLT$108-1-$Jan$-$June$2024-$FA$3-$IM$-$V$\mathrm{.}3-06022024$