Database Engineering

Database Engineering

1 of 1 Coursework ID
199470 Contribution
100%
Lecturer
Dr.ChiyabaNjovu Date Set
21st September 2012 Deadline Date
16th December 2012 Return Date
16th January 2013
This coursework should take an average student who is up-to-date with tutorial work approximately 50 hours

 

Note: Your must submit your coursework with a bar-coded coursework header. Please surf to http://registry1.gre.ac.uk/default.asp using Internet Explorer (header sheet will print better from IE than Netscape) and select “Coursework receipt system” then “View/Print Header Sheets”. You will be asked to enter the Coursework Id given above and the registration number(s) of ALL the students submitting the coursework. Do not leave this field blank. Print the resulting header sheet and submit it with your coursework.

Coursework Regulations

1 Late course works will be accepted by Registry and marked according to the guidelines given in your Student Handbook for this year.

2 If you need an extension (even for one day), you must request one, using a coursework extension request form available from Web site at http://cms1.gre.ac.uk/stu_info/handbook/Forms/Forms.html. Do not ask the lecturers responsible for the course – they are not authorised to award an extension.

3 All course works must be submitted through the Campus Registry and a receipt obtained. Under no circumstances can they be accepted by School staff. Please check the Registry opening hours.

Remember to keep your coursework receipt.

Specification

This is an individual coursework.
There are TWO components to the coursework.
1. Your system will be assessed at a laboratory demonstration/viva where the database and any software that you produce will be viewed and you will be asked to answer questions.
2. You will need to produce a report and design documents as specified.
Scenario
The revived Timely Prosecution Services (TPS) has a number of prosecution judges. Each judge has a list of outstanding cases over which he will preside. Only one judge presides over a case. For each case, one prosecuting counsel is appointed to represent the TPS board. Cases are scheduled at one court for an estimated duration from a given start date. A case can try more than one crime. Each crime can have one or more defendants. Each defendant can have one or more defending barristers. If a crime has more than one defendant, each defendant can have one or more defence lawyers. Defendants may have more than one outstanding case against them. There is also a requirement that we need to maintain a history of cases a judge presided over and record the outcomes of all these cases.

Requirements

1. Using Chen’s or Crow’s Foot notation or any case tool, devise an Enhanced Entity Relationship (EER) model for the TPS database. All entity types, their attributes and relationships must be clearly shown. You will also be required to show all cardinality and participation constraints. [Note,marks will be deducted for inconsistent use of your chosen notation]. Any assumptions above the basic business rules or any temporal data semantics captured on your EERD must be clearly stated and justified.
2. Map the EER model devised in (1) into a set of relations in the relational data model. You may use object-relational features to support the enhanced features in your model. Clearly state any de-normalization, if any, in all your relations and clearly state the reasons for de-normalizing relations in your implemented solution. All temporal semantics must be clearly explained and justified.
3. Using appropriate SQL commands, create a set of database tables in Oracle. Your tables should also show all constraints applied at either column or table level. All table level constraints must be given unique names.
4. By querying the relevant data dictionary views, produce a listing of the TPS database metadata.
5. Create an appropriate user interface using Oracle Apex to allow users to input data into your tables easily. To allow for automatic computation of totals during data entry, you will need to attach some stored procedures to the relevant fields on your form.
6. Create sample reports to demonstrate overall system functionality. For example, you may want to show all pending cases before a given judge, or all cases that have had more than one adjournment, etc.
Note
You do not need to include an extensive selection of data; the emphasis is on demonstrating your technical and design skills rather than including a wide range of data.

You should:-
• Implement your design using the obiwan database.

Deliverables
1. Interim Submission (Optional)
You could submit your conceptual design of the database for feedback on 30th October, 2012. The idea is to get feedback on conceptual design and its subsequent logical database design mapping.

2. Implementation (Mandatory)
You will be required to demonstrate your system in the laboratory during your usual class time on Monday 16th December, 2012.
You will be assigned a time to present your work, should you miss the allotted time slot for any legitimate reason it is your responsibility to re-schedule a time with your tutor; you will not be pursued. If you do not attend or are not ready for the demonstration there will be no second chance.
Failure to demonstrate your work to a tutor will result in a failing grade for the coursework.
3. Report
• A report covering requirements 1 – 6 which should be submitted on 15th December, 2012.

Grading Criteria
To pass this coursework you must demonstrate:
• competence in conceptual database design of temporal database models
• competence in mapping your temporal conceptual data model to a logical database
• competence in database programming
• demonstrate an appreciation of the underlying design and implementation principles

Design Documents and Rationale 30%
Implementation 25%
Discussion 25%
Additional Features (documented and demonstrated) 20%

Your score will depend on how well you meet these criteria. A portion of the available marks will be given for above minimal specification features of your implementation.

To achieve a score of:
70% + You must display an excellent conceptual design. High technical skill in data applications design. Any additional features that show your creativity in database systems will be rewarded. A demonstration of an understanding of the underlying principles.
60% + You must display a competent conceptual design. Reasonable technical skill in data application development. Some additional features included and demonstration of an appreciation of the underlying principles.
40% + You must display a feasible conceptual design and demonstrate that you can develop a database system from a given scenario.

You will fail the coursework if you do not demonstrate your system to your tutor.
ORDER THIS ESSAY HERE NOW AND GET ADISCOUNT !!!

 

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.

 

[order_calculator]