We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: email@example.com after completing this order process.
No Plagiarism Guarantee - 100% Custom Written
2) Individual Coursework Assignment 2
This assignment is worth 50% of the overall module mark.
You must design a database from a list of requirements based on the contents of lectures, 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 a company. The text below has been produced from a requirements elicitation exercise.
(a) Produce an entity-relationship diagram which represents the domain of criminal court cases, together with the detailed explanations and justifications of each entity, relationship, cardinality, and type of relationships in the diagrams. Note that some attributes should be created and assigned to the entities in the domain.
(b) Produce a determinancy diagram to document the dependencies between data-items, together with clear and reasonable explanations and justifications.
(c) Accommodate both the entity-relationship diagram and the determinancy diagram produced to a relational schema expressed in the bracketing notation.