Model Cumulative Booking Metrics and First and Last Booking Times

Suppose every booking record contains a unique, immutable booking identifier, an account identifier, and a booking event time. For each account, reporting must provide the cumulative number of bookings as it changes over time, the earliest booking timestamp, and the latest booking timestamp. Treat these as the only required entity and metric grains; do not add extra booking attributes or business policies. State the grain of the booking fact table and any derived or summary…