a) A report of all those who were bor or Wednesday or Saturday. 5 marks c) Generate a report to get the averafe or mark for the miaSem Test score for each class 5 marks d) The lowest and the highest Midaci marks for the Xavier table 5 marks 3. Use the database schems below to answer questions (2.a) to (2.e). Hint: Use only select, project, Cartesion froduct, and natural join. Do not wse theta-join, set operations, renaming or assigntent. Suppliera(aID, sName, address) Parts(pID, pName, colour) Catalog(sID, pID, price) Catalog[sID] Supplient[ [ ID] Catalog[pID] Parts[pID] a. If sID is a key for the Suppliers table, is it a likely key for the Catalog relation? b. Using Relational Algebra, find the names of all blue parts. marks5marks2 c. Using Relational Algebra, d. Find the names of all suppliers who supply a part that is red or green. e. Find the sIDs of all suppliers whoprovide a part that is red and green at the sam 4. Provide brief answers to the following a. Explain the term 'Relational Algebra' as used in Relational Database Management Systems. 8 marks. b. As a newly employed Database Administrator your new manager says he/she hears the tert 'query' being used in Database Management Systems which he/she fails to understand. explain the meaning of the term 'query' as used in databases to him/her 2 marks c. What is meant by 'Trigger' in a Database System. 5 marks d. Explain the term constraint. Give three (3) examples of a constraint. 5 marks