Database design and optimization

Database design and optimization

Create a Microsoft Access Database that can answer these 6 questions. The rubric and requirements have been attached. The ERD and data dictionary has been attached, use that as the basis for the design.
Which states prescribe the most opioid medications?
What states have higher mortality rates due to opioid use?
Which demographic is more likely to be prescribed opioids?
Does the type of ailment correlate with an increased likelihood of an opioid overdose?
What type of opioids (OxyContin, etc.) are being prescribed most often?