Database Test 1 - Chapters 1, 2, 3 Flashcards

1
Q

A document for gathering data input

A

Form

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

This key is the primary key repeated in another table to create a link between the tables.

A

Foreign Key

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

A document including the scope, objectives, and timeline for a given project.

A

Statement of Work

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

A key based on one or more “natural” attributes of an entity

A

Natural key

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

This key uniquely identifies each row in the table.

A

Primary Key

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

The official steps and rules for completing some process

A

Procedure

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

Refers to the accuracy and the correctness of the data in the database.

A

Data Integrity

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

Refers to storing the same data in more than one place in the database.

A

Redundancy

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

These files have some sort of character separating columns of data

A

Delimited Files

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

A type of database that uses “relations,” tables, to store and relate tables.

A

Relational Database

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

Something that the database is concerned with, about which data can be stored.

A

Entity

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

The process of organizing data into tables or entities and then determining the relations
among them.

A

Relational Design

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

The process of organizing data into tables or entities and then determining the relations
among them.

A

SQL

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

Limits on what the database will do.

A

Constraints

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

Files where the length in characters of each column is the same.

A

Fixed Width Files

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

A short statement of one or more paragraphs that says in clear, but general, terms what the project will do.

A

Statement of Scope

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

A multiple-choice question

A

Closed-ended question

18
Q

The purpose or subject of a database

19
Q

A set of tools for analyzing business trends

A

Business intelligence

20
Q

Things that define aspects of entities.

21
Q

A database optimized for storing and processing real-time transactions

A

Transaction Database

22
Q

A question that has no set answer

A

Open-ended question

23
Q

Combining data in a variety of formats for trends and patterns

A

Data mining

24
Q

A document for displaying summarized data

25
Q

An alternate way of doing a process

26
Q

Marked up Unicode text that follows a set of a few strict rules

27
Q

A database optimized for queries that summarize transaction data

A

Management information system

28
Q

Something the database needs to do to be successful

A

Requirement

29
Q

A collection of all the various types of business information including databases and documents

A

Data Warehouse

30
Q

Anyone who has a stake in the process

A

Stakeholder

31
Q

Observing workers handling data on the job

A

Work shadowing

32
Q

The permissions a user has to use or view database objects and data

A

User access

33
Q

A program that offers a service to requesting programs

34
Q

An artificial key, often just an incremented number

A

Surrogate key

35
Q

A person or program that makes some use of the database

36
Q

A program that requests a service

37
Q

A program in SQL that is triggered by a database event

38
Q

A key that consists of more than one attribute

A

Composite key

39
Q

A rule about how data are acquired, stored, or processed

A

Business rule

40
Q

The general problem area with which a database is concerned

A

Problem domain

41
Q

Something a database must do to meet a business need

A

Requirement