Brainscape's Knowledge GenomeTM

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


See full index

Business Data Management > Quiz 1 - Part 2 > Flashcards

Quiz 1 - Part 2 Flashcards

1
Q

Abstraction of a real-world object or event

A

Model

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

Simple representations of complex real-world data structures

A

Data models

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

represents data structures and their characteristics, relations, constraints, transformations, and other constructs with the purpose of supporting a specific problem domain

A

Data Models

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

Iterative and progressive process of creating a specific data model for a determined problem domain

A

Data modeling

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

An implementation-ready data model should contain a description of the data structure that will store…

A

the end-user data

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

An implementation-ready data model should contain a set of enforceable rules to guarantee…

A

the integrity of the data

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

An implementation-ready data model should contain a data manipulation methodology to support …

A

the real-world data transformations.

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

Importance: Data models are a …. tool

A

communication

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

Importance: Data models give an overall….

A

view of the database

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

Importance: Data models organize… for various users

A

data

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

Importance: Data models are an abstraction for the creation of g…. d…..

A

good database

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

Unique and distinct object used to collect and store data

A

Entity

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

A person, place, thing or event about which data will be collected and stored

A

Entity

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

Characteristic of an entity

A

Attribute

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

Describes an association among entities

A

Relationship

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

Set of rules to ensure data integrity

A

Constraint

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

Brief, precise, and unambiguous description of a policy, procedure, or principle

A

Business Rule

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

Business Rules enable defining the basic…

A

building blocks

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

Describe main and distinguishing characteristics of the data

A

Business Rule

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

Business rules must be rendered in …. and must be kept….

A

writing/ up to date

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

Business rules sometimes are … to the organization

A

external

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

Business rules must be easy to u…. and widely d…..

A

understand / disseminated

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

Business rules describe characteristics of the data as …. by the company

A

view

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

Company managers, policy makers, department managers, written documentation and direct interview with end users are…

A

sources of business rules

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

Business rules help standardize…

A

company’s view of data

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

Business rules create …. between users and designers

A

communications tool

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

Business rules allow designer to understand the … , …. , …. of data, and …. processes

A

nature/role/scope/business

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

Business rules allow designer to develop appropriate r….. participation rules and c….

A

relationship/ constrains

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

Business rules allow designer to create an accurate….

A

data model

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

Nouns translate into…

A

entities

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

Verb translate into… among entities

A

relationship

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

Relationships are b…

A

bidirectional

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

Conceptual organization of the entire database as viewed by the database administrator (whole database)

A

Schema

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

Portion of the database seen by the application programs that produce the desired information from the data within the database (part of database)

A

Subschema

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

Environment in which data can be managed and is used to work with the data in the database. SELECT,UPDATE, INSERT

A

Data manipulation language

36
Q

Enables the database administrator to define the schema components . CREATE, DROP, RENAME, TRUNCATE

A

Schema data definition language

37
Q

Based on a relation. Related to each other through sharing a common entity characteristic

A

The Relational Model

38
Q

The Relational Model describe a precise set of d…. m…. constructs

A

data manipulation

39
Q

Relational table is purely l…. s…..

A

logical structure

40
Q

Structural independence is promoted using i…. t…..

A

independent tables

41
Q

…. view improves conceptual simplicity

A

Tabular

42
Q

Ad hoc query capability is based on….

A

SQL

43
Q

Relational models Isolate the end-user from … details

A

physical-level

44
Q

Relational models improve i…. and m…… s………

A

implementation / management simplicity

45
Q

Relational model requires h…. and system s…… overhead

A

hardward / softward

46
Q

Conceptual simplicity gives untrained people the tools to use a g….. s….. p….

A

good system poorly

47
Q

Uses graphic representations to model database components

A

Entity relationship diagram (ERD)

48
Q

For ERD , an entity is mapped to a …..

A

relational table

49
Q

Entity instance or occurrence is …. in table

A

row

50
Q

Entity set is a collection of ….

A

like entities

51
Q

Connectivity lables types of….

A

relationships

52
Q

Entity relationship models with visuals yield conceptual s…

A

simplicity

53
Q

Entity relationship models with visuals make them effective… tool

A

communication

54
Q

Entity relation models are integrated with the dominant r…… m….

A

relational model

55
Q

Entity relationship models have limited c……. representation

A

constraint

56
Q

Entity relationship models have limited r……. representation

A

relationship

57
Q

Entity relationship models lose i……. content when a….. are removed from entities to avoid crowded displays.

A

information / attributes

58
Q

K…….. data model is based on a structure composed of two data elements: a key and a value, in which every key has a corresponding value or set of values.

A

key-value

59
Q

NoSQL Database are not base on the r…….. m………

A

relational model

60
Q

NoSQL databases support distributed d……. a…….

A

database arquitectures

61
Q

NoSQL Databases provide high s……., high a……, and fault t……

A

scalability / availability / tolerance

62
Q

NoSQL support ….. amounts of sparse data

A

large

63
Q

NoSQL database geared toward p….. rather than t….. c……

A

performance / transaction consistency

64
Q

Each row represents one entity instance - relational or key-value model

A

relational model

65
Q

Each column represents on attribute of the entity - relational or key-value model

A

relational model

66
Q

the values in a column are of the same data type - relational or key-value model

A

relational model

67
Q

Each row represents on attribute/value of one entity instance - relational or key-value model

A

key-value model

68
Q

the “ key” column could represent any entity’s attribute - relational or key-value model

A

key-value model

69
Q

The values in the “value column could be of any data- type and therefore it is generally assigned a long string data type - relational or key-value model

A

key-value model

70
Q

NoSQL provide high s…., a……., and fault t…. are provided

A

scalability/ availability/ tolerance

71
Q

NoSQL uses l…. commodity hardware

A

low-cost

72
Q

NoSQL supports B…. D…

A

big data

73
Q

For NoSQL, key-value model improves s….. e…..

A

storage efficiency

74
Q

For NoSQL, c……. programming is required

A

complex

75
Q

For NoSQL, there is no r………. s…….

A

relationship support

76
Q

For NoSQL, there is no i…… s……

A

integrity support

77
Q

Conceptual Model to Internal Model is …. independence

A

logical

78
Q

Internal Model to Physical model is ….. independence

A

physical

79
Q

E…… R……. is the most abstract model

A

ENTITY RELATIONSHIP

80
Q

R…. model is a medium abstract model

A

Relational

81
Q

End users’ view of the data environment

A

external model

82
Q

Represents a global view of the entire database by the entire organization

A

Conceptual model

83
Q

Representing database as seen by the DBMS mapping conceptual model to the DBMS

A

Internal model

84
Q

Describes the way data are saved on storage media such as disks or tapes

A

Physical model

85
Q

models Independent of hardward and softward

A

External and conceptual models

86
Q

models independent of hardware only

A

internal model

87
Q

model independent of neither hardware nor software

A

Physical

Business Data Management (6 decks)

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