i am trying to come up with a schema for a databaes. It's been a while since I have done normalization on a schema, so I could use some help.
There are boats.
A boat is build in a shipyard.
A shipyard has an owner.
A boat is bought by an owner.
When a boat is bought by an owner, I still need to see from which shipyard the boat was bought.
A fairly simple situation you might say, by maybe my head isn't clear.
I have attached a picture with a schema I came up with.
I don't think this schema is the best solution.
In this situation a shipyard has an owner (which is correct) and the owner has a boat (which is also corrcet). Also the shipyard has a boat (could be correct, if the boat is not sold yet).
I don't think I can easily get a query that can tell me if a shipyard is still the owner, or the boat has been sold.( of course it can be done with attributes).
What would you guys come up with as a schema. I have another schema, but will not show so I don't blur your minds.