Re: Feedback on database design

[Peter Brawley]

Neither the diagram nor the script can answer the question you're asking, which is the accuracy with which your db design matches the requirement. There's exactly one way to answer that question: create the db from the script, populate it with representative data, run every Select, Insert, Update and Delete command that the requirement says the system must handle, adjust the db structure to fix the failures you find, rinse and repeat until the process finds no more errors.