I am working on a reservation app for my university. In this app, one should be able to book a classroom, computer, specific software or request a license.
How do I improve my DB model? The main problem I have is the relation between reservations and the element. For example, if I wanted to do the same thing for a hotel, is quite easy because hotels have rooms and rooms do not vary that much. However, my case is different because I can't group classroms and software since they have different characteristics.
How do I make the relationship between the reservation table and what are the primary or foreign keys for the other tables?
My post is similar to this similar StackOverflow question. However, I do know how to normalize, I'm just looking for suggestions and tips on how to make the relation.