Please draw me the required relationships in the following text :

The Entity-Relationship (ER) diagram for the company database can be represented as follows: [Patients] 1-----* [Appointments] | * [Doctors] 1-----1 [Clinics] Where: [Patients] represents the patients table, which stores information about each patient. [Doctors] represents the doctors table, which stores information about each doctor. [Clinics] represents the clinics table, which stores information about each clinic. [Appointments] represents the appointments table, which stores information about each appointment, including the patient, doctor, and clinic involved. The relationships are as follows: One patient can have multiple appointments (1-----*). A doctor can work in one clinic only (1-----1). An appointment involves one patient, one doctor, and one clinic (*-----1). Note: The diagram is a visual representation of the database structure and relationships between tables. It helps to understand the database structure and design decisions.

and

. Logical schema design mapping: Map the conceptual design to a logical schema design, i.e. create tables for each entity and represent the relationships as foreign keys. Determine the data types for each attribute, i.e. patient ID as a number, name as a VARCHAR, etc. A logical schema design is the design of the data structure and relationships in a database, independent of any specific database management system or physical implementation. In the code provided, the logical schema design can be represented as follows: Patients: patient_id (Primary Key) name address phone_number Doctors: doctor_id (Primary Key) name specialty years_of_experience Clinics: clinic_id (Primary Key) name address phone_number Appointments: appointment_id (Primary Key) patient_id (Foreign Key, references patients(patient_id)) doctor_id (Foreign Key, references doctors(doctor_id)) clinic_id (Foreign Key, references clinics(clinic_id)) appointment_date This design maps the relationships between the tables and the constraints on the data in the tables.