1
vote
1answer
353 views

How to model entities in an entity relationship diagram?

I'm a beginner Database designer and wondering if anyone can help me understand this. Let's say we want to design a system that has, among other entities, an entity called Vehicle, and another one ...
0
votes
1answer
431 views

How do I persist recurring events?

I've been tasked with designing a system to recur events. Events may recur daily, hourly, monthly or yearly. Users should be able to schedule events "every 3rd Wednesday of the month" or "The 1st of ...
0
votes
0answers
492 views

ER to Relational Schema [closed]

I have developed an ERD diagram with UML notation in StarUML. Now, I need to draw a relational schema but due to lack of features in StarUML i must use other tool. My question is what exactly goes ...
5
votes
2answers
525 views

How to structure a model to properly and efficiently represent tree-like data on relational databases?

Based on Traversing tree-like data in a relational database using SQL question, I would like to know how the way regularly used to describe tree-like data on relational databases considering physical ...