ICT100 Foundations of Information Systems Assessment 2 Case Study Assignment: Individual case study assessment composed of two submissions in Moodle: Part 1- Access and Part 2- Report (800 words)....

part1 Database design with different functionalities using MS Access and part 2 Report about modern information systems 800 words


ICT100 Foundations of Information Systems Assessment 2 Case Study Assignment: Individual case study assessment composed of two submissions in Moodle: Part 1- Access and Part 2- Report (800 words). Assessment topic: Database design with Access and Report about modern information systems. Submission: On the submission link in Moodle, there are two tabs: Part 1 and Part 2. Submit the Access Database (.accdb) in Part 1 and the Report (Word format) in Part 2 on or before Sunday 04 May 2020 by 11:59pm (Week 7). Do not compress the files as a zip folder. Purpose: 1. Students will use Access DB and its different functionalities. 2. Students will write a 800 words report based on youtube videos on moodle every week about different areas of business where ICT megatrends have created an impact or caused radical disruption for example, 3D printing, Cloud Computing, Vulnerability of IT systems etc Students may identify any other topic of their choice and find a case study pertaining to the topic identified for example bank heist or a hacking attack on banks, government agencies or financial institutions. This assessment contributes to learning outcomes b and d. Value: 15% Assessment Details: Create the following tables Customer Column Datatype Primary Key Customer Number Number Yes Last Name Text First Name Text Address Text City Text State Text Post Code Text Phone Text Guide Guide Num Number PK Same fields as above Hire Date Date/Time Trip TripID Number PK Trip Name Text Start LocationText State Text Distance Number Max Group Size Text Type Text Season Text Reservation Reservation ID Number PK Trip ID Number Trip Date Date Num of Persons Text Trip Price Currency Other Fees Currency Customer Num Number TripGuides Trip ID Number Guide Num Number Create above tables, enter data, and create relationships between these tables using common columns Report: Write a report that must include the following sections: · Introduction: Discuss the competitive advantage/challenges associated with the use of modern information systems identified · Body: Discuss the case study identified. · Conclusion: Summarise the important parts of the report and should include recommendations. · Reference List: At least 4 to 5 references from academic journals and articles. In addition, proper in-text referencing is to be followed. Follow APA Referencing style. Marking Criteria: The assessment will be marked based on the following criteria: 1. Creation of tables and relationships in MS Access 2. Well-written report and identification of digital innovation in ICT 3. Provides supported argument with at least 4-5 references (from academic journals and articles) 4. Demonstrates knowledge of the subject matter 5. Draws a conclusion based on argument ICT100: Assessment 2 Utpal Nanavati 1