A2.3 MEALS Database Normalization

The Seasoned Steak 'n Side is a restaurant started by a chef sommelier. Her minimalist menu began with a small selection of specially designed dinners, each of which included a specially seasoned main course, a specially seasoned side dish and just the right wine. The menu is a BCNF relation, with a composite primary key consisting of all three columns together. Notice that even though the table is in BCNF, there are still redundancies.