Brainscape's Knowledge GenomeTM

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


See full index

C175 Data Management Foundations > Lesson 2 > Flashcards

Lesson 2 Flashcards

1
Q

Data modeling

A

The process of creating a specific data model for a determined problem domain

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

Problem domain

A

A clearly defined area within the real-world environment, with a well-defined scope and boundaries that will be systematically addressed

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

A Data model:

A
  • A representation, usually graphic, of a complex “real-world” data structure.
  • Data models are used in the database design phase of the Database Life Cycle
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Entity

A

A person, place, thing, concept, or event for which data can be stored

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

Attribute

A
  • A characteristic of an entity or object.
  • An attribute has a name and a data type.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

One-to-many (1:M or 1…*) relationship

A
  • Associations among two or more entities that are used by data models.
  • In a 1:M relationship, one entity instance is associated with many instances of the related entity.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Many-to-many (M:N or …) relationship

A

Association among two or more entities in which:

  1. one occurrence of an entity is associated with many occurrences of a related entity &
  2. one occurrence of the related entity is associated with many occurrences of the first entity.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

One-to-one (1:1 or 1…1) relationship

A
  • Associations among two or more entities
  • In a 1:1 relationship, one entity instance is associated with only one instance of the related entity.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Constraint

A

A restriction placed on data, usually expressed in the form of rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  1. Each record from first table is associated with many records in second table
  2. But each record in second table is associated with one record in first table.

What type of relationship is it?

A

One-to-many (1:M) relationship

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

Single record in the first table is related to only one record in the second table and vice versa.
What type of relationship is it?

A

One-to-one (1:1) relationship

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

Each record from first table is associated with many records in second table and one record in second table is associated with many records in first table
What type of relationship is it?

A

Many-to-many (M:M) relationship

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

Business rule

For example, a pilot cannot be on duty for more than 10 hours during a 24-hour period

A

A description of a policy, procedure, or principle within an organization.

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

Hierarchical model

A

An early database model whose basic concepts and characteristics formed the basis for subsequent database development

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

Segment

A

In the hierarchical data model, the equivalent of a file system’s record type

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

Network model

A

An early data model that represented data as a collection of record types in 1:M relationships.

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

Schema

A

A logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other.

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

Subschema

A

The portion of the database that interacts with application programs.

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

Data manipulation language (DML)

A

The set of commands that allows an end user to manipulate the data in the database, such as SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK.

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

Data definition language (DDL)

A

The language that allows a database administrator to define the database structure, schema, and subschema

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

Relational database

A

a collection of relations that contain the data describing a particular business environment.

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

Relational model

A
  • Each relation (table) is conceptually represented as a two-dimensional structure of intersecting rows and columns.
  • The relations are related to each other through the sharing of common entity characteristics (values in columns).
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Relation

A

A logical construct perceived to be a two-dimensional structure composed of intersecting rows (entities) and columns (attributes) that represents an entity set in the relational model.

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

Tables are somtimes called ______

A

Relation

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

Tuple

A

In the relational model, a table row.

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

Relational database management system (RDBMS)

A

A collection of programs that manages a relational database. The RDBMS software translates a user’s logical requests (queries) into commands that physically locate and retrieve the requested dat

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

Relational diagram

A

A graphical representation of a relational database’s entities, the attributes within those entities, and the relationships among the entities.

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

Entity relationship (ER) Model

A

A data model that describes relationships (1:1, 1:M, and M:N) among entities at the conceptual level with the help of ER diagrams. The model was developed by Peter Chen.

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

Entity relationship diagram (ERD)

A

A diagram that depicts an entity relationship model’s entities, attributes, and relations.

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

Entity instance (entity occurrence)

A

A row in a relational table

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

Entity set

A

A collection of like entities

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

Connectivity

A

The type of relationship between entities. Classifications include 1:1, 1:M, and M:N.

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

What are the 3 types of ER notations?

A
  • Chen notation
  • Crow’s foot notation
  • class diagram notation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Crow’s Foot notation

A

A representation of the entity relationship diagram that uses a three-pronged symbol to represent the “many” sides of the relationship.

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

In relational database tables, a _____ describes a row and an ______ describes a column of that table.

A

Tuple; Attribute

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

OODM

A
  • Object-oriented data model

- A data model whose basic modeling structure is an object

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

Object

A

An abstract representation of a realworld entity that has a unique identity, embedded properties, and the ability to interact with other objects and itself

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

Object-oriented database management system

A
  • OODBMS

- Data management software used to manage data in an object-oriented database model.

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

Semantic data model

A

The first of a series of data models that more closely represented the real world, modeling both data and their relationships in a single structure known as an object.

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

Class

A

A collection of similar objects with shared structure (attributes) and behavior (methods). A class encapsulates an object’s data representation and a method’s implementation. Classes are organized in a class hierarchy.

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

Method

A

In the object-oriented data model, a named set of instructions to perform an action. Methods represent real-world actions, and are invoked through messages

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

Class hierarchy

A

The organization of classes in a hierarchical tree in which each parent class is a superclass and each child class is a subclass.

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

Inheritance

A

In the object-oriented data model, the ability of an object to inherit the data structure and methods of the classes above it in the class hierarchy.

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

UML

A
  • Unified Model Language
  • A language based on object-oriented concepts that provides tools such as diagrams and symbols to graphically model a system.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Class diagram

A

A diagram used to represent data and their relationships in UML object notation.

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

_____ is a highly distributed, fault-tolerant file storage system designed to manage large amount of data at high speed.

A

HDFS (Hadoop Distributed File System)

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

ERDM

A
  • Extended Relational Data Model
  • A model that includes the object-oriented model’s best features in an inherently simpler relational database structural environment.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Object/Relational DBMS (O/R DBMS)

A
  • A DBMS based on the extended relational model (ERDM). The ERDM, championed by many relational database researchers, constitutes the relational model’s response to the OODM.
  • This model includes many of the object-oriented model’s best features within an inherently simpler relational database structure.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

Big Data

A

A movement to find new and better ways to manage large amounts of web-generated data and derive business insight from it, while simultaneously providing high performance and scalability at a reasonable cost.

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

What are the 3 V’s in big data databases

A
  • Volume
  • Velocity
  • Variety
51
Q

Hadoop

A

A Java based, open source, high speed, fault-tolerant distributed storage and computational framework. It uses low-cost hardware to create clusters of thousands of computer nodes to store and process data.

52
Q

HDFS

A
  • Hadoop Distributed File System

- A highly distributed, fault-tolerant file storage system designed to manage large amounts of data at high speeds.

53
Q

What are the three types of nodes that HDFS uses?

A
  • Name node
  • Data node
  • Client mode
54
Q

Name node

A

Stores all the metadata about the file system

55
Q

Data node

A

The data node stores fixed-size data blocks

56
Q

Client node

A

Acts as the interface between the user application and the HDFS

57
Q

MapReduce

A

An open-source application programming interface (API) that provides fast data analytics services; one of the main Big Data technologies that allows organizations to process massive data stores

58
Q

NoSQL

A

A new generation of database management systems that is not based on the traditional relational database model.

59
Q

Key-value

A

A data model 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. Itl is also called the associative or attribute-value data model.

60
Q

Sparse data

A

A case in which the number of table attributes is very large but the number of actual data instances is low.

61
Q

Eventual consistency

A

A model for database consistency in which updates to the database will propagate through the system so that all data copies will be consistent eventually

62
Q

In Chen notation, entities and relationships have to be oriented horizontally; not vertically. (T/F)

A

False

63
Q

A(n) _______ is anything about which data are to be collected and stored.

A

entity

64
Q

Even when a good database blueprint is available, an applications programmer’s view of the data should match that of the manager and the end user. (T/F)

A

False

65
Q

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. (T/F)

A

True

66
Q

What is a disadvantage of the hierarchical data model?

A

It does not have standards.

67
Q

In object oriented terms, a(n) _____ defines an object’s behavior

A

Method

68
Q

The object-oriented data model was developed in the _______ . (What is the year?)

A

1980s

69
Q

A(n) _______ enables a database administrator to describe schema components.

A

Data definition langauge (DDL)

70
Q

A data model is usually graphical (T/F)

A

True

71
Q

Each row in a relation is called a ____

A

Tuple

72
Q

Which of the following types of HDFS nodes stores all the metadata about a file system?

A

Name node

73
Q

A _____ is a collection of similar objects with a shared structure and behavior.

A

Class

74
Q

A _____ defines the environment in which data can be managed and is used to work with the data in the database.

A

data manipulation language,DML

75
Q

The hierarchical data model was developed in the _______.

A

1960s-1970s

76
Q

In a SQL-based relational database, each table is dependent on every other table. (T/F)

A

False

77
Q

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. (T/F)

A

False

78
Q

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______

A

Business rules

79
Q

Today, most relational database products can be classified as object/relational. (T/F)

A

True

80
Q

_______ are important because they help to ensure data integrity.

A

Constraints

81
Q

Students and classes have a _______ relationship.

A

Many-to-many relationship

82
Q

Database designers determine the data and information that yield the required understanding of the entire business. (T/F)

A

False

83
Q

A _____ ____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

A

Business Rule

84
Q

In _____ a three pronged symbol represents the “many” side of the relationship.

A

Crows foot notation

85
Q

In the _______ model, each parent can have many children, but each child has only one parent.

A

Hierarchical

86
Q

An implementation-ready data model should contain a description of the data structure that will store the end-user data. (T/F)

A

True

87
Q

Business rules must be rendered in writing and be updated to reflect any change in the organization’s operational environment. (T/F)

A

True

88
Q

Each column in a relation represents a _____

A

Attribute

89
Q

A verb associating two nouns in a business rule translates to a(n) _______ in the data model.

A

Relationship

90
Q

A(n) _______ is bidirectional.

A

Relationship

91
Q

The _______ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

A

Entity Relationship

92
Q

A(n) _______ is a restriction placed on the data.

A

Constraint

93
Q

Each row in the relational table is known as an entity instance or entity occurrence in the ER model. (T/F)

A

True

94
Q

A ______ is a relatively simple representation of more complex real-world data structures.

A

Data Model

95
Q

A(n) _______ represents a particular type of object in the real world.

A

Entity

96
Q

Oracle 12c is an example of the _______.

A

XML/Hybrid data model

97
Q

The relational data model was developed in the _______.

A

1970s

98
Q

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. (T/F)

A

True

99
Q

A _____ in a hierarchical model is the equivalent of a record in a file system

A

Segment

100
Q

The relational model is hardware-dependent and software-independent. (T/F)

A

False

101
Q

he relational model’s foundation is a mathematical concept known as a _____

A

Relation

102
Q

A ______ is the conceptual organization of an entire database as viewed by a database administrator

A

Schema

103
Q

The _______ data model is said to be a semantic data model.

A

Object-oriented

104
Q

The network model has structural level dependence. (T/F)

A

True

105
Q

Each row in the relational table is known as a(n) ______

A

Entity instance

106
Q

In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

A

Network

107
Q

A noun in a business rule translates to a(n) _______ in the data model.

A

Entity

108
Q

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

A

Client node

109
Q

The _______ data model uses the concept of inheritance.

A

Object-oriented

110
Q

In an SQL-based relational database, rows in different tables are related based on common values in common attributes. (T/F)

A

True

111
Q

The hierarchical model is software-independent. (T/F)

A

False

112
Q

What is true about NoSQL databases?

A
  • not based on the relational model and SQL
  • support distributed database architectures.
  • provide high scalability, high availability, and fault tolerance.
  • support very large amounts of sparse data.
  • are geared toward performance rather than transaction consistency.
113
Q

M:N relationships are not appropriate in a relational model. (T/F)

A

True

114
Q

In the _______ model, the basic logical structure is represented as an upside-down tree.

A

Hierarchical

115
Q

An implementation-ready data model needn’t necessarily contain enforceable rules to guarantee the integrity of the data. (T/F)

A

False

116
Q

The _______ model uses the term connectivity to label the relationship types.

A

entity relationship

117
Q

A(n) _______ is the equivalent of a field in a file system

A

attribute

118
Q

MySQL is an example of the _______.

A

Relational data model

119
Q

A(n) ______’s main function is to help one understand the complexities of the real world environment.

A

Model

120
Q

VMS/VSAM is an example of the _______.

A

File system data model

121
Q

What is true about business rules?

A

They can serve as a communication tool between the users and designers.

122
Q

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. (T/F)

A

False

123
Q

NoSQL databases provide ______ tolerance

A

Fault

124
Q

_______ are normally expressed in the form of rules.

A

Constraints

C175 Data Management Foundations (9 decks)

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