one row in the pat_enc table represents one patient encounter. one row in the order_med table represents one medication order. one patient encounter can have many medication orders but one medication order can only have one patient encounter. In other words, the cardinality of this pat_enc to order_med relationship is one to many.

you start a query with order_med. You then add pay_enc using an inner join. What is true about the granularity of the result set before and after adding the pat_enc table?

A. The granularity stays at one row per patient encounter. B. The granularity stays at one row per medication order. C. The granularity changes from one row per patient encounter to one row per medication order to an encounter. D. The granularity changes from one row per medication order to one row per patient encounter.