Question

Consider the following table and answer the questions that follow:

TABLE : PATIENT

DATE_ADMIN

2011-10-11

2011-10-11

2011-10-17

2011-11-22

NAME

Mrs. Vimla Jain

Miss Ishita Kohli

Mr. Vijay Verma

Mr. Vijay Verma

P_NO

PO001

PO012

P1002

P1567

2

DOC_NO

D201

D506

D201

D233

a) Mention the suitable data type for storing the "Name" and "Date_Admin" details.

b) Display the patient's name, date of admission and doctor no. for Mr. Vijay Verma.​

Answer 1

Answer:

dfcghhhhvvbnnb. cvvbnbb