Please read carefully the marking schema when doing your tasks. The following are the assessment tasks: 1) Implement four related tables and insert suitable test data. Also, create a view, based on...

Please read carefully the marking schema when doing your tasks. The following are the assessment tasks: 1) Implement four related tables and insert suitable test data. Also, create a view, based on your sub-system table(s). [20 marks] 2) Implement 3 suitable SQL statements (Apex Reports). To test your system, you are asked to produce a set of SQL statements (queries) which will be specified in plain English (business statement) and implemented. Your queries should be implemented as an APEX report, in the Application Builder. Your SQL statements will need to demonstrate appropriate complexity in order to achieve a high mark. You will be penalised when using Query Builder to complete the tasks. [30 marks] 3) Implement two triggers as procedural constraints to use within the Apex application. [20 marks] 4) Build appropriate APEX Forms/Pages to manage the data (insert/update/delete) of your sub-system. At least one page has to be master/detail. Consider including a home page, calendar, Reports, Charts etc.