Voordeelbundel
WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
[Meer zien]WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!
[Meer zien]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...
Voorbeeld 1 van de 3 pagina's
In winkelwagenaccess 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...
Voorbeeld 2 van de 5 pagina's
In winkelwagen1.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...
Voorbeeld 3 van de 20 pagina's
In winkelwagenDomain 
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 ...
Voorbeeld 3 van de 21 pagina's
In winkelwagenA 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...
Voorbeeld 2 van de 8 pagina's
In winkelwagenAssociative 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 ...
Voorbeeld 2 van de 6 pagina's
In winkelwagenAREA - -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...
Voorbeeld 1 van de 3 pagina's
In winkelwagenbinary 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...
Voorbeeld 1 van de 4 pagina's
In winkelwagenCREATE 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 ...
Voorbeeld 4 van de 33 pagina's
In winkelwagenAREA - -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...
Voorbeeld 2 van de 6 pagina's
In winkelwagenA 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 ...
Voorbeeld 2 van de 6 pagina's
In winkelwagendomain - -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...
Voorbeeld 2 van de 12 pagina's
In winkelwagenA 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 ...
Voorbeeld 1 van de 2 pagina's
In winkelwagenSyntax 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...
Voorbeeld 2 van de 8 pagina's
In winkelwagenA 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...
Voorbeeld 2 van de 14 pagina's
In winkelwagenAccess 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)
Voorbeeld 1 van de 2 pagina's
In winkelwagenAdd 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...
Voorbeeld 1 van de 3 pagina's
In winkelwagenCreate 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-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Preach. Stuvia faciliteert de betaling aan de verkoper.
Nee, je koopt alleen deze samenvatting voor $40.49. Je zit daarna nergens aan vast.
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 67474 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen