A dentist office needs a database to keep information about patients $($name$,$ DOB, address, billing address$),$ their visits to the office $($including dates$),$ the procedures that is performed during each visit, associated charges, and payments $($including payment date and method$).$ There is a standard set of procedures that the office performs with set charges. You can assume that the office has a single dentist, so no need to store information about the dentist.

$1)$ Identify a set of entities to model this database

$2)$ Identify a set of attributes for each entity.

$3)$ Identify a primary key for each entity

$4)$ Identify relationships between the entities, and any additional attributes of these relations

$5)$ Specify the degree, cardinality, and participation of each relationship. Explain your logic.

$6)$ Explain how will you incorporate each of the relationships inside your ER model.

For example:

$-$ Relation $\backslash ($ X $\backslash )$ will be incorporated by including the primary key of entity $\backslash ($ A $\backslash )$ as a foreign key in entity Y $.$

$-$ Relation $\backslash ($ X $\backslash )$ will be incorporated by creating a bridge entity to represented

$7)$ Draw an ER diagram representing the model you designed in $1$ through $6$