Question

Consider the following tables PATIENT and TEST and answer the questions that follow :

                              Table : PATIENT

PCODE	NAME	PHONE	DTADMIT
6473	Amit Sharma	912356899	15-JUN-2017
7134	Rose Mathew	886744536	12-NOV-2017
8786	Tina Sharma Arora	889088765	06-DEC-2017
6477	Vijay Shah	714567445	07-DEC-2017
7658	Venkat Fazal	865545343	31-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 : TEST

TESTID	TESTNAME	COST
T101	Platelet Count	200.00
T102	Hemogram	190.00
T301	Malaria Detection	350.00
T502	Glucose Test	150.00

Name the Primary keys in both the tables and foreign key in 'PATIENT' table. 2 State the reason for your choice.

Answer 1

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