Problem

Medical License Management: The Florida Division of Medical Quality Assurance, a part of the Florida Department of Health, administers licensing for several medical professions including physicians, paramedics, registered nurses, massage therapists, etc. Initial applicants must provide different quantities and documentation of qualifications including passing licensing tests for most professions. While the qualifications for each field differ qualifications can be categorized with categories including, but not limited to, educational requirements, exams, letters of recommendation, documentation of experience, etc. Individuals apply for initial licensing or for renewal licensing. Individual licenses have differing levels of continuing education (CE) requirements and the requirements vary not only by type of license but sometimes by the time elapsed since the initial licensing. The Division maintains a list of authorized CE providers and the course-profession combinations the CE providers offer. The providers directly enter information on Florida professionals that successfully complete CE courses including the topic and hours of credit. Except for the CE credit, each element of both the initial application and renewal applications is verified by a DMQA staff member and when all requirements have been verified the license (whether initial or renewal) is issued. Do not consider any fee information in your modeling nor do you need to consider criminal background checks.Your deliverable is to be a single Visio drawing submitted . You will show

Each entity you identify as being needed by your scenarios.

Identifying necessary entities based on the scenario.

Identify entity primary keys.

Identifying relationships and relationship names.

Correctness of relationship cardinalities.

Direct relationships among the entities you discover.