1/42
Looks like no tags are added yet.
Traditional file system vs. DBMS
A file system stores data in separate application files, while a DBMS centralizes data for shared access and management.
Four levels of the data hierarchy
Byte → Field → Record → Table
Field
A collection of related bytes representing a single attribute, such as a student's name.
Record
A collection of related fields that describes one entity.
Table
A collection of records about a particular type of entity.
Primary key
A field (or combination of fields) that uniquely identifies a record in a table.
Foreign key
A field that links one table to another by referencing a primary key.
Importance of primary and foreign keys
They establish relationships between tables and maintain data integrity.
Structured process
A process that follows predefined, standardized procedures.
Dynamic process
A flexible process that adapts to changing circumstances and requirements.
Workgroup information system
An information system that supports a single department or small group.
Enterprise information system
A system that supports an entire organization.
Inter-enterprise information system
A system that connects multiple organizations.
Information silo
A situation where data is isolated within departments and not shared effectively across the organization.
Problems caused by information silos
They create duplicated data, inefficiencies, poor communication, and inconsistent information.
Business Process Re-engineering (BPR)
The fundamental redesign of business processes to improve performance and efficiency.
CRM
Customer Relationship Management.
Purpose of a CRM system
To manage customer interactions, sales, marketing, and service activities.
ERP
Enterprise Resource Planning.
Purpose of an ERP system
To integrate major business functions into a single system.
Enterprise Application Integration (EAI)
Technology that connects separate applications so they can share data and processes.
Two broad categories of security threats
Unintentional employee actions and intentional insider threats.
Example of an unintentional threat
Accidentally clicking a malicious link or sending sensitive information to the wrong person.
Insider threat
A threat caused by someone within the organization who intentionally compromises security.
Five categories of safeguards
Hardware, software, data, procedures, and people.
Authentication
Verifying a user's identity.
Authorization
Determining what resources an authenticated user can access.
Accounting (AAA security framework)
Tracking and logging user activities within a system.
Strong password
A password that is long, unique, and difficult to guess.
Employee training as a people safeguard
Because informed users are less likely to make security mistakes.
Five phases of the SDLC
Systems Definition, Requirements Analysis, Design, Implementation, and Maintenance.
Systems Definition phase
Organizations identify the need for a new or changed information system.
Requirements Analysis phase
Business and technical requirements are gathered and documented.
Design phase
The system's components, structure, and specifications are planned.
Implementation phase
The system is built, tested, and deployed.
Maintenance phase
The system is monitored, updated, and improved after deployment.
Four conversion approaches during implementation
Pilot, Phased, Parallel, and Plunge (Direct Cutover).
Pilot conversion
Implementing the system in one area before rolling it out organization-wide.
Parallel conversion
Running old and new systems simultaneously for a period of time.
Plunge (Direct Cutover) conversion
Immediately replacing the old system with the new system.
Agile development
An iterative development methodology that emphasizes flexibility and frequent feedback.
Scrum
An Agile framework that organizes work into short development cycles called sprints.
Agile vs. Waterfall
Agile is iterative and adaptive, while Waterfall follows a sequential, phase-by-phase approach.