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
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: Summarize 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.