Question 3 Data Table Design 1 (30 points)

You are working for a hospital chain with multiple locations (e.g. Acibadem) in Turkey.

You are asked to develop a database that captures the data about patients and physicians. Design the tables PHYSICIAN and PATIENT individually. You do not need to enter data in the tables. You do not need to relate these two tables.

a) Each table has to contain at least relevant 6 fields. Identify the field name and the relevant data type (e.g. numerical, text, alphanumerical, date, currency, yes/no) for each field. (1 point for each correct field name in each table + 1 point for each correct data type in each table = 2 * 6 * 2 (total 24 points)

b) Mark the primary key for each table. (0.5 point for each table, total 1 points)

c) Explain why it is NOT effective and efficient to store these data for this type of hospital in an Excel sheet? (Hint: the problems with traditional file processing) in FULL sentence (5 points)