I have a base shop in which you can rent a boat. Therefore, we have signs: customer, address, boat, worker, rent. One client and one employee can have several addresses. Further, the table "rent", I can not understand EXACTLY what kind of connection exists between the tables "client" and "rent" and "worker" and "rent", because one client can rent a boat several times, that is, have several rentals, and only one client can belong to one lease, that is, there is a one-to-many relationship, right? Further, an employee and rent, one employee can have several rentals, but one rent can have only one employee, right? Well, in short, look, did I draw the diagram correctly?
- The “boat” and “rent” seem to be wrong, because a single boat can own several rentals, but only one boat can belong to one rental? - Dima Vozniachuk
- It seems to be all right - Yaroslav Molchan
|
