**Core Concept**
The question is testing the student's knowledge of the relative potency of different opioids, specifically their narcotic potential. Narcotic potency is a measure of an opioid's ability to produce analgesia, respiratory depression, and other effects associated with opioid use. The correct answer will be the opioid with the lowest narcotic potency.

**Why the Correct Answer is Right**
Among the options, **Tramadol** is the least narcotic opioid. Tramadol works by inhibiting the reuptake of norepinephrine and serotonin, as well as weakly binding to opioid receptors. Its mechanism of action is distinct from that of other opioids, which primarily act by binding to mu-opioid receptors. This difference in mechanism contributes to tramadol's lower narcotic potency compared to other opioids.

**Why Each Wrong Option is Incorrect**
* **Option A:** Morphine is a potent opioid that primarily acts by binding to mu-opioid receptors, producing significant analgesia and respiratory depression. Its high narcotic potency makes it a more effective, but also more dangerous, opioid.
* **Option B:** Fentanyl is a highly potent opioid, often used in palliative care for its rapid onset and short duration of action. Its high narcotic potency makes it a significant risk for overdose and respiratory depression.
* **Option C:** Codeine is a moderately potent opioid, primarily metabolized to morphine in the body. Its narcotic potency is higher than tramadol's but lower than that of morphine and fentanyl.

**Clinical Pearl / High-Yield Fact**
When choosing opioids for pain management, it's essential to consider the patient's medical history, potential for abuse, and the risk of respiratory depression. Tramadol's unique mechanism of action and lower narcotic potency make it a useful option for patients who require analgesia without the high risk of opioid-related side effects.

**Correct Answer:** D. Tramadol