HS2011 | System analysis and design

 HS2011 | System analysis and design 

Case Scenario ABC University currently employs a paper-based manual process for managing academic misconduct cases. The process is detailed below: • Learning facilitators are responsible for identifying and reporting academic misconduct cases to the subject coordinators. When reporting an academic misconduct case, the learning facilitator has to identify the breach type, which can be one or more of the following: O Plagiarism o Collusion o Cheating in exams o Contract Cheating o Other forms of cheating An academic misconduct case may involve one or more students. The learning facilitator also needs to record and report the trimester in which the alleged academic misconduct occurred to the subject coordinator including the campus location, the student name and student ID, as well as whether the student in question is studying a postgraduate or undergraduate degree, the subject code and name in which the alleged academic misconduct occurred, the type of assessment, the assessment number, the assessment weighting, and the name of the subject coordinator and of the learning facilitator. Once the subject coordinator receives an academic misconduct report, they will decide whether to dismiss the case or to further investigate it. If the case is dismissed at this stage, no further action is required. If the subject coordinator decides to further investigate the case, they will request a meeting with the student in question. During the meeting, the subject coordinator will record the date and the time of the meeting as well as the meeting minutes. After the meeting, the subject coordinator will make a decision and assign an outcome to the academic misconduct case. The outcome can be one of the following: o No breach O Minor breach o Significant breach A penalty will also be imposed on each student involved in the academic misconduct depending on the outcome of the case. If there is no breach, no penalty will be imposed. For a minor breach, one or a combination of the following penalties will be imposed if it is the first time the student has been involved in academic misconduct: o Mandatory education in academic integrity o Downgrade the mark for the assessment o Zero marks for the assessment For a minor breach, one or a combination of the following penalties will be imposed if this is the student's second or subsequent offence: o Mandatory education in academic integrity o Downgrade the mark for the assessment o Zero marks for the assessment o Fail grade for the subject For a significant breach, one or a combination of the following penalties will be imposed if this is the student's first offence: o Mandatory education in academic integrity • . MIS201_Assessment 1_ Case Scenario Page 1 of 2 LAUREATE INTERNATIONAL UNIVERSITIES o Downgrade the mark for the assessment o Zero marks for the assessment o Fail grade for the subject For a significant breach, one or a combination of the following penalty will be imposed if this is the student's second or subsequent offence: o Fail grade for the subject o Academic probation of up to 2 years Suspension for one or more study periods o Exclusion from the course o Exclusion from the University Three designated Academic Integrity Officers have been appointed to process the paperwork related to academic misconduct cases. They use a collection of Microsoft Excel spreadsheets stored on a network drive to record all academic misconduct cases. Once a person opens the spreadsheets to edit, others can only open the spreadsheets under the "read-only" mode. As a standing agenda item, the Academic Board receives detailed reports on academic integrity cases in every meeting. The Board meets every three months. The reports include, but are not limited to, the following statistics about academic misconduct cases: • Number of academic misconduct cases since the last Academic Board meeting, the top ten subjects with most number of academic conduct cases reported, • the average number of students involved in an academic misconduct case, the most commonly reported breach type, • the number of academic misconduct cases that have been identified as a significant breach", the number of investigation meetings held since the last Academic Board meeting, and the number of students who were found guilty of academic misconduct more than once.
 
SOLUTION
 
DATABASE NORMALISATION
 
Data redundancy - insertion anomalies, updation anomalies and deletion anomalies

Database normalisation - removes redundancy

3 normal forms - 1NF, 2NF and 3NF.

Functional dependency graph - analysing the table

Criteria for 1NF:  no multivalued attributes
Criteria for 2NF: no partial dependency
Criteria for 3NF: no transitive dependency 
 
 
 
 

 

THE 2-NF NORMALISED TABLE

 
 
 

THE 3-NF NORMALISED TABLE

  
 
 
THE ENTITY-RELATIONSHIP DIAGRAM (Task - 5)
  
 
 
CONCLUSION


Final 3NF normalised table
The functional dependency graph - identify and remove redundancies
Normalisation to 1NF - by adding and splitting attributes
Normalisation to 2NF - by adding attributes
Normalisation to 3NF - decomposition of the table.
ERD - modular, no redundant data

Share:

No comments:

Post a Comment