Utilizing the ideas from parts of your proposed Database Design Proposal and other associated assignments, consider the following scenario: An academic researcher wants to conduct a study on the distribution of various medications over the past 10 years.
1) What steps are required before the researcher can obtain any data?
2) What would be the applicable policy and regulations based on the module lecture notes and other knowledge of data security?
3) What will constitute your plan on how to provide the necessary data to the researcher-which pieces of information can and cannot be provided?
4) Explore and weigh options on providing restricted access to the database directly to the researcher (specify the necessary SQL statements to establish database accounts, configure privileges, and create restricted views of the data) versus exporting the required data.
Summarize your answers to these questions and post it into the Discussion Forum. Compare your ideas with those of your colleagues.