What is the difference between data and information?
Data are raw, unprocessed facts; information is data processed into a meaningful, useful form
2
New cards
What is the primary role of an MIS, and how should it relate to strategy?
It gives managers timely, accurate information for decision making and control, and it should align with and support the organization's strategic goals
3
New cards
What are the components of an information system, and what makes information high quality?
Components: hardware, software, data, procedures, people; Quality information is accurate, timely, relevant, complete
4
New cards
What are the three levels of management decision
making?
5
New cards
What do TPS, MIS, DSS, and ESS each do?
TPS: records daily transactions (e.g., point of sale); MIS: routine summary reports for middle managers; DSS: analyzes data for non
6
New cards
What do a dashboard, forecasting, an exception report, and drill
down do?
7
New cards
What are big data and data mining?
Big data: data sets too large or complex for traditional tools, needing advanced tools to analyze (volume, velocity, variety); Data mining: finding hidden patterns in large data sets, such as which customers buy which products
8
New cards
What are the SDLC phases, and what happens in each?
Planning (scope, feasibility); Requirements analysis (what the system must do for users and the business); Design (how it will do it); Development (coding); Testing (does it work); Implementation (install, convert, train users); Maintenance (fix bugs and release updates after go
9
New cards
What is the difference between systems analysis and systems design?
Analysis: what the system must do (requirements); Design: how it will do it (specifications for input, output, processing, and controls); features should match the requirements gathered from users, not just be the most advanced
10
New cards
What are the four system conversion strategies?
Direct cutover: switch all at once (riskiest); Parallel: run old and new together (safest, most costly); Pilot: one location or branch first; Phased: in stages by module or unit
11
New cards
What are the three types of feasibility?
Financial (economic): do benefits justify costs; Technical: can our technology and skills build it; Organizational: will people adopt and use it
12
New cards
What are unit, system, and acceptance testing?
Unit: each program alone; System: the whole system working together; Acceptance: users confirm it meets business needs and is ready for use
13
New cards
What is the difference between verification and validation?
Verification: the system matches its specifications ("building the product right"); Validation: the system meets users' real needs ("building the right product")
14
New cards
What are functional requirements, nonfunctional requirements, and scope creep?
Functional: what the system must do; Nonfunctional: qualities like speed, security, and reliability; Scope creep: requirements growing beyond the original plan
15
New cards
When is each requirements
gathering method best?
16
New cards
What is prototyping, and what are its main advantage and drawback?
A quick, simplified working model shown to users; Advantage: faster delivery with early testing and feedback; Drawback: documentation and full testing may be rushed
17
New cards
Who does what in system development?
Systems/business analyst: links business and IT and ensures the system meets business needs; Developer: writes the code; End user: uses the system and supplies requirements and feedback; Stakeholder: anyone affected by or interested in the project (includes end users)
18
New cards
What do a DFD, an ERD, and a class diagram each show?
DFD: how data flows through processes, data stores, and external entities; ERD: entities and their relationships (database design); Class diagram: classes with their attributes, methods, and relationships (object
19
New cards
How do Waterfall and Agile differ?
Waterfall: linear, each phase finished before the next, best when requirements are stable (Laudon calls it the traditional systems life cycle); Agile: short iterative cycles with frequent feedback, best when requirements change; Agile's main benefit is flexible adaptation to change
20
New cards
What are the four values of the Agile Manifesto?
Individuals and interactions over processes and tools; working software over comprehensive documentation; customer collaboration over contract negotiation; responding to change over following a plan (the right
21
New cards
A new system launches but employees struggle to use it. What was likely insufficient?
Training (part of implementation)
22
New cards
What are a class, an object, an attribute, and a method?
Class: blueprint, usually a business entity (Customer); Object: one specific instance (customer42); Attribute: the entity's data or state (email); Method: the entity's actions or behavior (placeOrder)
23
New cards
What are the four principles of object
oriented programming?
24
New cards
What are a superclass, a subclass, and method overriding?
Superclass: the parent class; Subclass: the child class that inherits from it (an "is
25
New cards
What are libraries and frameworks, and which go with which languages?
Library: reusable code your program calls, which speeds development and improves consistency; Framework: provides the structure and calls your code; Languages: Java, C#, Python, C++, JavaScript; Frameworks: Spring (Java), .NET (C#), Django (Python)
26
New cards
What are the benefits and drawbacks of OOP?
Benefits: modularity, code reuse, information hiding, easier maintenance; Drawbacks: more design complexity and overhead for simple programs
27
New cards
What are a relation, a tuple, and an attribute, and what is the main advantage of a relational database?
Relation: a table; Tuple: a row (record); Attribute: a column (field); Main advantage: tables link through keys for efficient, flexible queries
28
New cards
What is the difference between a primary key and a foreign key?
Primary key: unique identifier for each row that prevents duplicates (e.g., CustomerID); Foreign key: a field that links to another table's primary key to connect related tables
29
New cards
What are a DBMS, an index, and a trigger?
DBMS: software that manages data and gives programs access to it; Index: speeds up searches; Trigger: an action that runs automatically when data changes
30
New cards
What do the SQL clauses WHERE, ORDER BY, GROUP BY, and HAVING do?
WHERE: filters rows; ORDER BY: sorts results; GROUP BY: groups rows for totals or counts; HAVING: filters groups after GROUP BY
31
New cards
How would you write "show active customers sorted by last name" in SQL?
SELECT * FROM Customers WHERE Status = 'Active' ORDER BY LastName;
32
New cards
What is data redundancy, and how is it handled?
The same data stored in multiple places, causing inconsistency and wasted storage; normalization removes duplicate or unnecessary fields; intentional redundancy (backups, replication) is good for availability
33
New cards
What are data integrity, data security, and data recovery?
Integrity: data is accurate and consistent (two addresses for one customer = poor integrity); Security: protecting data from unauthorized access (encryption, access control); Recovery: restoring lost data (e.g., nightly backups)
34
New cards
What is a NoSQL database, and what are its four types?
A non
35
New cards
What are structured, semi
structured, and unstructured data?
36
New cards
What is the difference between OLTP and OLAP?
OLTP: runs day
37
New cards
What are the pros and cons of local, cloud, and hybrid storage?
Local: full control but high upfront cost and upkeep; Cloud: scalable and pay
38
New cards
What are the three Scrum accountabilities?
(Scrum is an Agile framework of short cycles and frequent check
What are Kanban boards, user stories, and Gantt charts used for?
Kanban board: shows work moving through stages (To Do, Doing, Done); User story: "As a [user], I want [goal], so that [benefit]"; Gantt chart: shows the project schedule as bars
41
New cards
What is a runaway project, what must project management control, and what most helps a system succeed?
Runaway project: far exceeds its schedule and budget or fails to perform as specified; Variables to control: scope, time, cost, quality, risk; Success factors (Laudon): user involvement and management support
42
New cards
What are the five project management process groups?
Initiating, Planning, Executing, Monitoring and Controlling, Closing
43
New cards
What are IT infrastructure, virtualization, and cloud migration?
IT infrastructure: the shared technology foundation (hardware, software, networks, data storage, IT services); Virtualization: running multiple virtual servers on one physical machine (via a hypervisor); Cloud migration: moving systems from on
44
New cards
What are PAN, LAN, MAN, and WAN?
PAN: devices around one person (Bluetooth); LAN: one building or campus; MAN: a city; WAN: the largest, spanning countries (the Internet is the biggest WAN)
45
New cards
What do a hub, a switch, a router, and a firewall do?
Hub: sends data to every connected device (Layer 1); Switch: sends data only to the right device on a LAN (Layer 2); Router: directs packets between networks to their destination (Layer 3); Firewall: filters incoming and outgoing traffic based on security rules
46
New cards
What do HTTP/HTTPS, FTP, SMTP, and DNS do?
HTTP/HTTPS: deliver web pages (HTTPS is encrypted); FTP: transfers files; SMTP: sends email between servers; DNS: translates domain names into IP addresses
47
New cards
What are a VPN and bandwidth?
VPN (virtual private network): a secure, encrypted connection to a private network over the Internet; Bandwidth: how much data a connection can carry at once (high consumption at peak times causes lag)
48
New cards
What are the tradeoffs of star, bus, ring, and mesh topologies?
Star: central device, easy to manage, but that device is a single point of failure; Bus: one shared backbone cable, cheapest, but a cable break takes down every node; Ring: nodes in a loop, one break can disrupt it; Mesh: every node linked, most reliable, most expensive
49
New cards
What are the OSI and TCP/IP model layers?
OSI, 1 to 7: Physical, Data Link, Network, Transport, Session, Presentation, Application (mnemonic: Please Do Not Throw Sausage Pizza Away); TCP/IP, bottom to top: Link, Internet, Transport, Application
50
New cards
What is the CIA triad, and what do encryption, access control, and audit trails do?
CIA: Confidentiality, Integrity, Availability; Encryption: scrambles data to prevent unauthorized access; Access control: limits who can use what (least privilege); Audit trail: logs every change to data and who made it
51
New cards
How do authentication, MFA, SSO, and authorization differ?
Authentication: proving who you are; MFA (multifactor authentication): two or more different factors, such as a password plus a fingerprint; SSO (single sign
52
New cards
What are the common security threats?
Insider threat: an employee misusing access (e.g., stealing confidential data); Malware: harmful software such as viruses and ransomware; Phishing: fake messages that trick users into giving up credentials; DDoS: flooding a system with traffic so it can't respond
53
New cards
What are good physical security and password practices?
Physical security: locked server rooms with keycard access; Strong passwords: a mix of letters, numbers, and symbols, changed periodically and never reused across systems
54
New cards
What are common computer ethics violations?
Software piracy: copying proprietary software without permission; Plagiarism: presenting others' work as your own; Unauthorized access: using systems or data without permission; Privacy violation: misusing personal data
55
New cards
What are automation, AI, and machine learning?
Automation: tasks done with minimal human input (faster, more consistent, but jobs change); AI: systems that perform tasks needing human
56
New cards
What are the core characteristics of blockchain?
A decentralized ledger; blocks linked by cryptographic hashes so tampering is detectable; transactions validated by consensus; smart contracts run automatically; not the same as cryptocurrency
57
New cards
What is the Internet of Things (IoT), and what is its main business benefit?
Physical devices with sensors connected to the Internet that collect and share data (e.g., machine sensors); main benefit: real
58
New cards
What are augmented reality, virtual reality, and edge computing?
AR: digital information overlaid on the real world (e.g., smart glasses showing picking instructions); VR: a fully simulated environment (e.g., training simulations); Edge computing: processing data near its source to reduce delays, instead of in one central location
59
New cards
What are the characteristics, deployment models, and business benefits of cloud computing?
Characteristics: on
60
New cards
What are SaaS, PaaS, and IaaS?
SaaS: a finished app (Canva, Gmail); PaaS: a platform to build and run your own apps (Heroku); IaaS: raw servers, storage, and networks (AWS EC2); AWS is a provider that offers all three