Further improvements to the design of a flat file
Can we improve the design even further?
We have solved some problems by splitting the original flat file into two related tables. We haven't solved all the problems, however. We still have to record breed details over and over again and we can't record a new breed in our database unless there is a real dog of that breed actually owned by someone! We could try splitting up the dogs’ table into two, like this:
Reading all of the relationships, we now have: