Changes between Version 7 and Version 8 of ConceptualModel

Timestamp:

05/05/26 20:25:00 (2 days ago)

Author:

181201

Comment:

--

ConceptualModel

@@ -1 @@
-= ERModel v01
+= ERModel v02
 
 == Diagram
-[[Image(ERModel_v01.jpg)]]
+[[Image(ERModel_v02.jpg)]]
 
 == Entities
@@ -87 +87 @@
 * {{{age}}} - Numeric (Required, non-negative integer).
 
-* {{{password}}} - Text (Required, Hashed format, Min. 8 characters).
-
 * {{{special_needs}}} - Text (Optional).
 
@@ -100 +98 @@
 
 '''Candidate keys:'''
-* {{{pet_id}}} - '''Primary key'''; Unique surrogate key.
+* {{{pettype_id}}} - '''Primary key'''; Unique surrogate key.
 * {{{species}}} - Unique but not as efficient as a numeric id key.
 
@@ -139 +137 @@
 {{{Review}}}
 
-The feedback that the {{{PetOwner}}} leaves for the {{{PetSitter}}} after a completed {{{Booking}}}. This is mandatory to maintain trust and establish quality on the platform. 
+The feedback that the {{{PetOwner}}} leaves for the {{{PetSitter}}} after a completed {{{Booking}}}. This is optional but it helps maintain trust and establish quality on the platform. 
 
 '''Candidate keys:'''
@@ -195 +193 @@
 ----
 
-{{{leaves - PetOwner to Review}}}
+{{{owns - PetOwner to Pet}}}
 * 1:N relation 
-* one {{{PetOwner}}} can leave many reviews to sitters, but each {{{Review}}} has one unique owner.
-
-----
-
-{{{receives - Review to PetSitter}}}
-* 1:N relation
-* one {{{PetSitter}}} can receive many reviews from clients, but each {{{Review}}} is meant for one unique {{{PetSitter}}}.
+* one {{{PetOwner}}} can register multiple pets, but each {{{Pet}}} belongs to one owner.
+
+----
+
+{{{produces - Booking to Review}}}
+* 1:1 relation
+* one {{{Booking}}} produces max. one {{{Review}}} from a client.
 
 
@@ -247 +245 @@
 * 1:1 relation
 * each {{{Booking}}} has exactly one {{{Payment}}} record, and each {{{Payment}}} record is associated with exactly one {{{Booking}}}
+
+== Version history
+
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/ConceptualModel_v01 v01]
+* Initial version
+
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/ConceptualModel v02]
+* Current version
+* Added '''owns''' relation  between {{{PetOwner}}} and {{{Pet}}}; so each pet can be assigned to an owner
+* Added '''produces''' relation  between {{{Booking}}} and {{{Review}}}; so each review can be associated directly with only a booking
+* Removed redundant '''leaves''' relation between {{{PetOwner}}} and {{{Review}}} 
+* Removed redundant '''receives''' relation between {{{PetSitter}}} and {{{Review}}}