Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITE 115 > Module 13 > Flashcards

Module 13 Flashcards

1
Q

Field

A

A column containing a specific property for each record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Record

A

A row of data in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Relational database

A

A database that consists of a collection of tables that can be joined through a common field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Database management system (DBMS)

A

A software program that lets you create databases and then manipulate data in them

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Relational database management system (RDBMS)

A

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Input mask

A

A field property that provides a visual guide for users as they enter data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Primary key

A

The field in a database that contains unique information for each record, also called a unique identifier.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Foreign key

A

A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

One-to-many relationship

A

A relationship between two database tables that connects each record in one table with one or more records in the other table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

One-to-one relationship

A

A relationship between two database tables that connects each record in one table with exactly one record in the other table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Many-to-many relationship

A

A relationship between two database tables that connects one or more records in one table with one or more records in the other table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Form

A

Designed for easily entering data into a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Report

A

Outputs data in a visually appealing format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Confidentiality, Integrity, and Availability (CIA) triad

A

A classic security model that guides efforts to protect data from unauthorized access, protect data from unauthorized changes, and ensure data is accessible by authorized users when needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

NoSQL databases (nonrelational databases)

A

A highly scalable and highly available database type that is designed to store unstructured data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Key-value databases

A

A nonrelational database consisting of any number of key-value pairs for each record.

17
Q

High availability

A

A characteristic of a computing resource that identifies the percentage of time the resource functions reliably.

18
Q

Business intelligence (BI)

A

Software tools designed to extract useful information from big data.

19
Q

Data warehouse

A

A type of database that serves as a central repository from other data sources and databases for the purpose of data analysis.

20
Q

Data lake

A

A collection of both structured and unstructured data of diverse data formats.

21
Q

Dashboards

A

A data visualization tool such as Power View.

ITE 115 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions