Data Model: For the proposed database problem, create a detailed class diagram using Lucidchart.com. Upload that diagram as a PDF.
There should be at least 3 classes, and at a minimum, each class diagram should have the following:
4 attributes clearly defined
Identify the primary candidate key
If the class is related to another class, identify the candidate foreign key
Cardinality relationship to another class
There
should be at least 3 relationships and the related classes should have a
name for the relationship as well as cardinality/multiplicity
identified. (for example, Patient is treated by Doctor (1..n) where “is
treated by” is the name of the relationship).
Relationships should be identified from one of the following
1-to-Many
Many-to-Many
1-to-1
Written Summary: Describe the purpose of each of your classes, along with their
attributes. For each relationship, describe why that relationship is
important and makes sense for your proposed system, and give rationale
for the cardinality and multiplicities of the relationship.
You can submit a Word document or text file.
