Now that we have completed, at least for now, the logical design model for EAB Healthcare, we can move forward to the database design model and create a database design for the MDS in the UML. First it is important to understand the UML Profile for Database Design (see the ?a href="0201721635_snode56.html">Concepts?section in this chapter). The Profile uses stereotypes and tagged values for all the information needed to describe the structures of the database and its elements. The Profile also uses constraints to enforce database design conformance. This includes many-to-many relationships not allowed on the database design, limiting them to the logical design.
EAB takes care of many residents, and since many of those residents receive government aid like Medicare and Medicaid, it is very important to keep a good record of all information on patients. If the residents' records are not well organized and easily queried, the government can fine EAB or even shut down the company. EAB's records are often scrutinized, so the creation of this new system will help satisfy many of the government's needs and protect EAB in the future.