Chapter 9 Database Design. Today we reviewed multi-valued dependencies. 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 complete menu is described es the relation: MAIN DISH SIDE DISH Salmon Steak Mashed Polato Pinot Grigio Salmon Steak ashed Potalo Chardonney WINE Salmon Steak Vente Rice Pinot Grigio Beel Steak t Baked Pa Caberne! Sauvignon teak et Sauvignon Beel Steak Because of the special seasonings, the sallmon could not be served with the baked poteto and the beef steek could not be served with white rice. The chief chef sommelier was a real stickler on this. Also, fish e.g., Salmon) must be served with a white wine (e.g., Pinot Grigio, Chardonnay) and beet itn a red (Cabemet Sauignon, Pinot Noir). No exceptions Notice the relation contains multi-valued dependencies (MVDs). The main dish (salmon or beef) detemines the possible side dishes and the wines, hence the are dependent However, a mein dish doesn't just deternine a single side dish, but only that it is one of a multi-valued set. Salmon steak will only be served with mashed potatoes or white rics, not with a baked potato. Beef steak will only be served with either a baked Aasthed Potato Pint Nor potato or mashed potatoes, but not white rice. (If this were regular single valued dependencies, Salmon steak could determins either the side dish as sither mashed potatces or white rics, but it couldn't be more than one.) The relation is in BCNF but not 4NF when we remember that Ris in BCNF if and only if every Functional Dependency IFD) that holds in R is implied by the keys of R R ls in 4NF it and only it every Multi-Valued DependencyMVD) that holds in R ls implied by the keys of R. Explain why menu relation above is in BCNF Why it is not in 4NF? Reduce the relation into two two-attribute relations that are 4NF, where the MVDs of the two relations are implied by the keys. Write the NATURAL JOIN statement to produce the original relation back from your two 4NF relations. 1. 2. 3. 4. Chapter 9 Database Design. Today we reviewed multi-valued dependencies. 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 complete menu is described es the relation: MAIN DISH SIDE DISH Salmon Steak Mashed Polato Pinot Grigio Salmon Steak ashed Potalo Chardonney WINE Salmon Steak Vente Rice Pinot Grigio Beel Steak t Baked Pa Caberne! Sauvignon teak et Sauvignon Beel Steak Because of the special seasonings, the sallmon could not be served with the baked poteto and the beef steek could not be served with white rice. The chief chef sommelier was a real stickler on this. Also, fish e.g., Salmon) must be served with a white wine (e.g., Pinot Grigio, Chardonnay) and beet itn a red (Cabemet Sauignon, Pinot Noir). No exceptions Notice the relation contains multi-valued dependencies (MVDs). The main dish (salmon or beef) detemines the possible side dishes and the wines, hence the are dependent However, a mein dish doesn't just deternine a single side dish, but only that it is one of a multi-valued set. Salmon steak will only be served with mashed potatoes or white rics, not with a baked potato. Beef steak will only be served with either a baked Aasthed Potato Pint Nor potato or mashed potatoes, but not white rice. (If this were regular single valued dependencies, Salmon steak could determins either the side dish as sither mashed potatces or white rics, but it couldn't be more than one.) The relation is in BCNF but not 4NF when we remember that Ris in BCNF if and only if every Functional Dependency IFD) that holds in R is implied by the keys of R R ls in 4NF it and only it every Multi-Valued DependencyMVD) that holds in R ls implied by the keys of R. Explain why menu relation above is in BCNF Why it is not in 4NF? Reduce the relation into two two-attribute relations that are 4NF, where the MVDs of the two relations are implied by the keys. Write the NATURAL JOIN statement to produce the original relation back from your two 4NF relations. 1. 2. 3. 4