Firstly, apologies for bringing this horrible database problem. This is my attempt at an entity relationship diagram, I realise that it does not show the relationships - I have a poor understanding of normalisation. I have produced this in preparation for making a database based on a case study of a holiday cottage company. To make things simple, lets say there's an arbitrary number of cottages, 4 will do for now.
- What normalised form, if any, can this ERD be considered to be in? (1st, 2nd or 3rd?)
- The 'cottage ID' field in the 'Bookings' table will contain repeated values - it will always be 1,2,3 or 4. Is this a problem?
- If this is a problem, I could resolve this by creating a link entity right? What are the advantages of this? I'm thinking it's unnecessary - persuade me if it's appropriate.