For Expert help and assignment handling,
1
WGU C170 - Data Management Applications
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-
© 2026 Assignment Expert
to-many
Which two examples are attributes?Ans: An employee number; A
Guru01 - Stuvia
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
Refer to the given SQL statement.
CREATE TABLE member
(
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
, For Expert help and assignment handling,
2
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
email VARCHAR(100) NULL,
street VARCHAR(50) NULL,
© 2026 Assignment Expert
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
Guru01 - Stuvia
zip VARCHAR(10) NULL,
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL
);
Which two columns are created as something other than variable-length
strings in this statement?Ans: member_id; expiration
Employee_ID Employee_Name Office_Address
12342 Jacob 54123 Main Street
12346 Michael 354 Center Avenue
1
WGU C170 - Data Management Applications
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-
© 2026 Assignment Expert
to-many
Which two examples are attributes?Ans: An employee number; A
Guru01 - Stuvia
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
Refer to the given SQL statement.
CREATE TABLE member
(
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
, For Expert help and assignment handling,
2
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
email VARCHAR(100) NULL,
street VARCHAR(50) NULL,
© 2026 Assignment Expert
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
Guru01 - Stuvia
zip VARCHAR(10) NULL,
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL
);
Which two columns are created as something other than variable-length
strings in this statement?Ans: member_id; expiration
Employee_ID Employee_Name Office_Address
12342 Jacob 54123 Main Street
12346 Michael 354 Center Avenue
