database

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
full-widthPodcast
1
Card Sorting

1/42

encourage image

There's no tags or description

Looks like no tags are added yet.

43 Terms

1
New cards

Traditional file system vs. DBMS

A file system stores data in separate application files, while a DBMS centralizes data for shared access and management.

2
New cards

Four levels of the data hierarchy

Byte → Field → Record → Table

3
New cards

Field

A collection of related bytes representing a single attribute, such as a student's name.

4
New cards

Record

A collection of related fields that describes one entity.

5
New cards

Table

A collection of records about a particular type of entity.

6
New cards

Primary key

A field (or combination of fields) that uniquely identifies a record in a table.

7
New cards

Foreign key

A field that links one table to another by referencing a primary key.

8
New cards

Importance of primary and foreign keys

They establish relationships between tables and maintain data integrity.

9
New cards

Structured process

A process that follows predefined, standardized procedures.

10
New cards

Dynamic process

A flexible process that adapts to changing circumstances and requirements.

11
New cards

Workgroup information system

An information system that supports a single department or small group.

12
New cards

Enterprise information system

A system that supports an entire organization.

13
New cards

Inter-enterprise information system

A system that connects multiple organizations.

14
New cards

Information silo

A situation where data is isolated within departments and not shared effectively across the organization.

15
New cards

Problems caused by information silos

They create duplicated data, inefficiencies, poor communication, and inconsistent information.

16
New cards

Business Process Re-engineering (BPR)

The fundamental redesign of business processes to improve performance and efficiency.

17
New cards

CRM

Customer Relationship Management.

18
New cards

Purpose of a CRM system

To manage customer interactions, sales, marketing, and service activities.

19
New cards

ERP

Enterprise Resource Planning.

20
New cards

Purpose of an ERP system

To integrate major business functions into a single system.

21
New cards

Enterprise Application Integration (EAI)

Technology that connects separate applications so they can share data and processes.

22
New cards

Two broad categories of security threats

Unintentional employee actions and intentional insider threats.

23
New cards

Example of an unintentional threat

Accidentally clicking a malicious link or sending sensitive information to the wrong person.

24
New cards

Insider threat

A threat caused by someone within the organization who intentionally compromises security.

25
New cards

Five categories of safeguards

Hardware, software, data, procedures, and people.

26
New cards

Authentication

Verifying a user's identity.

27
New cards

Authorization

Determining what resources an authenticated user can access.

28
New cards

Accounting (AAA security framework)

Tracking and logging user activities within a system.

29
New cards

Strong password

A password that is long, unique, and difficult to guess.

30
New cards

Employee training as a people safeguard

Because informed users are less likely to make security mistakes.

31
New cards

Five phases of the SDLC

Systems Definition, Requirements Analysis, Design, Implementation, and Maintenance.

32
New cards

Systems Definition phase

Organizations identify the need for a new or changed information system.

33
New cards

Requirements Analysis phase

Business and technical requirements are gathered and documented.

34
New cards

Design phase

The system's components, structure, and specifications are planned.

35
New cards

Implementation phase

The system is built, tested, and deployed.

36
New cards

Maintenance phase

The system is monitored, updated, and improved after deployment.

37
New cards

Four conversion approaches during implementation

Pilot, Phased, Parallel, and Plunge (Direct Cutover).

38
New cards

Pilot conversion

Implementing the system in one area before rolling it out organization-wide.

39
New cards

Parallel conversion

Running old and new systems simultaneously for a period of time.

40
New cards

Plunge (Direct Cutover) conversion

Immediately replacing the old system with the new system.

41
New cards

Agile development

An iterative development methodology that emphasizes flexibility and frequent feedback.

42
New cards

Scrum

An Agile framework that organizes work into short development cycles called sprints.

43
New cards

Agile vs. Waterfall

Agile is iterative and adaptive, while Waterfall follows a sequential, phase-by-phase approach.