Task Instructions 1. Please read the attached MIS201_Assessment 1_Case Scenario. 2. Based on the case scenario provided, please complete the following tasks: Task 1 (10 marks) Assignment 1, MIS201 Page 2 of 5 Design and create as many Microsoft Excelspreadsheets as you deem necessary to manage and store data storage need as detailed in the case scenario. Note one Microsoft Excel file may contain many spreadsheets. Task 2 (50 marks) A collection of spreadsheets created to manage the data are shared on network drive may experience many problems. Identify and discuss the problems with examples related to the case scenario with respect to data redundancy, data independence, data consistency, data integrity, data security and the scale of data sharing. Also, discuss whether and if so how a database system could solve most of the problems that a collection ofspreadsheets on a file system would encounter. Please note that your response to this task should be 1200 words +/-10%. You do not need to use a Report format for your answer. Use headings (e.g. Data redundancy, Data independence, Advantages of a database system) to structure your answer. Task 3 (25 marks) The University Management decides to develop an information system (the System) to address the cases study scenario provided with this assignment. The System shall facilitate the management of data requirements of the scenario provided in the case study, and shall allow easy generation of reports to the stakeholders of various levels. Draw an Entity Relationship Diagram (ERD) to model the data requirements of the system provided in the case study. Task 4 (15 marks) Based on the ERD you completed in the previoustask, design database tablesfor the System. Provide the following information for each database table. Please note that ERD must be drawn using LucidChart or an equivalent professional diagramming software package.