Consider the following tables PATIENT and TEST and answer the question

1.	Consider the following tables PATIENT and TEST and answer the questions that follow : Table : PATIENTPCODENAMEPHONEDTADMIT6473Amit Sharma91235689915-JUN-20177134Rose Mathew88674453612-NOV-20178786Tina Sharma Arora88908876506-DEC-20176477Vijay Shah71456744507-DEC-20177658Venkat Fazal86554534331-DEC-2017 Note : NAME holds the Names of patients. DTADMIT holds Dates on which a patient was admitted to hospital. TESTID holds Ids of Medical tests done on patients. Table : TESTTESTIDTESTNAMECOSTT101Platelet Count200.00T102Hemogram190.00T301Malaria Detection350.00T502Glucose Test150.00Name the Primary keys in both the tables and foreign key in 'PATIENT' table. 2 State the reason for your choice.
Answer» Primary key (Table : PATIENT ) - PCODE as it is unique to each row of table Primary key (Table : TEST ) – TESTID as it is unique to each row of table Foreign key in table PATIENT : TESTID as it links the two tables and is Primary key in table TEST

Consider the following tables PATIENT and TEST and answer the questions that follow : Table : PATIENTPCODENAMEPHONEDTADMIT6473Amit Sharma91235689915-JUN-20177134Rose Mathew88674453612-NOV-20178786Tina Sharma Arora88908876506-DEC-20176477Vijay Shah71456744507-DEC-20177658Venkat Fazal86554534331-DEC-2017 Note : NAME holds the Names of patients. DTADMIT holds Dates on which a patient was admitted to hospital. TESTID holds Ids of Medical tests done on patients. Table : TESTTESTIDTESTNAMECOSTT101Platelet Count200.00T102Hemogram190.00T301Malaria Detection350.00T502Glucose Test150.00Name the Primary keys in both the tables and foreign key in 'PATIENT' table. 2 State the reason for your choice.

Answer»

Primary key (Table : PATIENT ) - PCODE as it is unique to each row of table

Primary key (Table : TEST ) – TESTID as it is unique to each row of table

Foreign key in table PATIENT : TESTID as it links the two tables and is Primary key in table TEST