I need someone 2 help me drawing the ER diagram for this scenario :(
Draw an ER Model and the corresponding relational model (logical model) for the following problem.
StrongTEETH4U is a private dental clinic that is well known and has an excellent reputation in the area. All patients in the clinic have their details stored in a ClinicBook database. This database is used by the dentists and secretaries in the clinic to contact the patients for their routine checking and remind them of their appointment dates. A patient has a patient number (a unique value), first name, surname, house/flat number, street, city, P.O. Box, telephone number, a first admission date to the clinic, the date of next appointment (if any!), and the dentist ID that has treated the patient. Patients have to register when they first attend by calling in to the clinic and provide a secretary with their details. Patients have to have appointments created for them by dentists and secretaries in the clinic before they can be seen or treated, and the date of the appointment along with the other required details is stored into the ClinicBook database. Doctors have an ID, first name, surname and specialism e.g. teeth implant.