WGU C170 (WGUC170)

WGU C170 DATABASE MANAGEMENT APPLICATIONS LABS. CREATE MYSQL CONNECTION You are required to take the following steps to accomplish the task: 1. On the MySQL Workbench Home window, click the [+] icon next to MySQL Connections. This opens the Setup New Connection wizard. 2. Define the Connection Name value as MyFirstConnection. 3. Ensure that Connection Method is set as Standard (TCP/IP). 4. Click the OK button to create the new MySQL connection. LAB 4 - CREATE DB ‘NAME’ You are requir...

Second Normal Form (2NF) Bagel ID • Separate the data that depend on just one of the two parts of the primary key into separate tables. • Keep any columns in the original table (now named "Bagel Order Line Item") that still depend on both parts of the original primary key. • Fill in each shaded cell within the tables with an attribute from the 1NF blueprint in the previous section. • Fill in the dotted cells between the tables with the cardinality o...

domain correct answer: In data modeling, the construct used to organize and describe an attribute's set of possible values superkey correct answer: An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key correct answer: A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey entity integrity correct answer: The property of a relational table that guarantees ea...

Domain Correct Answer: In data modeling, the construct used to organize and describe an attribute's set of possible values. Primary key (PK) Correct Answer: 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 Correct Answer: One or more attributes that determine other attributes. Determination Correct Answer: The role of a key. In the context of a database table, the s...

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? Correct Answer: Many-to-many Which two examples are attributes? A person attending a meeting An employee number A sales meeting A meeting code Correct Answer: 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...

A _____ key can be described as a minimal superky, a superkey without any unnecessary attributes. - candidate The _____ relationship should be rare in any relational database design. - 1:1 A _____ is a key that can uniquely identify any row in the table. - superkey Rows are sometimes referred to as _____. - records Date attributes contain calendar dates stored in a special format known as the _____ date format. - Julian A(n) _____ links tables on the basis of an equality condition that co...

If integer values are relatively small, what should be used instead of INT? - SMALLINT What is the SQL command that allows a user to list the contents of a table? - SELECT What is the process the DBMS uses to verify that only registered users access the database? - Authentication What command is used to list the contents of a table? - SELECT T/F ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause - True Some RDBMSs automatically make the necessary co...

An entity is said to be X -dependent if it can exist in the database only when it is associated with another related entity occurrence. - existence A table that has all key attributes defined has no repeating groups and all its attributes are dependent on the primary key is said to be in X. - 1nf A determinant is any attribute whose value determines other values within a column. - F X is a process that is used for changing attributes to entities. - Normalization Any attribute whose value d...

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