Assignment $1$

Consider a database $($suppliers$-$parts$-$projects$)$ with the following schema: & $\backslash$end$\{$tabular$\}$ & & & CITY & & & & & & $\backslash$

$\backslash$hline & s$1$ & Smith & & $20$ & London & & & s$1$ & P$1$ & J$1$ & $200\backslash$

$\backslash$hline & s$2$ & Jones & & $10$ & Paris & & & s$1$ & P$1$ & J$4$ & $700\backslash$

$\backslash$hline & s$3$ & Blake & & $30$ & Paris & & & S$2$ & P$3$ & J$1$ & $400\backslash$

$\backslash$hline & S$4$ & clark & & $20$ & London & & & S$2$ & P$3$ & J$2$ & $200\backslash$

$\backslash$hline & s$5$ & Adams & & $30$ & Athens & & & S$2$ & P$3$ & J$3$ & $200\backslash$

$\backslash$hline & $--$ & & & & & & & S$2$ & P$3$ & J$4$ & $500\backslash$

$\backslash$hline P & P# & PNAME & COL & OR & WEIGHT & CITY & & S$2$ & P$3$ &

$\backslash$table$[[J5$