Please the report has to be more than 2500 words

Scenario : Assume that you are assigned as a database designer for a Dental Appointment System for a local clinic located in the south of Malaysia. The clinic is planning to implement a database system in managing all their information. As of now, the clinic is still using the traditional system (manual filing) to manage their data. Therefore, as a database designer, you are required to propose a database design for the new system. In order to cope with data which is increasing day by day, you have decided to choose computer based approach over manual approach but unsure whether to adopt database or file based approaches. a) Appraise the effectiveness of database approach over file based approach. (whatever examples in the form of diagrams/words that are required in the answer MUST be done in the context of case study and relevant to the case study) b) Describe on the user and system scope that are related to the system. c) Based on the case study, explain the possible tables and its attributes that are required in a database for organization above. d) Then, convert all the identified table and attributes from (c) into Entity Relationship Diagram. Draw the diagram by clearly stating the relationships between entities, cardinalities and attributes with correct notation. (CLO2:PLO2:C4) (CLO2:PLO3:C4) Format: 1) Font: Times New Roman 12 with 1.5 spacing and justified. 2) Length of words: 2500 to 3000 words excluding references. DO NOT COPY the question and