Solve this questions 2 and 3 and check my answer for the second question

Hospital databases management system

2. Draw the appropriate ER/EER representation of your application. 3. Design the relational schema of your application based on your ER/EER representation. 4. Select a DBMS System (Oracle, Mysql, SQL Server, online SQL interpreters...) to create your relations schemas and populate them with at least 10 tuples for each relation. The website visitors should be able to search for hospital information using different options, Where The Hospital Database include: - The name of the hospital - The location of the hospital - The type of hospital (e.g. trauma centers, rehabilitation hospitals, children's hospitals) - Owner of the hospital Each employee in the hospital must have CPR, name, unique ID, Gender , DOB, Adress, Phone, Email, Qualifications . A doctor can manage multiple departments and a department is managed by a single doctor, A doctor can belong to multiple departments and a department can have multiple doctors, One nurse can assist multiple doctors, and each doctor can have multiple assisting nurses, One doctor can conduct multiple appointments and each appointment is conducted by a single doctor Once the visitor decides to make an appointment, the visitor should first register on the website using a CPR (will be used as username), password, name, Date of Birth, Ennail. Adress and telephone number. When the registration is completed The website should show for each serve: patient name, Date, Tima, Doctor name and unique appointment number. One patient can attend multiple appointments and each appointment is attended by a single patient and after the appointment the patient can login again and post any reviews on that appointment