Brainscape's Knowledge GenomeTM

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


See full index

Data Management Concepts > Final Exam Prep > Flashcards

Final Exam Prep Flashcards

1
Q

What is stored representations of objects and events that have meaning and importance in the user’s environment?

A

Data

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

What is data that have been processed in such a way as to increase the knowledge of the person who uses the data?

A

Information

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

What is data that describes the properties or characteristics of end-user data and the context of those data?

A

Metadata

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

Why were computer based file processing systems developed?

A

To store, manipulate, and retrieve large files of data.

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

What are some disadvantages associated with file processing?

A
  • Program-data dependence
  • Duplication of data
  • Limited data sharing
  • Lengthy development times
  • Excessive Program Maintenance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are graphical systems used to capture the nature and relationships among data?

A

Data model

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

What is an applicaiton program (or set or related programs) that is used to perform a series of database activities (create, read, update, and delete) on behalf of database users.

A

Database application

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

What is a person, a place, an object, an event, or a concept in the user environment about which the organization wishes to maintain data?

A

An entity

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

What is a database that represents data as a collection of tables in which all data relationships are represented by common values in related tables?

A

Relational Database

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

What is a software system that is used to create, maintain, and provide controlled access to user databases?

A

Database Management System (DBMS)

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

What are advantages of the Database approach?

A
  • Program-data independence
  • Planned data redundancy
  • Improved data consistency
  • Improved data sharing
  • Increased productivity of application development
  • Enforcement of standards
  • Improved data quality
  • Improved data accessibility and responsiveness
  • Reduced program maintenance
  • Improved decision support
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the seperation of data descriptions from the application programs that use the data?

A

Data independence

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

What are software tools that provide automated support for creating data models?

A

Data modeling and design tools?

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

What are the components of the database environment?

A
  • Data modeling and desing tools
  • Repository
  • DBMS
  • Database
  • Application programs
  • User interface
  • Data and database administrators
  • System developers
  • End users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components?

A

Repository

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

What is the first step in database development, in which the scope and general contents of organizational databases are specified?

A

Enterprise data modeling

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

What is the traditional methodology used to develop, maintain, and replace information systems?

A

Systems Development Life Cycle (SDLC)

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

What are the parts of the SDLC?

A
  • Planning - Enterprise modeling
  • Planning - Conceptual data modeling
  • Analysis - Conceptual Data Modeling
  • Design - Logical database design
  • Design - Physical database design and definition
  • Implementation - Database implementation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is the purpose of the SDLC?

A

To develop a preliminary understanding of a business situation and how information systems might help solve a problem or make an oppurtunity possible.

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

What is a detailed, technology-independent specification of the overall structure of organizational data?

A

Conceptual schema

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

What is the representation of a database for a particular data management technology?

A

Logical schema

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

What are specifications for how data from a logical schema are stored in a computer’s secondary memory by a DBMS?

A

Physical schema

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

What is an iterative process of systems development in which requirements are converted to a working system that is continually revised through close work between analysts and users?

A

Prototyping

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

What is an approach to database and software development that emphasizes “individuals and interactions over process and tools, working software over comprehensive documentation, customer collaboration over contract negotiation, and response to change over following a plan.”?

A

Agile software development

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

What is a planned undertaking of related activities to reach an objective that has a beginning and an end?

A

Project

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

What is a business management system that integrates all functions of the enterprise, such as manufacturing, sales, finance, marketing, inventory, accounting, and human resources?

A

Enterprise Resource Planning (ERP) Systems

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

What systems are software applications that provide the data necessary for the enterprise to examine and manage it’s activities?

A

Enterprise resource planning (ERP) systems

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

What is an integrated decision support database whose content is derived from the various operational databases?

A

Data warehouse

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

What is a logical representation of the data for an organization or for a business area, using entities for categories of data and relationships for associations between entities.

A

Entity-Relationship Model (E-R Model)

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

What is a graphical representation of an entity-relationship model?

A

Entity-Relationship diagram (ERD)

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

What are the cardinalities in an ERD?

A
  • Two lines across the relationship line = Mandatory one relationship
  • One line with a Forked end = Mandatory many relationship
  • One circle with one line = Optional one relationship
  • One circle with forked end = Optional many relationship
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What is a statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence the behavior of the business.

A

Business rules

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

What are the characteristics of a good business rule?

A
  • Declarative
  • Precise
  • Atomic
  • Consistent
  • Expressible
  • Distinct
  • Business-oriented
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What is a word or phrase that has a specific meaning for the business?

A

Term

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

What is an association between two or more terms?

A

Fact

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

What is a person, place, an object, an event, or a concept in the user environment about which the organization wishes to maintain data?

A

Entity

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

What is a collection of entities that share common properties or characteristics?

A

Entity type

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

What is a single occurence of an entity type?

A

Entity instance

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

What is an entity that exists independently of other entity types?

A

Strong entity type

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

What is an entity type whose existence depends on some other entity type?

A

Weak entity type

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

What is the entity type on which teh weak entity type depends?

A

Identifying owner

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

What is the relationship between a weak entity type and its owner?

A

Identifying relationship

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

What is a property or characteristic of an entity or relationship type that is of interest to the organization?

A

Attribute

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

What is an attribute that must have a value for every entity (or relationship) instance with which it is associated?

A

Required attribute

45
Q

What is an attribute that may not have a value for every entity (or relationship) instance with which it is associated?

A

Optional attribute

46
Q

What is an attribute that has meaningful component parts(attributes)?

A

Composite attribute

47
Q

What is an attribute that cannot be broken down into smaller components that are meaningful to the organization?

A

Simple (or atomic) attribute

48
Q

What is an attribute that may take on more than one value for a given entity (or relationship) instance?

A

Multivalued attribute

49
Q

What is an attribute whose values can be calculated from related attribute values?

A

Derived attribute

50
Q

What is an attribute (or combination of attributes) whose value distinguishes instances of an entity type?

A

Identifier

51
Q

What is an identifier that consist of a composite attribute?

A

Composite identifier

52
Q

How are composite attributes identified in an Entity?

A

No special annotation

53
Q

How are component attributes identified in an entity?

A

Inside () and below the attribute they are component to

54
Q

How are multivalued attributes identified in an Entity?

A

Inside curly braces { }

55
Q

How are multivalued attributes displayed in an entity?

A

Inside square [] brackets.

56
Q

How are identifiers displayed in an Entity?

A

Underlined, think IDs StudentID etc.

57
Q

What is a meaningful association between (or among) entity types?

A

Relationship type

58
Q

What is an association between (or among) entity instances where each relationship instance associates exactly one entity instance from each participating entity type?

A

Relationship instance

59
Q

What is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances?

A

Associate entity

60
Q

What is the number of entity types that participate in a relationship?

A

Degree

61
Q

What is a relationship between instances of a single entity type?

A

Unary relationship

62
Q

What is a relationship between the instances of two entity types?

A

Binary relationship

63
Q

What is a simultaneous relationship among the instances of three entity types?

A

Ternary relationship

64
Q

What is a rule that specifies the number of instances of one entity that can (or must) be associated with each instance of another entity?

A

Cardinality constraint

(Think the lines and cirles on the relationship line, they control how many can go into the entity)

i.e: double lines = minimum of one and maximum of one

circle line means minimun of zero and max of one

line fork - min one max many

circle fork - min zero max many

65
Q

What is the minimum number of instances of one entity that may be associated with each instance of another entity?

A

Minimum cardinality

66
Q

What is the maximum number of instances of one entity that may be associated with each instance of another entity?

A

Maximum cardinality

67
Q

What is a time value that is associated with a data value, often indicating when some event occured that affected the data value?

A

Time stamp

68
Q

What is a named two-dimensional table of data?

A

A relation

69
Q

What is an attribute or a combination of attributes that uniquely identifies each row in a relation?

A

Primary key

70
Q

What is a primary key that consists of more than one attribute?

A

Composite key

71
Q

What is an attribute in a relation that serves as the primary key of another relation in the same database?

A

Foreign key

72
Q

What are the three major types of integrity constraints?

A
  • Domain Constraints
  • Entity Integrity
  • Referential Integrity
73
Q

What constraint means that all values that appear in a column of a relation must be from the same domain?

A

Domain constraints

74
Q

What is the set of values that may be assigned to an attribute?

A

A domain

75
Q

What are the components of a domain definition?

A
  • Domain name
  • Meaning
  • Data type
  • Size (or length)
  • Allowable values or allowable range (if applicable)
76
Q

Which integrity rule is designed to ensure that every relation has a primary key and that the data values for that primary key are all valid?

A

Entity Integrity

77
Q

What is a value that may be assigned to an attribute when no other value applies or when the applicable value is unknown?

A

Null

78
Q

What is a rule that states that no primary key attribute (or component of a primary key attribute) may be null?

A

Entity integrity rule

79
Q

What is a rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null?

A

Referential integrity constraint

80
Q

What is a relation that contains minimal redundancy and allows users to insert, modify, and delete the rows in a table without errors or inconsistencies?

A

Well-structured relation

81
Q

What is an error or inconsistency that may result when a user attempts to update a table that contains redundant data.

A

Anomaly

82
Q

What are the three types of anomalies?

A

Insertion, deletion, and modification

83
Q

What is a serial number or other system-assigned primary key for a relation?

A

Surrogate Primary key

84
Q

What is a foreign key in a relation that references the primary key values of the same relation?

A

Recursive foreign key

Like in a unary relationship

85
Q

What is the process of decomposing relations with anomalies to produce smaller, well-structured relations.

A

Normalization

86
Q

What are the goals of normalization?

A
  1. Minimize data redundancy, thereby avoiding anomalies and conserving storage space.
  2. Simplify the enforcement of referential integrity constraints
  3. Make it easier to maintain data (insert, update, delete)
  4. Provide a better design that is an improved representation of the real world and a stonger basis for future growth
87
Q

What is a state of a relation that requires that certain rules regarding relationships between attributes (or functional dependencies) are satisfied?

A

Normal Form

88
Q

What are the steps in normalization?

A
  • First normal form
  • Second Normal form
  • Third normal form
89
Q

Which normalization form means that any multivalued attributes (also called repeating groups) have been removed, so there is a single value (possibly null) at the intersection of each row and column of the table?

A

First Normal Form

90
Q

Which normalization form means that any partial functional dependencies have been removed (i.e., nonkey attributes are identified by the whole primary key)?

A

Second normal form

91
Q

Whic normalization form means that any transitive dependencies have been removed (i.e., nonkey attributes are identified by only the primary key)

A

Third normal form

92
Q

What is a constraint between two attributes in which the value of one attribute is determined by the value of another attribute?

A

Functional dependency

Example: SSN -> Name, Address, Birthday

A person’s name address and birth date are functionally dependent on tha tperson’s SSN (in other words, there can be only one name, one address, and one birthdate for each SSN)

93
Q

What is the attribute on the left side of the arrow in a functional dependency?

A

Determinant

94
Q

What is an attribute, or combination of attributes, that uniquely indentifies a row in a relation?

A

Candidate key

95
Q

What is a relation that has a primary key and in which there are no repeating groups?

A

First normal form(1NF)

96
Q

What is a relation in first normal form in which every nonkey attribute is fully functional dependent on the primary key?

A

Second normal form(2NF)

97
Q

What is a functional dependency in which one or mor nonkey attributes are functionally dependent on part (but not all) of the primary key?

A

Partial functional dependency

98
Q

What is a relation that is in second normal form and has no transitive dependencies?

A

Third Normal Form (3NF)

99
Q

What is a functional dependency between the primary key and one or more nonkey attributes that are dependent on the primary key via another nonkey attribute?

A

Transitive dependency

100
Q

What is the smallest unit of application data recognized by system software?

A

Field

101
Q

What is a detailed coding scheme recognized by system software, such as a DBMS, for representing organizational data?

A

Data type

(VARCHAR, CHAR, NUMBER etc.)

102
Q

What is the process of transforming normalized relations into non-normalized physical record specifications?

A

Denormalization

103
Q

What is the distribution of rows of a logical relation into several seperate tables?

A

Horizontal partitioning

104
Q

What are the advantages of partitioning?

A
  • Efficiency
  • Local optimization
  • Security
  • Recovery and uptime
  • Load balancing
105
Q

What are the disadvantages of partitioning?

A
  • Inconsistent access speed
  • Complexity
  • Extra space and update time
106
Q

What is the distribution of the columns of a logical relation into several separate physical tables?

A

Verical partitioning

107
Q

What is a named portion of secondary memory (such as a hard disk) allocated for the purpose of storing physical records?

A

Physical file

108
Q

What is a named logical storage unit in which data from one or more database tables, views, or other database object may be stored?

A

Tablespace

109
Q

What is a contiguous section of disk storage space?

A

Extent

Data Management Concepts (12 decks)

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