You have just been employed as a database designer at SOFTLOGIC, a well$-$established software development firm. Your first job is to design and implement a database system for MEDI$-$CINE, a Medical Centre in Melbourne. Following the data$-$gathering process and the analysis of the current practices of MEDI$-$CINE, the following activities around their business practice have been identified. $$ The system records information about the doctor$$s work at the medical centre. Doctors have unique registration numbers. In addition to the registration number for each doctor, the system records the name, date of birth, gender, qualifications, and specialisations. Doctors can have multiple qualifications and multiple specialisations. $$ The system keeps a record of each patient. When a new patient comes to the medical centre, the patient is given a registration form to be filled. The information gathered in this form will be stored in the system. When this information is entered into the system, a serial number is assigned to each patient. The registration form captures the following information: name, address, date of birth, gender, telephone numbers $($multiple numbers are allowed$),$ Medicare number $($if any$),$ private health cover number $($if any$),$ and private health cover company $($if any$).$ When a patient attends a consultation with a doctor, the following information is recorded: consultation number, date, time, description, symptoms, and special remarks. Symptoms are a multi$-$ valuedattribute. $$ A number of prescriptions can be recommended after each consultation. For each prescription, the following information is recorded: name of the medicine, dosage, number of repeats, and special instructions. None of these attributes are unique. However, for a given consultation, medicine is prescribed only once.