You want to record the following data in a database: restaurant name and location, employee names and IDs, capacity of restaurant, smoking or nonsmoking area in restaurant, hours of operation for restaurant (assume same hours every day), employee salaries and titles. An employee can work for only one restaurant. A restaurant must have at least one employee working for it. Draw the ER diagram using the Chen-like model. Follow the methodology and include all English descriptions of your diagram. Map the ER diagram to a relational database and include some sample data.

a. An employee may work for a restaurant and can work for many restaurants, but a restaurant must have at least one employee working for it, and can have many employees working for it. Show the Chen-like ER model and relational mapping for this (you do not have to include data).

b. An employee must work for at least one restaurant and can only work for one restaurant. A restaurant may have employees working for it. Show the Chen-like ER model and relational mapping for this (you do not have to include data).