Name the primary key and foreign key for each of the 3 following tables (6 ANSWERS):

TABLE 1: DOCTOR (Doc_ID, NAME, SPECIALTY, AGE) Doc_ID is doctors ID NAME is Doctor name SPECILATY is Doctors specilaty AGE is Doctors age

TABLE 2: PATIENT (PID, P_NAME, P_Address, P_INS, ins_address) PID is Patients ID P_NAME is Patients name P_ADDRESS is Patients address P_INS is Patients insurance company INS_ADDRESS is the address of insurance company

TABLE 3: APPOINTMENT( App_I, PID, DID, t_ID, t_Desc, charges, d_treatment) App_I is the appointment ID PID is patients ID Doc_ID is doctors ID t_ID is the treatment code t_desc is treatment description charges is the amount charged for that service d_treatment is the date of treatment