This assignment is worth 50% of the overall module mark.
A list of requirements of a database is provided. Your solution should be the creation of an entity- relationship diagram using Chen’s notation, and a table relationship diagram from Access, based on the module contents on databases. You should submit a Word processed report following a typical report structure, to show the diagrams and your own understandings of the relevant topics, by giving a detailed account of how the requirements have been translated into the diagrams, the reasonsyou have chosen those particular methods, the meanings of the diagram components used, and the conclusions you have drawn. You are NOT required to discuss any general theory of database design and modelling, and should focus on the specific problem given below. The Access database file is NOT required for submission, but snapshots of your Access database should be included in the Word report to demonstrate the steps in creating the table relationship in Access, as well as those zooming different portions of the entity-relationship diagram, to facilitate the explanation and discussion.
You must design a database system to maintain data associated with a company. The fifteen sentences below have been produced from a requirements elicitation exercise.
Individual Coursework Assignment 2 must be submitted by 3PM ON 3RD MAY via Turnitin.
The word limit for individual coursework assignment 2 (excluding references, tables, contents page, footnotes, charts, graphs, figures) is 1,500 words. The word count must be stated in the assignment coversheet.