mis

Question 3 Data Table Design 1 (30 points) You are working for a hospital chain with multiple locations (e. 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. Youdanor 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 Identity the field name and the relevant data type feg. numericak, rext, alphanumerical dare, uurency. yesino) for each field. (1 point for each correct field name in each table +1 point for each correct data type in each tabie a 2+6+2 (cotal 24 points) b) Mark the primanykey for each table, (0.5 point for each table, total 1 points) 5) 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 tratitional file procesimgin FulL sentence (5 points)