Tag Info

New answers tagged

1

I am aware that it has been some time since the OP asked this question, but I hope this answer can be useful for other seekers with a similar problem. If I understand the situation well, the part of the scenario that you are confused with is an example of what is called (super)type-subtype1 relationship. Context This kind of relationship shows up when, in ...


0

I actually think your diagram is good for your rule. The only thing is that with the relationship line connecting "Cash Accountability" and "Cashier", I would remove the circle on the Cashier side, to indicate that a "Cash Accountability" has to have exactly one Cashier. So as it is now, the relationship states that a cashier cashes out many times in a ...


0

I think there would need to be a MemberPhone table, since the description mentions storing multiple phones per member I would create tables to store the possible values for for BicycleMake, Bicycle (which contains an attribute linking to a model), BicycleColor, and BicycleSize. Given these tables, there wouldn't need to be a reference to the BicycleMake in ...


0

A Google of "open source subscription software rent a bike" gives a number of interesting results, including this one. You can take and adapt ideas from some of these programmes - the beauty of Open Source. [EDIT in response to @evilcube]. Well, the pointer to Open Source software was so that the poster could download the software and then formulate their ...



Top 50 recent answers are included