Member Avatar for bbaum
bbaum 0 Newbie Poster

I'm designing a database and I'm not sure if the way I'm doing it is best. I attached a snippet of my ER diagram to this post.

I'm most concerned with the subtype relationships (Datasets to production datasets, Datasets to delivery_datasets, etc…). I’ve created a database with the design in the diagram and it seems like some queries are more difficult to write than they should be. Would anyone mind taking a look at the design and letting me know if I’m on the right track.

Thanks a lot!

design_snippet.JPG 165.46 KB
  • 1 Contributor
  • 0 Replies
  • 109 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.