CSA · Question #137
Tables may have a One to Many relationships. From the Service Catalog, what are examples of tables having a one to many relationships? (Choose three.)
The correct answer is B. One Request can have many Requested Items D. One Requested Item can have many Catalog Tasks E. One Cart can have many Requests. In the Service Catalog, common one-to-many relationships include a single Request having multiple Requested Items, a single Requested Item leading to multiple Catalog Tasks, and conceptually, a single user's cart containing multiple requests.
Question
Tables may have a One to Many relationships. From the Service Catalog, what are examples of tables having a one to many relationships? (Choose three.)
Options
- AOne Approval can have many Requests
- BOne Request can have many Requested Items
- COne Requested Item can have many Approvals
- DOne Requested Item can have many Catalog Tasks
- EOne Cart can have many Requests
How the community answered
(59 responses)- A3% (2)
- B95% (56)
- C2% (1)
Why each option
In the Service Catalog, common one-to-many relationships include a single Request having multiple Requested Items, a single Requested Item leading to multiple Catalog Tasks, and conceptually, a single user's cart containing multiple requests.
The relationship is typically the reverse: one Request can have many Approvals, not that one Approval can span many unrelated requests.
One Request (sc_request) can contain many Requested Items (sc_req_item), where each item represents a distinct product or service ordered within that request.
The relationship is usually the reverse: one Requested Item can generate many Approvals, as multiple approvals may be needed for a single item.
One Requested Item (sc_req_item) can generate many Catalog Tasks (sc_task), as multiple steps or assignments may be required to fulfill a single requested item.
One Cart (sc_cart) can conceptually result in many Requests (sc_request), especially if a user's shopping session or checkout process is structured to create distinct requests from a single cart instance.
Concept tested: Service Catalog table relationships (one-to-many)
Source: https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/service-catalog/concept/c_ServiceCatalogArchitecture.html
Topics
Community Discussion
No community discussion yet for this question.