Task Summary  

Based on the case scenario provided, (1) developing a collection of spreadsheets on a file system to manage a business process, (2) identifying and discussing the problems of using a collection of spreadsheets on a file system, (3) discussing the benefits of using a database system and (4) drawing an ERD and developing a database table design for the information system proposed in the case.

Task 1 

Design and create as many Microsoft Excel spreadsheets as you deem necessary to manage and store academic misconduct  cases as detailed in the case scenario. Note one Microsoft  Excel file may contain many spreadsheets.

Task 2

A collection of spreadsheets created by the Academic Integrity Officers shared on a 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.

Task 3 

The University Management decides to  develop an information  system  (the ‘System’)  to process the large number of academic misconduct cases, and you have been asked to design the database for the System. The System shall facilitate the  management of academic misconduct cases and shall generate reports for the Academic Board or other academic governance committees. Draw an Entity Relationship Diagram (ERD) to model the data that would be used in the System given the case scenario above. 

Task 4

Based on the ERD you completed in the previous task, design database tables for 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.

Case-Scenario