Font size
WorksheetsInformation Systems Quiz
Total questions: 49
Worksheet time: 25mins
What is a system made of tools like computers (hardware), programs (software) and networks that work together to collect and manage information?
Database Management System
Information Technology (IT)
Information System
SRS
_______________ is the use of computers, storage, networking and other physical devices to create, process, store and exchange electronic data.
Information system (IS)
Information technology (IT)
Database management system
Network communications
The set of instructions or programs used to control hardware and process data is called:
hardware
software
IT
networking communication
The five essential components of an information system are:
hardware, software, database, networking communication, and people
programming, hacking, debugging, coding, and designing
hardware, storage, applications, networking communication, and customers
software, dbms, internet, tools and users
(a) means raw facts like numbers, letters, sounds, pictures.
(a) is the physical technology including all tangible devices.
Which system handles daily tasks like sales, payments and payroll?
Decision Support System (DSS)
Executive Support System (ESS)
Transaction Processing System (TPS)
Management Information System (MIS)
Example of Office Automation System (OAS):
Clash of Clans - for playing games
Spotify - for listening to music
Adobe Illustrator - for graphic design only
Google Docs - for typing and sharing documents
Correct sequence of IS functions:
Processing → Input → Storage→Output → Feedback
Input → Processing → Storage → Output → Feedback
Input → Output → Storage →Processing → Feedback
Feedback →Storage → Output → Input → Processing
Which IS function involves gathering raw data?
Processing
Output
Input
Feedback
Example of 'Output' function:
A report generated from processed data
Data entered into a system
Data being analyzed
A correction made to a process
Examples of databases (multiple):
Cloud computing
MongoDB
relational database management systems
NoSQL
MySQL
Examples of IT (multiple):
Kaspi.kz, eGov.kz
Operating systems like Windows and Linux
A database server
A Wi-Fi router
Salesforce (CRM)
Examples of IS (multiple):
Platonus (university platform)
Adobe Photoshop
Google Maps
Microsoft Word
Difference between IT and IS:
1 - IT, 2 - IS
1 - IS, 2 - IT
1 - technologies, 2 - systems
1 - IS, 2 - process
System for managing customer relationships:
Transaction Processing System (TPS)
Geographic Information System (GIS)
Customer Relationship Management System (CRM)
Executive Support System (ESS)
IS components in social media:
1 - software, 2 - hardware, 3 - data, 4 - people, 5 - processes
1 - software, 2 - hardware, 3 - processing data, 4 - people, 5 - managing data
1 - programs, 2 - IT, 3 - information, 4 - people, 5 - processes
1 - technologies, 2 - systems, 3 - information, 4 - people, 5 - processes
Processed, organized data that provides meaning:
(a)
Examples of Data (multiple):
Student grades: "85", "92", "78"
Weather report
Temperature readings: "72°F", "68°F"
Grade average
Correct IS workflow sequence:
1 - Input, 2 - Storage, 3 - Processing, 4 - Output, 5 - Control
1 - Data, 2 - Processing, 3 - Output, 4 - Storage, 5 - Feedback
1 - Input, 2 - Processing, 3 - Storage, 4 - Output, 5 - Feedback
1 - Gather input, 2 - Processing, 3 - Storage, 4 - Feedback, 5 - Output
Software for managing databases:
Software Development Life System
Database Management System (DBMS)
Relational Databases
Centralized Databases
An electronically stored collection of data:
(a)
Examples of RDBMS (multiple):
Microsoft SQL Server
Postgre SQL
MongoDB
Oracle
MySQL
Language for RDBMS operations:
(a)
Organizes data into tables with keys:
Hierarchical Database
Object-Oriented DBMS
NoSQL DBMS
Relational Database Management System (RDBMS)
Commands to interact with databases:
DBMS
Schema
Queries
Data
Database types matching:
1 - Relational, 2 - Object-Oriented, 3 - NoSQL
1 - Relational, 2 - Object-Oriented, 3 - Hierarchical
1 - Relational, 2 - Object-Oriented, 3 - Cloud
1 - Graph, 2 - Object-Oriented, 3 - NoSQL
Data stored in tables (rows/columns):
Graph databases
Relational databases
Hierarchical databases
NoSQL databases
A repository of data:
(a)
Data types shown:
1 - Structured, 2 - Semi-structured, 3 - Relational
1 - Unstructured, 2 - Hierarchical, 3 - Structured
1 - Unstructured, 2 - Semi-structured, 3 - Structured
1 - Non-organized, 2 - Semi-organized, 3 - Organized
Structured data examples (multiple):
Entity relationship diagrams
Photos and videos
Financial transactions
Customer demographic info
Text documents
DBMS examples (multiple):
MySQL
Microsoft Access
Apache Cassandra
MongoDB
PostgreSQL
Software to create/manage databases:
Spreadsheet
relational database
DBMS
Database technology
SQL
Data in RDBMS is stored in:
sql
database
table
data structure
Keyword to select all columns:
ALL
*
EVERY
AND
GET
SQL query for comments containing 'I love studying OIS':
SELECT * FROM students WHERE comment = 'I love studying OIS';
SELECT * FROM students WHERE comment LIKE 'I love studying OIS';
SELECT * FROM students WHERE comment LIKE '%I love studying OIS%';
SELECT * FROM students WHERE comment CONTAINS 'I love studying OIS';
Correct SQL to add new customer:
INSERT INTO customers ('CustomerID', 'CustomerName', 'ContactName') VALUES (92, 'Global Foods', 'Anna Ivanova');
INSERT customers Values (92, 'Global Foods', 'Anna Ivanova');
CREATE customers VALUES (92, 'Global Foods', 'Anna Ivanova');
INSERT INTO customers (CustomerID, CustomerName, ContactName) VALUES (92, 'Global Foods', 'Anna Ivanova');
Incorrect statement about keys:
Each table can have only one primary key
A table can contain multiple foreign keys or none
The rules for primary and foreign keys serve the same purpose
A foreign key links tables by referencing a primary key
Document describing software requirements:
SDLC
API
SRS
SRSP
Technical task report
Unique row identifier in a table:
(a)
Attack using malicious SQL queries:
Phishing
SQL DDos
SQL Hacking
SQL Injection
Rules for application communication:
API (access program interface)
Hypertext Transfer Protocol (HTTP)
API (application protocol interface)
API (application programming interface)
API using HTTP methods (GET/POST/PUT/DELETE):
REST (Representational State Transfer)
SOAP (Simple Object Access Protocol)
Web API
GraphQL
Description matches:
How to test code
How a database stores information
How to write full applications
How the API works
How the IS works
Main role of SRS:
Manages project budget
Guides everyone in the project
Stores user information
Helps design company logo
Functional vs non-functional requirements:
Functional are optional
Functional = what system does, non-functional = how it performs
Functional = UI, non-functional = databases
Functional = performance, non-functional = features
Functional requirements for banking (multiple):
Users should log in
Users check balance
System responds in <2 sec
Handles 100M users
Transaction notifications
Non-functional requirements for food app (multiple):
Users browse menu
Menu loads in <1 sec
Users track orders
Supports 50K concurrent orders
Intuitive interface
SRS users matching:
1 - Customer, 2 - Business Analysts, 3 - Software Engineers, 4 - Architect, 5 - QA/QC, 6 - PMs, 7 - Stakeholder
1 - Investor, 2 - Business Analysts, 3 - Developers, 4 - Architect, 5 - QA/QC, 6 - PMs, 7 - Client
