WGU c170
Latest uploads at WGU c170. Looking for notes at WGU c170? We have lots of notes, study guides and study notes available for your school.
-
446
- 0
-
45
All courses for WGU c170
-
WGU C170 5
-
WGU - C170 4
-
WGU C170 WGUC170 446
-
WGU C170, 1
Latest notes & summaries WGU c170
WGU Course C170 - Data Management (Applications) Quizlet by Brian MacFarlane 
A salesperson is authorized to sell many products and a product can be sold by many salespersons. 
 
Which kind of binary relationship does this scenario describe? 
 
A One-to-one 
B One-to-many 
C One-to-one binary 
D Many-to-many 
D 
 
 
Which kind of relationship is displayed in this entity-relationship diagram? 
 
A Many-to-many unary 
B Many-to-many binary 
C One-to-one unary 
D One-to-one binary 
A 
 
 
Which kin...
- Exam (elaborations)
- • 71 pages's •
-
WGU C170•WGU C170
Preview 4 out of 71 pages
WGU Course C170 - Data Management (Applications) Quizlet by Brian MacFarlane 
A salesperson is authorized to sell many products and a product can be sold by many salespersons. 
 
Which kind of binary relationship does this scenario describe? 
 
A One-to-one 
B One-to-many 
C One-to-one binary 
D Many-to-many 
D 
 
 
Which kind of relationship is displayed in this entity-relationship diagram? 
 
A Many-to-many unary 
B Many-to-many binary 
C One-to-one unary 
D One-to-one binary 
A 
 
 
Which kin...
WGU C170 Terms.|Latest Update Complete with A+ Graded Answers 
Associative Entity 
All relationships for the (...) entity should be many. 
 
 
Attribute 
An (...) is a property or characteristic of an entity. 
 
 
Binary relationship 
A (...) is a relationship between two entity types. 
 
 
Cardinality 
(...) represents the maximum number of entities that can be involved in a particular relationship. 
 
 
Cascade Delete 
Will delete all records that reference the primary key 
 
 
Database 
A (.....
- Exam (elaborations)
- • 7 pages's •
-
WGU C170•WGU C170
Preview 2 out of 7 pages
WGU C170 Terms.|Latest Update Complete with A+ Graded Answers 
Associative Entity 
All relationships for the (...) entity should be many. 
 
 
Attribute 
An (...) is a property or characteristic of an entity. 
 
 
Binary relationship 
A (...) is a relationship between two entity types. 
 
 
Cardinality 
(...) represents the maximum number of entities that can be involved in a particular relationship. 
 
 
Cascade Delete 
Will delete all records that reference the primary key 
 
 
Database 
A (.....
WGU C170 Data Management - Applications|Latest Update Complete with A+ Graded Answers 
 
Domain 
In data modeling, the construct used to organize and describe an attribute's set of possible values. 
 
 
Primary key (PK) 
An identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. 
 
 
 
Key 
One or more attributes that determine other attributes. 
 
 
Determination 
The role of a key. In the c...
- Exam (elaborations)
- • 18 pages's •
-
WGU C170•WGU C170
Preview 3 out of 18 pages
WGU C170 Data Management - Applications|Latest Update Complete with A+ Graded Answers 
 
Domain 
In data modeling, the construct used to organize and describe an attribute's set of possible values. 
 
 
Primary key (PK) 
An identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. 
 
 
 
Key 
One or more attributes that determine other attributes. 
 
 
Determination 
The role of a key. In the c...
WGU C170 Chapter 2.|Latest Update Complete with A+ Graded Answers 
binary relationship 
An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. 
 
 
cardinality 
An attribute that can be further subdivided to yield additional attributes. For example, a phone number such as may be divided into an area code (615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute. 
 
 
composite identifier 
In ER modeling, a key co...
- Exam (elaborations)
- • 3 pages's •
-
WGU C170•WGU C170
Preview 1 out of 3 pages
WGU C170 Chapter 2.|Latest Update Complete with A+ Graded Answers 
binary relationship 
An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. 
 
 
cardinality 
An attribute that can be further subdivided to yield additional attributes. For example, a phone number such as may be divided into an area code (615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute. 
 
 
composite identifier 
In ER modeling, a key co...
WGU C170 Chapter 1|Latest Update Complete with A+ Graded Answers 
AREA 
In DB2, a named section of permanent storage space that is reserved to store the database. 
 
 
associative entity 
See composite entity. 
 
 
bridge entity 
See composite entity. 
 
 
candidate key 
A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. 
 
 
closure 
A property of relational operators that permits the use of relational algebra operators on existin...
- Exam (elaborations)
- • 5 pages's •
-
WGU C170•WGU C170
Preview 2 out of 5 pages
WGU C170 Chapter 1|Latest Update Complete with A+ Graded Answers 
AREA 
In DB2, a named section of permanent storage space that is reserved to store the database. 
 
 
associative entity 
See composite entity. 
 
 
bridge entity 
See composite entity. 
 
 
candidate key 
A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. 
 
 
closure 
A property of relational operators that permits the use of relational algebra operators on existin...
WGU C170 - Data Management Applications.|A+ Graded Update 
A salesperson is authorized to sell many products and a product can be sold by many salespersons. 
 
Which kind of binary relationship does this scenario describe? 
Many-to-many 
 
 
Which two examples are attributes? 
An employee number; A meeting code 
 
 
Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? 
Set-to-null 
 
 
Refer to the given SQL statement. ...
- Exam (elaborations)
- • 7 pages's •
-
WGU C170•WGU C170
Preview 2 out of 7 pages
WGU C170 - Data Management Applications.|A+ Graded Update 
A salesperson is authorized to sell many products and a product can be sold by many salespersons. 
 
Which kind of binary relationship does this scenario describe? 
Many-to-many 
 
 
Which two examples are attributes? 
An employee number; A meeting code 
 
 
Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? 
Set-to-null 
 
 
Refer to the given SQL statement. ...
Lesson 5 Indexes (FLASH CARDS) - C170 - Database Management Applications (WGU) 
access plan 
A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. 
 
 
algorithms 
A process or set of operations in a calculation. 
 
 
automatic query optimization 
A method by which a DBMS finds the most efficient access path for the execution of a query. 
 
 
B-tree ind...
- Exam (elaborations)
- • 3 pages's •
-
WGU C170•WGU C170
Preview 1 out of 3 pages
Lesson 5 Indexes (FLASH CARDS) - C170 - Database Management Applications (WGU) 
access plan 
A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. 
 
 
algorithms 
A process or set of operations in a calculation. 
 
 
automatic query optimization 
A method by which a DBMS finds the most efficient access path for the execution of a query. 
 
 
B-tree ind...
Data Management Applications C170 
What is a table? 
A table is a persistent representation of a logical relation that is a relation whose contents can be saved for permanent use. 
 
 
What are the characteristics of a relational table? 
The characteristics of a relational table are that a table is perceived as a two-dimensional structure composed of rows and columns, each row (tuple) represents a single entity occurrence within the set, each column represents an attribute, each column has a dis...
- Exam (elaborations)
- • 24 pages's •
-
WGU C170•WGU C170
Preview 3 out of 24 pages
Data Management Applications C170 
What is a table? 
A table is a persistent representation of a logical relation that is a relation whose contents can be saved for permanent use. 
 
 
What are the characteristics of a relational table? 
The characteristics of a relational table are that a table is perceived as a two-dimensional structure composed of rows and columns, each row (tuple) represents a single entity occurrence within the set, each column represents an attribute, each column has a dis...
WGU C170 - DATA MANAGEMENT APPLICATIONS2024 DETAILED STUDY GUIDE WITH COMPREHENSIVE QUESTIONS AND SOLUTIONS LATEST UPDATE (GRADED A+)
- Exam (elaborations)
- • 16 pages's •
-
WGU C170•WGU C170
Preview 3 out of 16 pages
WGU C170 - DATA MANAGEMENT APPLICATIONS2024 DETAILED STUDY GUIDE WITH COMPREHENSIVE QUESTIONS AND SOLUTIONS LATEST UPDATE (GRADED A+)
WGU C170 Chp 1, With Complete Verified Solution 2024. 
AREA 
in DB2, a named section of permanent storage space that is reserved to store the database. 
associative entity 
another name for composite entity, bridge entity or linking table 
bridge entity 
another name for composite entity, associative entity or linking table 
candidate key 
a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. 
closure 
A property of relational operators that p...
- Package deal
- Exam (elaborations)
- • 4 pages's •
-
WGU C170•WGU C170
-
WGU , With Complete Verified Solution 2024, Updated.2024• By INVINCIBLE
Preview 1 out of 4 pages
WGU C170 Chp 1, With Complete Verified Solution 2024. 
AREA 
in DB2, a named section of permanent storage space that is reserved to store the database. 
associative entity 
another name for composite entity, bridge entity or linking table 
bridge entity 
another name for composite entity, associative entity or linking table 
candidate key 
a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. 
closure 
A property of relational operators that p...