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 Data Management - Applications - C170 OA GSA1 
Add New Row 
INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, value3, ...); 
 
 
Update Row 
UPDATE table_name 
SET column1 = value1, column2 = value2, ... 
WHERE condition; 
 
 
Delete Row 
DELETE FROM table_name 
WHERE condition; 
 
 
Inner Join 
SELECT column_name(s) 
FROM table1 
INNER JOIN table2 
ON n_name = n_name; 
 
 
CREATE VIEW 
CREATE VIEW viewname AS 
SELECT Col1, Col2 
FROM table 
WHERE condition; 
 
 
Concat...
- Exam (elaborations)
- • 2 pages's •
-
WGU C170•WGU C170
Preview 1 out of 2 pages
WGU Data Management - Applications - C170 OA GSA1 
Add New Row 
INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, value3, ...); 
 
 
Update Row 
UPDATE table_name 
SET column1 = value1, column2 = value2, ... 
WHERE condition; 
 
 
Delete Row 
DELETE FROM table_name 
WHERE condition; 
 
 
Inner Join 
SELECT column_name(s) 
FROM table1 
INNER JOIN table2 
ON n_name = n_name; 
 
 
CREATE VIEW 
CREATE VIEW viewname AS 
SELECT Col1, Col2 
FROM table 
WHERE condition; 
 
 
Concat...
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 Data Management - Applications - C170 OA GSA1 
Add New Row 
INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, value3, ...); 
 
 
Update Row 
UPDATE table_name 
SET column1 = value1, column2 = value2, ... 
WHERE condition; 
 
 
Delete Row 
DELETE FROM table_name 
WHERE condition; 
 
 
Inner Join 
SELECT column_name(s) 
FROM table1 
INNER JOIN table2 
ON n_name = n_name; 
 
 
CREATE VIEW 
CREATE VIEW viewname AS 
SELECT Col1, Col2 
FROM table 
WHERE condition; 
 
 
Concat...
- Exam (elaborations)
- • 2 pages's •
-
WGU C170•WGU C170
Preview 1 out of 2 pages
WGU Data Management - Applications - C170 OA GSA1 
Add New Row 
INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, value3, ...); 
 
 
Update Row 
UPDATE table_name 
SET column1 = value1, column2 = value2, ... 
WHERE condition; 
 
 
Delete Row 
DELETE FROM table_name 
WHERE condition; 
 
 
Inner Join 
SELECT column_name(s) 
FROM table1 
INNER JOIN table2 
ON n_name = n_name; 
 
 
CREATE VIEW 
CREATE VIEW viewname AS 
SELECT Col1, Col2 
FROM table 
WHERE condition; 
 
 
Concat...