I read all threats about multiple relations on the forum. but I did not find answer my question.
I want to design a petition database,
entities;
"user" & "petition"
relations;
1) compose: "users can compose several petitions. every petition must belong to one user"
2) sign: "users can sign any petition for one time. a petition can include several user sign"
I do something but I feel there is something wrong... (you can see it attached image)
my questions;
1) how must be the tables and relations in this case?
2) do you know complete example about petition database?
If you could guide me, I will be very happy
sorry for my bad english.
thank you