CRN-35640 - Database Systems and Approaches - Report Writing - IT Assignment Help

Assignment Task

LEARNING OUTCOMES ADDRESSED BY THIS ASSIGNMENT:
Learning outcome 1 Evaluate the implications of the theoretical foundations of database management.
Learning outcome 2 Demonstrate practical skills in designing and implementing organisational requirements using an industrial strength database management system to develop an effective internet enabled database application.

Assessment Details

You will be undertaking a database development project for a client (in this case your tutor) based on given requirements. Using feedback from this stage you will go on to design, implement and test your system using appropriate database techniques and technologies. You will also be expected to evaluate your development processes relating to the System Development Life Cycle, as well as considering emerging technologies that could be used to improve the organisation’s data management and decision-making processes.

Database Design and Implementation
Produce an Extended Entity Relationship Model (EERM) using top-down approach for the given case study organisation. List Validation Questions (6-10) used to validate your EER Diagram. Use the notation taught in class.

Normalise the attached form (see Appendix B) used in the current system, using bottom up approach. Consider the implications of this normalisation for other SDLC activities, discuss briefly.

Produce a Composite Model (based on outputs from bottom up and top down approaches). Consider the implications of this process and discuss briefly.

Derive Composite model to produce a final list of relations/tables and for each relation/table produce a full list of attributes, defining attribute(s) that are Primary Key(s) and any derived Foreign Key(s). Consider the implications of this process and discuss briefly.

Consider theory of Physical Design and suggest potential changes of the composite model in an anticipation of performance problems for the implementation. [10 Marks]
Implement tables in Oracle Apex. Carefully consider constraints for each table. Insert suitable test data. As a guideline you should populate table with at least 5-15 rows of data, using SQL Scripts environment.

LEARNING OUTCOMES ADDRESSED BY THIS ASSIGNMENT:
Learning outcome 1 Evaluate the implications of the theoretical foundations of database management.
Learning outcome 2 Demonstrate practical skills in designing and implementing organisational requirements using an industrial strength database management system to develop an effective internet enabled database application.
Learning outcome 3 Critically assess database approaches and the role of database management within contemporary organisations; and recommend emerging technologies and strategies for contemporary organisation.

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

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.

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).

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

This CRN-35640 - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.