CP0054E : Information Systems and Databases - Oracle SQL Features - Engineering Assignment Help

Assignment Task : 

Learning Outcomes assessed:

LO1 Explain and apply aspects of database management to a database scenario; 
LO2 Identify and explain different types of database technologies and information systems;  

Task details
The Pinkton Hospital Research Director has asked you to write a brief report to explain what kind of database security measures the research department should be considering in order to ensure that data security is not compromised, giving specific examples of Oracle SQL features. 
In addition, now that the department’s research records and activities are fully accessible using your new database system, the Director also wants to know of two other information systems or other types of databases that could be usefully employed within the organisation, either now or in the future, to help researchers and to support projected expansion. You need to give a brief overview of the applications and then explain your rationale for suggesting each, outlining what advantges (and any disadvantages) they might bring to the organisation. You may make any reasonable assumptions about growth projections.
You are required to write a report (1000-1500 words) which addresses the above. This will require research into the two areas and application of your findings to the Pinkton scenario. Your report should use a range of reliable sources which should be cited and referenced in Harvard style. If you are unsure of how to reference your sources 

The research department now wishes to set up database information system which it hopes will address the above issues and allow for the following, as a minimum: 

1. A record of basic contact information relating to each sick twin and his/her co-twin. This will enable speedy and flexible retrieval of twins based on given criteria. (eg age, sex, contact details, place of birth, nationality, blood type, illness, age and nationality of mother at date of birth, age and nationality of father at date of birth); The database also needs to keep a record of all previous addresses for the twin, in order to monitor twin migration/movements.

2. Records of all illness and date of diagnosis for each twin along with additional information (eg whether hospitalised – if so, which hospital and for how long etc), so that there is an easily accessible health history for each twin to help researchers to locate suitable twins for their research projects and to learn the background health history from the records. 

3. A record of which twins were involved in which research projects, and the result of any standard tests carried out on twins as part of that research project. A project will involve any number of tests administered to individual twin members; a twin may re-take a test in a new project. The system should be able to provide a complete ‘testing record’ for each patient, showing when they were tested, which test they took, for which project, what the results were, etc. The system should also be able to generate various reports based on the tests.

4. The twin record should show the number of research studies that he/she has participated in so that researchers can avoid aggravating twins by approaching them repeatedly to ask if they would mind taking part in a new project. There should also be some indication of whether a twin wishes to participate in future projects – sometimes twins will ask not to be contacted at all, or they might say they don’t want to take part now, but are happy to be contacted in 5 years time.  

This Engineering Assignment has been solved by our Engineering  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.