ATABASE produce a database backend and provide the functionality requirements by using PL/SQL procedures and functions

Group Practical task 50%
Submission Date a 26 November 2012
You are required to form groups of four and after reviewing the case study, implement an agreed solution in Oracle. Your group will be expected to identify the management needs of the organisation and present how they are solved and dealt with by your database design and implementation.
Assessment will take the form of a live demonstration of your database implementation that should highlight functional aspects, integrity considerations and useful functionality to aid the systemsa users. In particular you should present how issues raised in the case study are addressed and solved by your implementation.
For the presentation your group is required to produce documentation detailing how you would design the overall structure of your system. Documentation to include Entity Relationship Diagrams, design features of your database application and listings of all PL/SQL code developed. The group will be required to do a live demonstration of all PL/SQL features.
You will need to implement business logic and integrity constraints around these queries through the use of procedural code PL/SQL. The following techniques should all be attempted: PL/SQL cursors, stored procedures, stored functions and triggers.
ASSESSMENT FEEDBACK
Feedback on your assessment will be available in 20 business days from the presentation date. Please refer to the module pages on UEL Plus for assessment specific details.
4
Marking Criteria
Assignment Requirements
Mark
a)
Entity Relationship Diagram:
All entities labelled correctly, primary and foreign keys, relationships, optionality and cardinality.
Assumptions to clarify business/expert logic and future proposals must be resolved with the client first.
30%
b)
Appropriate use of PL/SQL:
SQL answers/output to the end useras questions. Stored procedures, functions, triggers etc, will be required in order to complete the business requirements. Comments should appear in the PL/SQL procedures, functions, triggers or anonymous block and will be required.
Snap shots of every PL/SQLs and results must be included.
40%
c)
Software Documentation:
Documentation must include, a list of attributes for each entity, showing their primary and foreign keys, and whether the attribute is null or not null. Snap shots of each table must be included in the assignment as well as all syntax for creating and inserting values.
Documentation must be included in the report stating what every procedure, function or anonymous block is intended to do, and possibly some justification if necessary as shown during lectures, tutorials and practicals.
10%
d)
Teamwork and presentation:
During the presentation it will be determined, by questioning, that the whole team has been involved and has a good understanding of the design. This is based on the clarity of the technical information communicated and the ability of the whole team to fully understand what they have presented. All members of the team must be present and be able to participate in the presentation.
TEAM WORK:

Referencing Requirements:
THIS IS A DATABASE ASSIGNMENT WHICH I HAVE NOT BEEN ABLE TO SEND THE FULL REQUIREMENTS BECAUSE OF LACK OF SPACE. I WILL SEND IT SEPARATE TO YOUR E-MAIL
CAN YOU PLEASE USE UML FOR THE DIAGRAMS.