1
For Expert help and assignment solutions, +254707240657
WGU C170 Questions and Answers (100%
Correct Answers) Already Graded 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? —
ANS: Many-to-many
© 2025 Assignment Expert
Which kind of relationship is displayed in this entity-relationship
diagram? —ANS: Many-to-many unary
Which kind of relationship is displayed in this entity-relationship
Guru01 - Stuvia
diagram? —ANS: Unary one-to-one
How is this portion of the entity-relationship diagram read, from left
to right? —ANS: At least one book was written by an author.
Which two examples are attributes?
Choose 2 answers —ANS: 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?
—ANS: Set-to-Null
In this entity-relationship diagram, Salesperson 361 is related to two
customers. The table follows the restrict delete rule.
What happens if someone tries to delete Salesperson 361 from the
customer records? —ANS: The delete is prohibited.
Refer to the given SQL statement.
, 2
For Expert help and assignment solutions, +254707240657
CREATE TABLE member
(
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,email VARCHAR(100) NULL,
street VARCHAR(50) NULL,
© 2025 Assignment Expert
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
zip VARCHAR(10) NULL,
Guru01 - Stuvia
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL);
Which two columns are created as something other than variable-
length strings in this statement?
Choose 2 answers —ANS: member_id
expiration
Employee_IDEmployee_NameOffice_Address
12342 Jacob 54123 Main Street
12346. Michael. 354 Center Avenue
12846. Ethan. 54123 Main Street
12887. Joshua. 54123 Main Street
12894. Daniel. 354 Center Avenue
13097. Alexander. 354 Center Avenue
For Expert help and assignment solutions, +254707240657
WGU C170 Questions and Answers (100%
Correct Answers) Already Graded 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? —
ANS: Many-to-many
© 2025 Assignment Expert
Which kind of relationship is displayed in this entity-relationship
diagram? —ANS: Many-to-many unary
Which kind of relationship is displayed in this entity-relationship
Guru01 - Stuvia
diagram? —ANS: Unary one-to-one
How is this portion of the entity-relationship diagram read, from left
to right? —ANS: At least one book was written by an author.
Which two examples are attributes?
Choose 2 answers —ANS: 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?
—ANS: Set-to-Null
In this entity-relationship diagram, Salesperson 361 is related to two
customers. The table follows the restrict delete rule.
What happens if someone tries to delete Salesperson 361 from the
customer records? —ANS: The delete is prohibited.
Refer to the given SQL statement.
, 2
For Expert help and assignment solutions, +254707240657
CREATE TABLE member
(
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,email VARCHAR(100) NULL,
street VARCHAR(50) NULL,
© 2025 Assignment Expert
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
zip VARCHAR(10) NULL,
Guru01 - Stuvia
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL);
Which two columns are created as something other than variable-
length strings in this statement?
Choose 2 answers —ANS: member_id
expiration
Employee_IDEmployee_NameOffice_Address
12342 Jacob 54123 Main Street
12346. Michael. 354 Center Avenue
12846. Ethan. 54123 Main Street
12887. Joshua. 54123 Main Street
12894. Daniel. 354 Center Avenue
13097. Alexander. 354 Center Avenue
