Question $1$

$[20$ Marks$]$

Background:

Your friend Nina's baby clothing business is growing, but sales are still recorded in a book. You have decided to showcase acquired skills using Microsoft $($MS$)$ Access databases and develop a database for the clothing shop.

You have identified several entities from your research on the operations of the clothing shop and decided to include a customer, product and sales table in your MS Access database. Your tables should include the below attributes per table:

Customer table $[$first name, last name, address, cell number and city$]$

Product table $[$product name, price, colour, size and category$]$

Sales table $[$This table is derived from the Customer and Product table$]$

Required:

Create a database in MS Access for the sales management system and upload a copy of the database on ColCampus.

Rubric:

$\backslash$table$[[$Criteria$,$Requirements,Marks$],[1,\backslash$table$[[$The student created appropriate$],[$database tables with proper columns.$]],6$ marks$],[2,$At least five attributes in each table.,$3$ marks$],[3,\backslash$table$[[$Provide at least ten customers and at$],[$least five items to the database.$]],4$ marks$],[4,\backslash$table$[[$At least four customers with one item per$],[$customer have been added to the Sales$],[$Table$.]],3$ marks$],[5,\backslash$table$[[$The correct naming convention is used,$],[$and consistency is followed.$]],4$ marks$],[,$Total,$20$ marks$]]$

$2$

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

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$)$