Question: 1. Design an 00 version of the suppliers-and-parts database.
2. Write a suitable set of OPAL data definition statements for your version of the suppliers-and-parts database.
3. Sketch the details of the necessary "database populating" methods for your version of the suppliers-and-parts database.
4. Write OPAL code for the following queries on your 00 version of the suppliers-and-parts database:
(a) Get all London suppliers.
(b) Get all red parts.