usefulBee
usefulBee

Reputation: 9702

Database design advice needed regarding including nullable fields

As seen in the following DB design:

I narrowed my options down to:

Both Table2 and Table1 are linked to Table3 for the sake of data integrity and so are attribute1 and 2 to other tables but omitted here for the sake of simplifying

enter image description here

Should I stick to this design since I could easily filter Table2 by type_id?

What is a better more robust approach to this dilemma?

Upvotes: 0

Views: 78

Answers (0)

Related Questions