using SQL sever finish this question

Submission: Develop a detailed ER diagram based on one of the following for the case study described below: You can use software or by hand (scan to submit CASE Study: Prescription Drugs order System at REpharmacy chain. x pharmacy is developing an online software to fulfill prescriptions or to access related information to listed doctors, phanmacies, insurance carriers, and patients. Also, pharmaceutical companies (who make the drugs) can manage some of their data and their medications information on this software. Initial list of the software requirements: Allow patients access to the system Patients can access the system to lockup prices of medications, update their insurance information, check on the availability of generic medications, request refilling orders, see if their refill is ready for pick up, and print their purchase history or copies of individual receipts of medications they have previously bought. Pharmacy Management System Pharmacies can update the prices of individual medications, manage (add delete/modify) doctors and patients information, and manage information on phamaceutical companies, medications, and insurance carriers. Manage discount types, and customer account information (e.g., reset user access and logins to the system.) Pharmaceutical companies Pharmaceutical companies can manage some of their data and their medications information, print reports of the inventory level at individual pharmacies to supply them with additional inventories based on an agreed on inventory baseline level. Manage current and future medication availability and other information. Insurance carriers Insurance carriers can manage some of their data, view medications and pharmaceutical companies' basic information, view current and historical information ofprescriptions that pertains to their companies Prescription Management Doctors can update some of their data, submit new prescriptions, and view the status of filled prescriptions