please solve the question the relation in ER between Doctor and patient Focusing on all requirements ASAP

On this assignment you are required to think about a system that would need a database to store its data. - Write a scenario explaining the data the database will store - Convert this scenario to ER diagram - Create a database in MS.Access based on the result of the ER diagram, with relationship and 2 queries which are beneficial to your system. Make sure you would have the following: - Two entities - Each entity will have up to 4 attributes of different data types - Use field properties such as required and field size - The relationship will be either 1:M or M:1 - The tables in access should have 4 rows explaining the relationship clearly - Write two different queries, one will show input message, the other query without input message. - Make a screen shot of how you create the relationship in MS. Access - You should submit 3 files word file + pdf file + access file (.accdb)