Changes between Version 2 and Version 3 of ERModel

Timestamp:

08/27/26 23:18:15 (5 days ago)

Author:

181201

Comment:

--

ERModel

@@ -2 +2 @@
 
 == Diagram
-[[Image(ERModel_v02.png)]]
+[[Image(ERModel_v03.png)]]
 
 == Entities
@@ -116 +116 @@
 {{{Booking}}}
 
-The entity that connects {{{PetOwner}}}, {{{PetSitter}}}, {{{Pet}}} and the services requested for the {{{Pet}}}
+The entity that connects {{{PetOwner}}}, {{{PetSitter}}}, {{{Pet}}} and the service requested for the {{{Pet}}}
 
 '''Candidate keys:'''
@@ -245 +245 @@
 
 {{{requires - Booking to Service}}}
-* M:N relation
-* a {{{Booking}}} can require multiple services (Walking, Overnight stay) and a specific {{{Service}}} type can be requested in many different bookings.
+* N:1 relation
+* each {{{Booking}}} requires exactly one {{{Service}}} (for example Overnight stay), and a specific {{{Service}}} type can be requested in many different bookings.
 * Total participation on Booking, Partial participation on Service
 
@@ -261 +261 @@
 * Initial version
 
-[https://develop.finki.ukim.mk/projects/petsitter/wiki/ERModel v02]
-* Current version
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/ERModel_v02 v02]
 * 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}}}
+
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/ERModel v03]
+* Current version
+* Changed the '''requires''' relation between {{{Booking}}} and {{{Service}}} from M:N to N:1; each {{{Booking}}} now requires exactly one {{{Service}}}