WGU C170 (WGUC170)

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 member_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (member_id), last_name VARCHAR(20) NOT...

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 VIEW <name> AS SELECT <columnname> CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes> FROM <tablename> Syntax to create an Index - -CREAT...

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 composed of more than one attribute. derived attribute - -An attrib...

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 existing tables (relations) to produce new relations. composite entity - -An...

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 attending a meeting An employee number A sales meeting A meeting code - -An employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matchi...

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 index - -An ordered data structure organized as an upside-down tree. bitmap index - -...

WGU Course C170 - Data Management (Applications) Quizlet by Brian MacFarlane. Questions and answers, 100% Accurate. Latest Updates. 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 ...

Nora’s Bagel Bin Database Blueprints (continued) Final Physical Database Model • Fill in the table names, attribute name, and table relationship cardinalities using the values from your completed 3NF diagram. o Rename any fields that have unusable database characters, like spaces (e.g., change “First Name” to first_name or firstname.) • Assign one of the following five data types to each attribute: CHAR(), VARCHAR(), TIMESTAM...

WGU Course C170 - Data Management Applications with complete solution guide