Hi,
I am an ICT teacher wanting to teach realtional databases to pupils. I don't want more than 3 tables in my database and I want a topic that they can relate to but not get side-tracked by!
I am thinking about doing a dog walking/grooming service.
I have my customer table and my dog table. What fields should I put in my service table? If I want to include prices does it mean I will need a 4th table? OR should I have no services table and a prices table instead that calculates the fee based on the minutes a dog is walked?
Thank you x