Task 1A. Explain why a relational database would be a suitable information system for the organisation such as the one provided in the case study and provide (3) three reasons to support your...

Task 1A. Explain why a relational database would be a suitable information system for the organisation such as the one provided in the case study and provide (3) three reasons to support your recommendation (600 words).
Task 1B. Explain (3) three distinct advantages concerning what a database management system provides to any organisation. Note: Make these relevant to the organisation in the case study (600 words).
Requirements Definition Read the case study carefully, and decide the important (i.e. key) features of the system. Construct a basic prototype that will display the following:
Task 1C. Design a set of Initial screens that can be shown to the client – this allows for the input of information to satisfy the user requirements, you should produce at a minimum (5) five forms. Submit a softcopy that has a set of screen shots that illustrate the screen designs with appropriate narrative for each screen. (200 Words)
Task 1D. Design a set of typical reports that would be appropriate for the proposed company database – this requires you to assume the role of the user/manager and list three (3) likely reports he/she might need to do their job. It must show the report, its main features, and then populate it with some likely test data. Submit a softcopy that has a set of screen shots that illustrate these proposed screen designs. (200 Words)
Note:  A suitable package to do the above task (A to D) would be Microsoft Word or any similar product.
Page 5 of 11
Task 2 (LO 2.1, LO 2.2)

Extra notes:

Task 2B: A key part of the system is the Entity Relationship Diagram – you must you the correct formalism as shown in the ilearn notes and the textbook. Care must be taken to identify the candidate entities from the case study.

A second draft is typically done, and careful re-examination of the case study to ensure you have all the potential entities.

Task 2C: A complete and thorough analysis using Normalisation is required and evidence that every table satisfies 1, 2, and 3 Normal forms.
Development Use a database development strategy to decide the main elements of the database – this will include nominating the: Fields (also the primary keys and foreign keys) Tables Links and Cardinalities
Task 2A. Produce a Data Dictionary – which contains the following information: table, field type, field size and field description. (400 words).