Problem domain: You are developing a database system for the Food Supplier. The Food Supplier has some data on the farms that supply the products, as well as some data on products themselves that is often retrieved by Restaurants. While Restaurants have exclusive contract with to Food Supplier and use only Food Suppliers products, they use a different information system than Food Supplier. During requirement engineering process, the test data was gathered, the requirements were defined and ER diagram was designed (note that this is not pure database ER diagram, it is missing some key information as this ER was acquired during requirements engineering, not design stage). Products Farms District Title (text) Founding year (year) Profile (miscalleneous, meat, dairy or fruits) Type (text) Title (text) Price per unit (in euros) How many units available at once Max revenue per purchase Fig. 1 ER diagram District Profile Valmieras Jelgavas Dobeles Title Highlanders Veggies and co Liepas Farm test data: Founding year 2011 2018 2019 meat vegetables fruits Products test data: Product title Price per unit Farm Title Type Availability Max. revenue per purchase 25 12 1,50 Fruits Liepas Liepas Liepas Fruits Fruits Granny apples "Little onion apples Antonovka 2,50 3 1,50 10 4 1 Additional requirements: 1. Following information is often retrieved by Restaurants as a whole, so it should be used easily by applications: a. Product type; b. Product title; c. Price per unit; d. Availability. 2. Additionally, an information on farm certificates must be stored: a. certificate number, b. certificate type, c. year until which the certificate is valid. Each farm can have up to 6 certificates. Certificate number CH1456 BIO90-17 Certificates test data (all of them for farm Liepas") Certificate type Authentic VegetableSorts BioFarm Validity 2025 2023 3. The profile of the farm must be automatically updated to miscellaneous if farm offers some other products that do not belong to its profile (e.g., if Liepas started to offer milk which belongs to profile "dairy"). 4. The following information must be obtained from the database: a. the farm title that produces a particular product; b. the list of certificates for a particular farm; c. there should be possibility to detect whether there are any certificates of a particular farm that will not be valid next year (validity