Comp712 Database Systems Assessment Answer

Question:

Select a coherent part of the final model (Assignment 1) that features at least 4-6 tables as your sub-system.

1.Build an application that will include a home page and at least one master/detail in order to manage the data (insert/update/delete). Higher marks will be awarded for forms which effectively utilise a good range of APEX functionality, e.g. validations, LOVs, MAPs, dynamic actions.                                                                                              

2.Implement four apex reports based on intermediate and advanced level of SQL, two of your own advanced reporting choices (see Sample Reporting Application in AB).  

3.Implement a dashboard and four charts to provide management with appropriate information (see Sample Charts Application in AB).                                       

Report

Critically evaluate the implications of the theoretical foundations of the current relational database management systems by evaluating SQL vs NoSQL database approaches.  Include three recommendations and concerns regarding appropriate existing and/or emerging technologies/processes that may influence the case study organisation in the future. Furthermore, identify three journals that are referencing the emerging data analytic ideas and how could they be useful for your case study organization.

You will be expected to research appropriate and recent literature, analyse this and show evidence of a synthesis of views within your report. Clear references to the database case study you have investigated are expected. Marks will be awarded for critical evaluation, discussion, analysis and synthesis of views.

Deliverables

You must use the Assessment Template part 2(found on VLE) for this submission, found on the VLE, by the deadline. Submit a zip file. Submitted file should include screen shots with clear evidence of your student id, all task's code working successfully and where appropriate show evidence of code being tested. Consider appropriate commenting and annotation for your screenshots. Code for tables, data and SQL statements should be included.