Brainscape's Knowledge GenomeTM

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


See full index

CIS101 > Chapter 14: Databases and Database Management Systems > Flashcards

Chapter 14: Databases and Database Management Systems Flashcards

1
Q

attributes

A

A characteristic of an entity. (p555)

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

centralized database system

A

A database system in which all of the data used by the system is located on a single computer. (p565)

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

client-server database systems

A

A database system where the database is located on a server and accessed by client devices. (p564)

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

cloud databases

A

A database, typically hosted on a cloud database provider’s servers, that is accessible to users via the Web. (p576)

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

column

A

A single category of data to be stored in a database, such as a person’s last name or phone number; also called a field. (p549)

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

Data definition

A

The process of describing the properties of data that is to be included in a database table. (p556)

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

data dictionary

A

The repository of all data definitions in a database. (p557)

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

Data integrity

A

The accuracy of data. (p558)

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

Data privacy

A

Protecting the privacy of the data located in a database. (p561)

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

Data security

A

Protecting the data located in a database against destruction and misuse. (p560)

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

Data validation

A

The process of ensuring that data entered into a database is valid (matches the data definition). (p558)

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

database

A

A collection of related data that is stored in a manner enabling information to be retrieved as needed; in a relational database, a collection of related tables. (p549)

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

database management system (DBMS)

A

A type of software program used to create, maintain, and access databases. (p549)

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

Direct organization

A

A method of arranging data on a storage medium that uses hashing to specify the exact storage location. (p563)

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

distributed database system

A

A database system in which the data used by the system is located on multiple computers that are connected via a network. (p565)

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

entity

A

Something (such as a person, object, or event) that is important to a business or organization; typically becomes a database table in a database system for that business or organization. (p555)

17
Q

field

A

A single category of data to be stored in a database, such as a person’s last name or phone number; also called a column. (p549)

18
Q

form

A

A formatted way of viewing and editing a table in a database. (p569)

19
Q

hybrid XML/relational database

A

A type of database system that can store and retrieve both XML data and relational data. (p575)

20
Q

index

A

A small table containing a primary key and the location of the record belonging to that key; used to locate records in a database. (p562)

21
Q

indexed organization

A

A method for organizing data on a storage medium or in a database that uses an index to specify the exact storage location. (p562)

22
Q

in-memory databases (IMDBs)

A

A database that stores all data in memory instead of on a hard drive. (p566)

23
Q

metadata

A

Data about data, such as the data contained in a data dictionary. (p558)

24
Q

middleware

A

Software used to connect two otherwise separate applications, such as a Web server and a database management system. (p578)

25
Q

multidimensional database (MDDB)

A

A type of database designed to be used with data warehousing. (p576)

26
Q

multiuser database system

A

A database designed to be accessed by multiple users. (p564)

27
Q

normalization

A

The process of evaluating and correcting the structure of a database table to minimize data redundancy. (p568)

28
Q

object-oriented database management system (OODBMS)

A

A type of database system in which multiple types of data are stored as objects along with their related code. (p574)

29
Q

primary key

A

A specific field in a database table that uniquely identifies the records in that table. (p551)

30
Q

query

A

A request to see information from a database that matches specific criteria. (p571)

31
Q

record

A

A collection of related fields in a database; also called a row. (p549)

32
Q

relational database management system (RDBMS)

A

A type of database system in which data is stored in tables related by common fields; the most widely used database model today. (p567)

33
Q

report

A

A formatted way of looking at information retrieved from a database table or the results of a query. (p572)

34
Q

row

A

A collection of related fields in a database; also called a record. (p549)

35
Q

Single-user database systems

A

A database located on a single computer and designed to be accessed by a single user. (p564)

36
Q

structured query language (SQL)

A

A popular query language standard for information retrieval in relational databases. (p571)

37
Q

tables

A

In a relational database, a collection of related records. (p549)

CIS101 (17 decks)

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