In this post, we will see how to resolve Does a nullable foreign key always mean optional in ERD cardinality? Question: Suppose you have a ticket table and a status ticket. Below are their definitions: As you can see, the ...

Question: Cardinality aggregation query calculates an approximate count of distinct values. How we can calculate the cardinality distribution of documents? For example suppose we have: and distinct count distribution is: Answer: Actually you cannot do aggregations like this. But, using ...