A database SOFASELECT was setup to show the prices of suites, Sofas, chairs on online furtniture warehouse. Part of database is shown below

$\backslash$table$[[$Description$,\backslash$table$[[$Brochure$],[$Number$]],\backslash$table$[[$Number$],[$of Seats$]],\backslash$table$[[$Number$],[$of Pieces$]],$Material,Colour,Price in S$],[$Sola$,$SF$17,2,1,$Leather,Red,$950],[$Sola$,$SF$19,3,1,$Vinyl,Black,$1\mathrm{.}000],[$Suite$,$SU$10,4,3,$Velvet,Green,$1,500],[$Suite$,$SU$23,5,3,$Loather,Brown,$950],[$Recliner chair,RC$01,1,1,$Leather,Crearn,$600],[$Chair$,$CH$16,1,1,$Vinyl,Red,$250],[$Recliner sola,RS$23,4,1,$Leather,Cream,$1\mathrm{.}200],[$Chair$,$CH$10,1,1,$Volvet,Red,$175]]$

$($a$)$ How many fields are in each record?

$q,$

$[1]$

$($b$)$ State which field you would choose for the primary key.

$q,$

Give a reason for choosing this field.

$$

$($c$)$ State the data type you would choose for each of the following fields.

Number C $$

Price in $S3$