SpreadSheet & Database Analysis

Topic: SpreadSheet & Database Analysis Order Description Individual Coursework Assignment Coursework Brief 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