Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database suggestions #102

Open
dlidstrom opened this issue Jul 3, 2019 · 0 comments
Open

Database suggestions #102

dlidstrom opened this issue Jul 3, 2019 · 0 comments

Comments

@dlidstrom
Copy link

dlidstrom commented Jul 3, 2019

I've taken a look at your fine database. I took the liberty to build a diagram using plantuml. It might be easier to understand compared to the one you built using Sql Server Management Studio. Also, some suggestions (to whoever wants to work further with this sample):

  • Define a unique key index on all tables, except the junction tables where the PK already enforces uniqueness. It helps maintain consistency and makes it clear what is the business key. Attendees is a nice example.

Conference
Conference.pdf

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant