Develop an entity relationship diagram based on the provided information and following the steps below: A small medical clinic needs a relational database for its medical practice. The database needs to follow the

business rules and requirements:

$$ Database needs to store data about patients, doctors, and their appointments. Although a patient can make many appointments and a doctor can have many appointments, each

appointment is made with only one doctor and one patient at a time.

$$ An appointment yields a visit with the doctor. Database needs to store data about these visits.

$$ After each patient visit, an invoice is generated. Database needs to store data about these invoices. $$ A patient pays invoices and database needs to store data about these payments. A patient pays each

invoice in one or more payments; each payment is associated with one invoice.

Steps: $1.$ Identify necessary entities, relevant attributes of the entities, and relationships between entities in this database. Then put these together to create an ER diagram. Besides the primary key columns, and foreign key columns $($as needed$),$ please be sure that the following attributes are also included in appropriate entities in

your ER diagram: Names of doctors and patients along with their phone numbers; appointment date and time; visit date and visit

time; date and amount of invoice; date and amount of payment received; and any other necessary attributes.

$2.$ Resize each entity and make sure that all of the attributes in it are visible.

$3.$ Add a text box next to your diagram and display your full name $($First$-$name Last$-$name$)$ in it$.$

Using Lucid Chart