Package deal
WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
[Show more]WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
[Show more]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 opt...
Preview 1 out of 3 pages
Add to cartaccess 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 opt...
1.1.1 - Conceptual Schema - ER Model 
Tables: Customer, DonutOrder, Donut - -Customer: 
PK - CustomerID 
Rest are customer related fields 
DonutOrder: 
FK - CustomerID, 
FK - DonutID 
Qty, SpecialNotes 
Donut: 
PK - DonutID 
Rest are donut fields 
Relationships: 
Customer - 1:n Identifying - DonutOr...
Preview 2 out of 5 pages
Add to cart1.1.1 - Conceptual Schema - ER Model 
Tables: Customer, DonutOrder, Donut - -Customer: 
PK - CustomerID 
Rest are customer related fields 
DonutOrder: 
FK - CustomerID, 
FK - DonutID 
Qty, SpecialNotes 
Donut: 
PK - DonutID 
Rest are donut fields 
Relationships: 
Customer - 1:n Identifying - DonutOr...
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 
O...
Preview 3 out of 20 pages
Add to cartDomain 
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 
O...
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? 
One-to-one 
One-to-many 
Many-to-many 
One-to-one binary - -Many-to-many 
Which two examples are attributes? 
Choose 2 answers 
A person ...
Preview 3 out of 21 pages
Add to cartA 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? 
One-to-one 
One-to-many 
Many-to-many 
One-to-one binary - -Many-to-many 
Which two examples are attributes? 
Choose 2 answers 
A person ...
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 in...
Preview 2 out of 8 pages
Add to cartAssociative 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 in...
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 ...
Preview 2 out of 6 pages
Add to cartAREA - -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 ...
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), a...
Preview 1 out of 3 pages
Add to cartbinary 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), a...
CREATE TABLE syntax 
DDL - -CREATE TABLE tableName ( 
colName dataType constraint 
INDEX indexName (colName) 
PRIMARY KEY (colName, colName) 
or 
colName dataType PRIMARY KEY 
FOREIGN KEY (colName, colName) 
REFERENCES tableName (colName) 
); 
CREATE INDEX syntax 
DDL - -CREATE [UNIQUE] INDEX indexN...
Preview 1 out of 4 pages
Add to cartCREATE TABLE syntax 
DDL - -CREATE TABLE tableName ( 
colName dataType constraint 
INDEX indexName (colName) 
PRIMARY KEY (colName, colName) 
or 
colName dataType PRIMARY KEY 
FOREIGN KEY (colName, colName) 
REFERENCES tableName (colName) 
); 
CREATE INDEX syntax 
DDL - -CREATE [UNIQUE] INDEX indexN...
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 ...
Preview 4 out of 33 pages
Add to cartAREA - -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 ...
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 kind of relationship is displayed in this entity-relationship diagram? - -Many-to-Many Unary 
Which kind of relatio...
Preview 2 out of 6 pages
Add to cartA 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 kind of relationship is displayed in this entity-relationship diagram? - -Many-to-Many Unary 
Which kind of relatio...
domain - -In data modeling, the construct used to organize and describe an attribute's set of possible 
values 
superkey - -An attribute or attributes that uniquely identify each entity in a table. Any composite key 
with this is also this. 
candidate key - -A minimal superkey; that is, a key that ...
Preview 2 out of 6 pages
Add to cartdomain - -In data modeling, the construct used to organize and describe an attribute's set of possible 
values 
superkey - -An attribute or attributes that uniquely identify each entity in a table. Any composite key 
with this is also this. 
candidate key - -A minimal superkey; that is, a key that ...
A database model - -is a conceptual framework for database software 
The relational model - -is a database model based on mathematical principles, with three parts: 
1. A data structure that prescribes how data is organized. 
2. Operations that manipulate data structures. 
3. Rules that govern valid...
Preview 2 out of 12 pages
Add to cartA database model - -is a conceptual framework for database software 
The relational model - -is a database model based on mathematical principles, with three parts: 
1. A data structure that prescribes how data is organized. 
2. Operations that manipulate data structures. 
3. Rules that govern valid...
Syntax for updating a specific column in a specific row - -UPDATE <table> 
SET <atrribute> = <value> 
WHERE <primary key> = <value>; 
Syntax for deleting a row - -DELETE FROM <TableName> 
WHERE <PrimaryKey> = <#>; 
Syntax for creating a view - -CREATE ...
Preview 1 out of 2 pages
Add to cartSyntax for updating a specific column in a specific row - -UPDATE <table> 
SET <atrribute> = <value> 
WHERE <primary key> = <value>; 
Syntax for deleting a row - -DELETE FROM <TableName> 
WHERE <PrimaryKey> = <#>; 
Syntax for creating a view - -CREATE ...
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...
Preview 2 out of 8 pages
Add to cartA 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...
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. 
Alias - -An alternative name for a column or table in a SQL statement. 
ALTER TABLE...
Preview 2 out of 14 pages
Add to cartAccess 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. 
Alias - -An alternative name for a column or table in a SQL statement. 
ALTER TABLE...
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)
Preview 1 out of 2 pages
Add to cartAdd 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)
Create Database Syntax - -CREATE DATABASE db_name; 
Simple SFW query syntax - -SELECT * FROM db_name WHERE column_name operator value; 
Cardinality: Inside or outside? - -Outside 
Modality: Inside or outside? - -Inside 
What commands are used with data definition? - -create, alter, drop, truncate, c...
Preview 1 out of 3 pages
Add to cartCreate Database Syntax - -CREATE DATABASE db_name; 
Simple SFW query syntax - -SELECT * FROM db_name WHERE column_name operator value; 
Cardinality: Inside or outside? - -Outside 
Modality: Inside or outside? - -Inside 
What commands are used with data definition? - -create, alter, drop, truncate, c...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller Preach. Stuvia facilitates payment to the seller.
No, you only buy these notes for $40.49. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
73918 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now