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