Assignment task: Design a database that keeps track of a restaurant chain's restaurant locations and menu items.
You need to maintain information on the following fields:
Restaurant id, city, phone number, capacity, menu item id, menu item name, category, description, and menu item price
Note the following conditions:
1. Restaurant id determines restaurant city, phone number, and capacity.
2. Menu item id determines menu item name, category, and description.
3. The price of the same menu item varies from restaurant to restaurant, thus it is jointly determined by menu item id and restaurant id.
4. Each restaurant has many items on the menu.
5. Each menu item may appear in multiple restaurants.
Provide in your answer detailed table definitions and required relationships indicating linking columns.