Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Business Data Management > Quiz 1 - Part 2 > Flashcards

Quiz 1 - Part 2 Flashcards

(87 cards)

Start Studying
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
Business rules help standardize...
company's view of data
26
Business rules create .... between users and designers
communications tool
27
Business rules allow designer to understand the ... , .... , .... of data, and .... processes
nature/role/scope/business
28
Business rules allow designer to develop appropriate r..... participation rules and c....
relationship/ constrains
29
Business rules allow designer to create an accurate....
data model
30
Nouns translate into...
entities
31
Verb translate into... among entities
relationship
32
Relationships are b...
bidirectional
33
Conceptual organization of the entire database as viewed by the database administrator (whole database)
Schema
34
Portion of the database seen by the application programs that produce the desired information from the data within the database (part of database)
Subschema
35
Environment in which data can be managed and is used to work with the data in the database. SELECT,UPDATE, INSERT
Data manipulation language
36
Enables the database administrator to define the schema components . CREATE, DROP, RENAME, TRUNCATE
Schema data definition language
37
Based on a relation. Related to each other through sharing a common entity characteristic
The Relational Model
38
The Relational Model describe a precise set of d.... m.... constructs
data manipulation
39
Relational table is purely l.... s.....
logical structure
40
Structural independence is promoted using i.... t.....
independent tables
41
.... view improves conceptual simplicity
Tabular
42
Ad hoc query capability is based on....
SQL
43
Relational models Isolate the end-user from ... details
physical-level
44
Relational models improve i.... and m...... s.........
implementation / management simplicity
45
Relational model requires h.... and system s...... overhead
hardward / softward
46
Conceptual simplicity gives untrained people the tools to use a g..... s..... p....
good system poorly
47
Uses graphic representations to model database components
Entity relationship diagram (ERD)
48
For ERD , an entity is mapped to a .....
relational table
49
Entity instance or occurrence is .... in table
row
50
Entity set is a collection of ....
like entities
51
Connectivity lables types of....
relationships
52
Entity relationship models with visuals yield conceptual s...
simplicity
53
Entity relationship models with visuals make them effective... tool
communication
54
Entity relation models are integrated with the dominant r...... m....
relational model
55
Entity relationship models have limited c....... representation
constraint
56
Entity relationship models have limited r....... representation
relationship
57
Entity relationship models lose i....... content when a..... are removed from entities to avoid crowded displays.
information / attributes
58
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.
key-value
59
NoSQL Database are not base on the r........ m.........
relational model
60
NoSQL databases support distributed d....... a.......
database arquitectures
61
NoSQL Databases provide high s......., high a......, and fault t......
scalability / availability / tolerance
62
NoSQL support ..... amounts of sparse data
large
63
NoSQL database geared toward p..... rather than t..... c......
performance / transaction consistency
64
Each row represents one entity instance - relational or key-value model
relational model
65
Each column represents on attribute of the entity - relational or key-value model
relational model
66
the values in a column are of the same data type - relational or key-value model
relational model
67
Each row represents on attribute/value of one entity instance - relational or key-value model
key-value model
68
the " key" column could represent any entity's attribute - relational or key-value model
key-value model
69
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
key-value model
70
NoSQL provide high s...., a......., and fault t.... are provided
scalability/ availability/ tolerance
71
NoSQL uses l.... commodity hardware
low-cost
72
NoSQL supports B.... D...
big data
73
For NoSQL, key-value model improves s..... e.....
storage efficiency
74
For NoSQL, c....... programming is required
complex
75
For NoSQL, there is no r.......... s.......
relationship support
76
For NoSQL, there is no i...... s......
integrity support
77
Conceptual Model to Internal Model is .... independence
logical
78
Internal Model to Physical model is ..... independence
physical
79
E...... R....... is the most abstract model
ENTITY RELATIONSHIP
80
R.... model is a medium abstract model
Relational
81
End users’ view of the data environment
external model
82
Represents a global view of the entire database by the entire organization
Conceptual model
83
Representing database as seen by the DBMS mapping conceptual model to the DBMS
Internal model
84
Describes the way data are saved on storage media such as disks or tapes
Physical model
85
models Independent of hardward and softward
External and conceptual models
86
models independent of hardware only
internal model
87
model independent of neither hardware nor software
Physical

Business Data Management (6 decks)

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