WGU C170 Bundled Exams with Complete Solution | Verified | Everything you Need!!

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...

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...

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 ...

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...

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 ...

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...

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...

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 ...

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...

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 ...

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...

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 ...

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...

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...