WGU Course C170 - Data Management (Applications) with complete solution guide

WGU Course C170 - Data Management (Applications) with complete solution guide 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? A One-to-one B One-to-many C One-to-one binary D Many-to-many Correct Answer- D Which kind of relationship is displayed in this entity-relationship diagram? A Many-to-many unary B Many-to-many binary C One-to-one unary D One-to-one binary Correct Answer- A Which kind of relationship is displayed in this entity-relationship diagram? A Binary many-to-many B Unary one-to-one C Ternary many-to-many D Ternary one-to-one D Unary many-to-many E Binary one-to-one Correct Answer- B How is this portion of the entity-relationship diagram read, from left to right?A At least one book was written by an author. B Only one book was written by one author. C No books are written by an author. D One book was written by more than one author. Correct Answer- A Which two examples are attributes? Choose 2 answers 1 A meeting code 2 A person attending a meeting 3 An employee number 4 A sales meeting A 1,3 B 2,4 Correct Answer- A 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 Restrict B Cascade C Matching D Set-to-Null Correct Answer- D 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? A The delete occurs immediately. B The lack of a salesperson is flagged for later. C A new salesperson is assigned instead. D The delete is prohibited. Correct Answer- D Refer to the given SQL statement. CREATE TABLE member(member_idINT UNSIGNED NOT NULL AUTO_INCREMENT,PRIMARY KEY (member_id),last_nameVARCHAR(20) NOT NULL,first_nameVARCHAR(20) NOT NULL,suffixVARCHAR(5) NULL,expirationDATE NULL,emailVARCHAR(100) NULL,streetVARCHAR(50) NULL,cityVARCHAR(50) NULL,stateVARCHAR(2) NULL,zipVARCHAR(10) NULL,phoneVARCHAR(20) NULL,interestsVARCHAR(255) NULL); Which two columns are created as something other than variable-length strings in this statement? Choose 2 answers 1 member_id 2 expiration 3 suffix 4 email 5 last name 6 city A 1,2 B 3,4 Correct Answer- A