Antipattern: Use a Generic Attribute Table

Let's create a generic attribute table and observe how it affects a database.

The solution that appeals to some programmers when they need to support variable attributes is to create a second table, storing attributes as rows. See the diagram below showing the two tables.

Get hands-on with 1200+ tech skills courses.