Drugwarehouse. com has offered you a free life-time supply of prescription drugs (no questions asked) if you design its database schema. given the rising cost of health care, you agree. here is the information that you gathered:
• patients are identified by their ssn, and we also store their names and age.
• doctors are identified by their ssn, and we also store their names and specialty.
• each patient has one primary care physician, and we want to know since when the patient has been with her primary care physician.
• each doctor has at least one patient.
a) draw an er diagram that captures the above information
b) write the ddls for the er diagram you have drawn. include primary and foreign key constraints. you may assume any reasonable data types.