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.
Assignment 1, MIS201 Page 1 of 5 ASSESSMENT 1 BRIEF Subject Code and Title MIS201 Database Fundamentals Assessment Case study Individual/Group Individual Length Task 1, 3 & 4: Models and Tables Task 2: 600 words (+/- 10%) Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data Submission For 12-week Duration: Due by 11:55pm AEST Sunday end of Module 2 (Week 4) For 6-week Duration: Due by 11:55pm AEST Sunday end of Module 2 (Week 2) Weighting 25% Total Marks 100 marks 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. Context This assessment aims to develop your understanding of the challenges involved in collecting, storing and managing data in an organisational context. It assesses your ability to effectively identify the benefits of a database system as well as your ability to build data models to simplify complex subject matters. 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 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 (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 of spreadsheets on a file system would encounter. Please note that your response to this task should be 600 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 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. TABLE_NAME COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA For example, Student COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA STUDID PRIMARY KEY AUTO- INCREMENT 1 STUDENTCOURSE FOREIGN KEY STRING BBIS DATEAPPLIED DATE 14/6/2021 Referencing It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing in the Academic Skills webpage. https://library.torrens.edu.au/academicskills/apa/tool Assignment 1, MIS201 Page 3 of 5 Submission Instructions Please submit ONE MSWord document (.doc or .docx) compiling the tasks 2,3 and 4 and 1 excel file (task1) via the Assessment 1 section found in the main navigation menu of the subject’s Blackboard site. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades. Academic Integrity When submitting their assessment task, students will be asked to declare the academic integrity of their assessment by completing and signing an assignment cover sheet. You can find the assignment cover sheet here All students are responsible for ensuring that all work submitted is their own and is appropriately referenced and academically written according to the Academic Writing Guide. Students also need to have read and be aware of Torrens University Australia Academic Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are available at https://www.torrens.edu.au/policies-and-forms. Students also must keep a copy of all submitted material and any assessment drafts. Special Consideration To apply for special consideration for a modification to an assessment or exam due to unexpected or extenuating circumstances, please consult the Assessment Policy for Higher Education Coursework and ELICOS and, if applicable to your circumstance, submit a completed Application for Assessment Special Consideration Form to your Learning Facilitator. https://www.torrens.edu.au/policies-and-forms https://www.torrens.edu.au/policies-and-forms Assignment 1, MIS201 Page 4 of 5 Assessment Rubric Marking Criteria Fail (Yet to achieve minimum standard) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75-84% High Distinction (Exceptional) 85-100% Task 1 (10%) ➢ Design and creation of Microsoft Excel spreadsheets to manage and store data as detailed in the case scenario. Task 2 (50%) ➢ Identify and discuss the problems with examples related to the case scenario with respect to data redundancy, independence, consistency, integrity, security and the scale of data sharing ➢ 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. Task 3 (25%) ➢ Draw an Entity Relationship Diagram (ERD) to model the data that would be used in the System given the case scenario. Task 4 (15%) ➢ Based on the ERD, design database tables for the System. Assignement 1, MIS201 Page 5 of 5 Fail (Unacceptable) 0-49% A Fail grade will be awarded if a student is unable to demonstrate satisfactory academic performance in the subject or has failed to complete required assessment points in accordance with the subject’s required assessment points. Pass (Functional) 50-64% Pass is awarded for work showing a satisfactory achievement of all learning outcomes and an adequate understanding of theory and application of skills. A consistent academic referencing system is used and