6.5 Entity-Relationship Diagram

You want to record the following data in a database: restaurant name and location, employee names and IDs, capacity of restaurant (smoking and nonsmoking), hours of operation (same hours everyday), employee salaries and titles. An employee can work for only one restaurant. Draw an 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.