​​ Assessment 4_COMR2002BIS.docx Page 1 of 7 ASSESSMENT BRIEF Subject Code and Title COMR2002 BUSINESS INFORMATION SYSTEMS Assessment Practical Skills – Database Application Assignment Individual/Group Individual Length Add the required length for the assignment, presentation, discussion post, etc. Learning Outcomes 1. Recognise the range of cultural, security, privacy and ethical issues confronting individuals and organisations as consequence of using Information Systems. 2. Apply practical skills in the major functions of spreadsheet and database tools. 3. Communicate with IT professionals, stakeholders and user groups of information systems. Submission By 11:55pm AEST/AEDT Sunday of Week 12 Weighting 40 % Total Marks 40 marks Context: The aim of this assessment is to assess the student's ability to solve business problems using database design tool and software. Weekly online practical work will help students to complete this assessment. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report. Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively Instructions: Students are expected to develop a database for the case study provided. Students need to design and implement the database using LibreOffice Base. Students will be having several database- related practical activities during the semester and each practical activity contributes to the completion of your assignment. Additional information you need in Assessment 4_COMR2002BIS.docx Page 2 of 7 developing the database will be provided during the week you are expected to implement a practical activity. The following are the list of requirements: • Create an E-R Diagrams using Diagram Editor (10% mark) • Create database tables using LibreOffice Base (10% mark) • Create queries and forms using LibreOffice Base and SQL (10% mark) • Report on Impact using the technology (10%) Students need to submit the following: 1) A word document containing: a) Introduction - a summary of the case study b) Database • explanation of the database development activities • E-R Diagrams created • Database tables created using LibreOffice Base • SQL queries and the reports generated by those queries c) Impact of using technology (at least 500 Words) § Discuss how Business Information Systems are being used in the case study (go to their website: tourdownunder.com.au/ and analyse from there) § Discuss the cultural, security, ethical and privacy issues in using IS and IT 2) LibreOffice Base files used in creating the tables, queries and forms Assessment4_COMR2002BIS.docx Page 3 of 7 Assessment Attributes Fail (Unacceptable) (Functional) Pass (Proficient) Credit (Advanced) Distinction High Distinction (Exceptional) Documentation 5 The document is incomplete and do not meet the minimum requirements. Report was written very poorly with grammatical and spelling errors; less than required length; and incomplete and incorrect citations. 1 Document contains the minimum requirement. Grammatical and spelling errors are present; document presentation needs to be improved. 2 Document contain the required contents. Summary of the case study and database development activities are presented well. 3 Document exceeds minimum standards. Summary of the case study and database development activities are presented excellently. 4 Document exceeds minimum standards and exhibit high quality presentation. Summary shows sophisticated understanding of the case study and database development activities. Document is presented and formatted excellently. 5 E-R Diagram E-R Diagram created was incomplete and incorrect. More than 50% of the entities, attributes and relationships identified were incorrect. E-R diagram created was complete but some attributes and relationships were incorrect. Some entities identified should not be an entity. More than 50% of attributes were missing (or incorrect) and incorrect E-R diagram created was complete. All entities identified were correct. Less than 50% of attributes and relationships were missing or incorrect. E-R diagram created was complete. Identified entities were correct and complete. Attributes were correct and complete. Some relationships E-R Diagram created was complete and correct. All entities, attributes and relationships were correctly identified. Assessment4_COMR2002BIS.docx Page 4 of 7 10 1-2 relationships identified. 3-4 5-6 were missing (or incorrect) 7-8 9-10 Database Tables Database tables are incorrect and incomplete. E-R Diagram is not correctly translated to database tables. Majority of the tables, attributes are missing. Not all entities were translated into tables. Database table is complete. All entities are translated into tables. Some attributes of the E-R Diagram are not in the table and types of attributes are incorrect. Relationships are not translated to tables (primary keys and foreign key are incorrect) Some data in the table were entered. Database table is complete All entities are translated into tables. Attributes are all present and relationships among tables are established (primary keys and foreign keys are mostly correct) All data in the table were entered. Most of the attributes have correct types. Database table is complete and correct. All entities are correctly and completely translated into tables. Attributes and types of attributes were correctly identified. All data in the table were entered. Most table relationships are correct (primary keys and foreign keys and their relationship have been mostly correctly Database table is complete and correct. All entities are correctly and completely translated into tables. Attributes and types of attributes were correctly identified. All data in the table were entered. All table relationships were correct (primary and foreign keys and their relationships were all correctly identified) Assessment4_COMR2002BIS.docx Page 5 of 7 5 1 2 3 established). 4 5 SQL Reports 10 SQL queries and generated reports were mostly incorrect. Forms were not created 1-2 More than 50% of the SQL queries and reports were correct. Forms were created but not fully functioning. 3-4 More than 75% of the SQL queries and reports generated were correct. All elements of the forms were created and have been linked to the tables. 5-6 All SQL queries and reports generated were correct. All elements of the forms were created and all have been linked to the tables. Most of the data can be added and correctly saved in the tables. Forms were designed appropriately. 7-8 All SQL queries and reports generated were correct. All elements of the forms were correctly created, have been linked to the tables, and can correctly save data entered. Forms have very good design. 9-10 Critical reasoning and presentation of emerging technologies and the arguments used in The Business Information Systems (BIS) identified are not appropriate. Makes assertions about the use of BIS and its impact that are not justified. BIS identified is appropriate but reasons were not fully justified. BIS identified is appropriate and arguments were presented to justify the use of the technology BIS identified is highly appropriate for the organisation and arguments Emerging technology identified is highly appropriate for the organisation. The technology is Assessment4_COMR2002BIS.docx Page 6 of 7 defending issues in culture, ethics, security and privacy 10 1-2 Some issues were justified by arguments and not merely assertions. 3-4 in the organisation. Takes into account the complexities of the issues of using BIS. Other viewpoints were acknowledged. Justifies any conclusions reach with arguments and not merely assertions 5-6 presented to justify the appropriateness of the technology to the organisation is expertly presented. Accurately takes into account the complexities of the use of BIS in the organisation. Justifies any conclusions reached with welldeveloped arguments and substantiated by research. 7-8 innovative and arguments presented to justify the appropriateness of the technology to the organisation is expertly presented. Accurately takes into account the complexities of the issues of introduction this new technology to the organisation. Limitations of the proposed technology were also acknowledged. Justifies any conclusions with welldeveloped arguments and well-articulated viewpoint on the issues of using the proposed technology and substantiated by research. 9-10 Assessment4_COMR2002BIS.docx Page 7 of 7