I think doing a more abstract thought process helps in these situations. Lets look at the real-life problem which you are trying to model: You have a student, who approaches the instructor and asks when they will have their next lesson? The instructor takes a notebook, they agree on a date and time and reserve a car. In essence, you need to mimic the notebook as an aggregation column for you database. So it would have fields like ID, InstructorID, StudentID, CarID, DateBegin, DateEnd. Now, what we want to avoid, is a car being overbooked, so I would also add a boolean field to the Car Table, which says if the car is currently in use/free, and also do a check during registration whether the car is free in the period of time that is being attempted.
Sign in to participate in this thread!
We'd like to thank these amazing companies for supporting us