Reference no: EM132503158

ICT100 Foundations of Information Systems Assignment - King's Own Institute, Australia

Case Study Assignment - Part 1- Access and Part 2- Report (800 words).

Assessment topic - Database Design with Access and Report About Modern Information Systems

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.

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 Location Text

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:

1. Introduction: Discuss the competitive advantage/challenges associated with the use of modern information systems identified

2. Body: Discuss the case study identified.

3. Conclusion: Summarise the important parts of the report and should include recommendations.

4. 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.

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.