Package deal
Bundle for WGU C170 Exams Compilation | Verified | Guaranteed Success
Bundle for WGU C170 Exams Compilation | Verified | Guaranteed Success
[Show more]Bundle for WGU C170 Exams Compilation | Verified | Guaranteed Success
[Show more]The practical significance of taking the logical view of a database is that it serves as a reminder 
of the simple file concept of data storage. - TRUE 
You can think of a table as a persistent representation of a logical relation. - TRUE 
The order of the rows and columns is important to the DBMS. ...
Preview 2 out of 10 pages
Add to cartThe practical significance of taking the logical view of a database is that it serves as a reminder 
of the simple file concept of data storage. - TRUE 
You can think of a table as a persistent representation of a logical relation. - TRUE 
The order of the rows and columns is important to the DBMS. ...
What is a table? - A table is a persistent representation of a logical relation that is a relation 
whose contents can be saved for permanent use. 
What are the characteristics of a relational table? - The characteristics of a relational table are 
that a table is perceived as a two-dimensional stru...
Preview 4 out of 44 pages
Add to cartWhat is a table? - A table is a persistent representation of a logical relation that is a relation 
whose contents can be saved for permanent use. 
What are the characteristics of a relational table? - The characteristics of a relational table are 
that a table is perceived as a two-dimensional stru...
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 ...
Preview 3 out of 26 pages
Add to cartA 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 ...
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 ...
Preview 4 out of 70 pages
Add to cartA 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 ...
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...
Preview 2 out of 8 pages
Add to cartAn 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...
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...
Preview 1 out of 3 pages
Add to cartIf 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...
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...
Preview 2 out of 7 pages
Add to cartA _____ 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...
C170: Data Management – Applications (MySQL) 
1A) 1NF 
RAW MySQL: 
CREATE TABLE Orders_1NF 
( 
OrderID INT NOT NULL AUTO_INCREMENT, 
DonutID INT NOT NULL, 
DonutName CHAR(75) NOT NULL, 
Description CHAR(255) NULL, 
UnitPrice DECIMAL(2,2) NULL, 
Quantity INT NOT NULL, 
OrderDate DATE NOT NULL, 
Spe...
Preview 2 out of 9 pages
Add to cartC170: Data Management – Applications (MySQL) 
1A) 1NF 
RAW MySQL: 
CREATE TABLE Orders_1NF 
( 
OrderID INT NOT NULL AUTO_INCREMENT, 
DonutID INT NOT NULL, 
DonutName CHAR(75) NOT NULL, 
Description CHAR(255) NULL, 
UnitPrice DECIMAL(2,2) NULL, 
Quantity INT NOT NULL, 
OrderDate DATE NOT NULL, 
Spe...
C170: Data Management - Applications 
1 
Data Management Project 
Part A Normalized Model 
1a First Normal Form 
Table Design 
CREATE TABLE [dbo].[Sales_1NF] 
( 
[SaleId] INT NOT NULL IDENTITY(1,1), 
[DonutId] INT NOT NULL, 
[Name] NVARCHAR(50) NOT NULL, 
[Description] NVARCHAR(250) NULL, 
[UnitPric...
Preview 2 out of 15 pages
Add to cartC170: Data Management - Applications 
1 
Data Management Project 
Part A Normalized Model 
1a First Normal Form 
Table Design 
CREATE TABLE [dbo].[Sales_1NF] 
( 
[SaleId] INT NOT NULL IDENTITY(1,1), 
[DonutId] INT NOT NULL, 
[Name] NVARCHAR(50) NOT NULL, 
[Description] NVARCHAR(250) NULL, 
[UnitPric...
WGU c170 The Most Important SQL Commands(SQL study guide)
Preview 2 out of 8 pages
Add to cartWGU c170 The Most Important SQL Commands(SQL study guide)
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller Tulloch. Stuvia facilitates payment to the seller.
No, you only buy these notes for $40.49. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
52510 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now