Brainscape's Knowledge GenomeTM

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


See full index

Information Management > PRELIM CHAPTER 2 > Flashcards

PRELIM CHAPTER 2 Flashcards

1
Q

(T or F) Designers, programmers, and end users see data in different ways

A

T

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

(T or F) Different views of same data lead to designs that reflect the organization’s operation

A

F

Different views of same data lead to designs that do not reflect organization’s operation

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

reduces complexities of database design

  • data processing
  • data modeling
  • data management
  • data abstraction
A

data modeling

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

Various degrees of ____________ help reconcile varying views of same data

  • data processing
  • data modeling
  • data management
  • data abstraction
A

data abstraction

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

Relatively simple representations of complex real-world data structures

  • data models
  • data systems
  • database
  • data
A

data models

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

an abstraction of a real-world object or event

  • files
  • data
  • model
  • information
A

model

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

(T or F) Data modeling is iterative and progressive

A

T

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

(T or F) End users have different views and needs for data

A

T

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

organizes data for various users and it is an abstraction

  • database
  • DBMS
  • file systems
  • data model
A

data model

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

anything about which data are to be collected and stored

  • Entity
  • Attribute
  • Relationship
  • Constraint
A

Entity

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

a characteristic of an entity

  • Entity
  • Attribute
  • Relationship
  • Constraint
A

Attribute

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

describes an association among entities

  • Entity
  • Attribute
  • Relationship
  • Constraint
A

Relationship

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

a restriction placed on the data

  • Entity
  • Attribute
  • Relationship
  • Constraint
A

Constraint

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

3 types of relationships among entities:

A
  • One-to-many (1:M) relationship
  • Many-to-many (M:N or M:M) relationship
  • One-to-one (1:1) relationship
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

__________ are descriptions of policies, procedures, or principles within a specific organization

A

Business Rules

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

____________ describe characteristics of data as viewed by the
company

A

Business Rules

17
Q

*Sources of business rules:
*Company __________
*__________ makers
*__________ managers
*__________ documentation
*Direct __________ with end users

A

managers
Policy
Department
Written
interviews

18
Q

__________ translate into entities

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

Nouns

19
Q

__________ translate into relationships among entities

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

verbs

20
Q

__________ are bidirectional

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

relationships

21
Q
  • Proper naming:
  • Facilitates __________ between parties
  • Promotes __________
A

communication
self-documentation

22
Q

__________ occurs during translation of business rules to data model components

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

naming

23
Q

__________ should make the object unique and distinguishable from other objects

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

Names

24
Q

___________ should also be descriptive of objects in the environment and be familiar to users

  • nouns
  • verbs
  • relationships
  • naming
  • names
A

Names

25
Q

(T or F) Relational models were considered impractical in 1970

A

T

26
Q

Matrix consisting of row/column intersections

  • names
  • table
  • model
  • tuple
A

table

27
Q

the ___________ model is developed by E.F. Codd (IBM) in 1970

A

relational

28
Q

Each row in a relation is called a ___________

  • names
  • table
  • model
  • tuple
A

tuple

29
Q

___________ was conceptually simple at expense of computer overhead

  • names
  • table
  • model
  • tuple
A

model

30
Q

RDBMS means ?

A

Relational data management system

31
Q

Performs same functions provided by hierarchical model

  • RDBMS
  • DBMS
  • relational diagram
  • relational table
A

Relational data management system (RDBMS)

32
Q

Hides complexity from the user

  • RDBMS
  • DBMS
  • relational diagram
  • relational table
A

Relational data management system (RDBMS)

33
Q

Representation of entities, attributes, and relationships

  • RDBMS
  • DBMS
  • relational diagram
  • relational table
A

Relational diagram

34
Q

Representation of entities, attributes, and relationships

  • RDBMS
  • DBMS
  • relational diagram
  • relational table
A

relational table

Information Management (4 decks)

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