WGU - PRE-ASSESSMENT: DATA MANAGEMENT - APPLICATIONS (FJO1) (PFJO) EXAM 2024
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?Answer - Many-to-many Which two examples are attributes? A person attending a meeting An employee number A sales meeting A meeting codeAnswer - 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?Answer - 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?Answer - The delete is prohibited. Refer to the
Document information
- Uploaded on
- February 7, 2024
- Number of pages
- 11
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers