(Top 2024/2025 EXAM REVIEW PAPERS / GRADED A+/ 100% Accurate)WGU - Pre-Assessment: Data Management - Applications (FJO1) (PFJO)

WGU - Pre-Assessment: Data Management - Applications (FJO1) (PFJO) 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? A person attending a meeting An employee number A sales meeting A meeting code - 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 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? - The delete is prohibited. 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, first_name VARCHAR(20) NOT NULL