Well... I need some help with my homework.
Here it is:
"A tourist association operates cottages in the mountains which people can rent.
The association wants a system to keep track on cottages, rentals and info about the guests, and asks you to create it
Remember necessary, entities, attributes, primary keys, relations, roles etc.
The database should be able to:
1) Show how much each guest have to pay
2) Show what people that have stayed at various cottages"
I just want you to create the tables/entities for me in theory. I don't really need any technical help with e.g. MySQL, or not yet at least.
I just cant get started, and I need some suggestions.
ANY help is appreciated! Thanks.