MIS201 - Database Fundamentals - University Management Case Study - IT Assignment Help

Assignment Task

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.
Also, discuss whether — and if so how — a database system could solve most of the problems that a collection of spreadsheets on a file system would encounter. Please note that your response to. 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
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.

This MIS201 - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.