WGU C170 (WGUC170)

VHT2 – VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN A. Construct a normalized physical database model to represent the ordering process for Nora’s Bagel Bin by doing the following: 1. Complete the second normal form (2NF) section of the attached “Nora’s Bagel Bin Database Blueprints” document by doing the following: a. Assign each attribute from the 1NF table into the correct 2NF table. b. Describe the relationship between the two pairs of 2NF tables by indicating their cardin...

WGU C170 Chapter 5. Exam Review, Rated A+. VERIFIED. 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 st...

WGU - C170 - Data Management Applications. Questions and answers, rated A+. Verified. 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, comment, rename What commands are used with data manipulation? - -Select, Insert, Update, Delete, Merge, Call...

WGU Data Management - Applications - C170 OA GSA1. Rated A+. VERIFIED. 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 cond...

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