Order Description
Individual Coursework Assignment
You must design a database from a list of requirements, producing an entity-relationship diagram, a determinancy diagram and a relational schema, with a detailed account of how the requirements have been translated into the diagrams. These should be submitted in a Word file.
Design a database system to maintain data associated with criminal court cases in the UK. The text below has been produced from a requirements elicitation exercise.
• Each judge has a list of outstanding cases over which he will preside. Only one judge presides per case.
• For each case one prosecuting counsel is appointed to represent the Public Prosecutions Service. Cases are scheduled at one Crown Court for an estimated duration from a given start date.
• A case can try more than one offence. Each offence is for one crime in law. Each offence can have one or more defendants.
• Each defendant can have one or more defending barristers. If an offence has multiple defendants, each defendant can have one or more defence counsel defending.
• Defendants may have more than one outstanding case against them.
(i) Produce an entity-relationship diagram which represents the domain of criminal court cases.
(ii) Assign a number of surrogate identifiers to the entities in the domain and produce a determinancy diagram to document the dependencies between data-items.
(iii) Accommodate both the entity-relationship diagram and the determinancy diagram produced to a relational schema expressed in the bracketing notation.
(iv) Describe the diagrams developed in details
Key Marking criteria will include:
• Accuracy of the calculations
• Appropriateness of the methodology
• Clarity and conciseness of the descriptions of the methodology and the conclusions
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]