CHAPTER 5 ITM
0.0(0)
Studied by 0 people0.0(0)
View linked note
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/34
There's no tags or description
Looks like no tags are added yet.
Study Analytics
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No study sessions yet.
35 Terms
1
New cards
ACID properties
Atomicity, consistency, isolation, durability; ensure reliable transaction processing and data integrity in databases.
2
New cards
Attribute
A characteristic of an entity.
3
New cards
Concurrency control
A method for managing simultaneous access to the same record by multiple users or applications.
4
New cards
Data
Raw facts such as employee numbers or total hours worked in a week.
5
New cards
Data cleansing
The process of detecting and correcting or deleting incomplete, incorrect, or irrelevant records in a database.
6
New cards
Data Definition Language (DDL)
Instructions and commands used to define and describe data and relationships in a database.
7
New cards
Data dictionary
A detailed description of the data stored in a database.
8
New cards
Data governance
Defines roles, responsibilities, and processes for ensuring data trustworthiness and management.
9
New cards
Data item
The specific value of an attribute.
10
New cards
Data lifecycle management (DLM)
A policy-based approach to managing data flow from acquisition to deletion.
11
New cards
Data management
Processes for obtaining, certifying, storing, securing, and processing data.
12
New cards
Data Manipulation Language (DML)
A language that allows users to access and modify data, make queries, and generate reports.
13
New cards
Data normalization
The process of organizing data to eliminate redundancy and ensure data dependencies.
14
New cards
Data steward
An individual responsible for the management of critical data elements.
15
New cards
Database
A well-designed, organized, and managed collection of data.
16
New cards
Database administrator (DBA)
An IS professional responsible for managing databases and user data needs.
17
New cards
Database approach to data management
An approach where multiple systems share a pool of related data.
18
New cards
Database-as-a-Service (DaaS)
A service model where databases are hosted by a provider and accessed over the Internet.
19
New cards
Database management system (DBMS)
Programs used to access and manage a database and provide user interfaces.
20
New cards
Domain
The range of allowable values for a data attribute.
21
New cards
Enterprise data model
A model identifying the data entities and attributes of interest to an organization.
22
New cards
Entity
A person, place, or thing for which data is collected and maintained.
23
New cards
Entity-relationship (ER) diagram
A graphical data model showing the organization and relationships between data.
24
New cards
File
A collection of similar entities.
25
New cards
Foreign key
An attribute in one table that refers to the primary key in another table.
26
New cards
Information
Organized data that has additional value beyond individual facts.
27
New cards
Joining
Combining tables through common attributes to form a new table.
28
New cards
Knowledge
Awareness and understanding of information for specific tasks or decisions.
29
New cards
Primary key
An attribute or set that uniquely identifies a record.
30
New cards
Projecting
Manipulating data to eliminate columns in a table.
31
New cards
Record
A collection of attributes about a specific entity.
32
New cards
Relational database model
An organization of data into two-dimensional tables called relations.
33
New cards
Schema
A description defining the structure of the database, including tables and attributes.
34
New cards
Selecting
Manipulating data to eliminate rows based on criteria.
35
New cards
SQL
A programming language for accessing and manipulating relational database data.
Flashcards (35)