You have been chosen to develop a web application for a reservation system for a local restaurant. This restaurant offers a diverse menu, including appetizers, main courses, and desserts. Your task is to create a reservation management system that serves both the restaurant staff and its patrons. The system should enable users, both restaurant staff and customers, to log in and utilize the platform. Each user should be able to input and save personal details such as their name, contact information, and login credentials. Ensuring the secure storage of passwords is a crucial aspect of the system.

Restaurant staff should have the capability to update the menu, add daily specials, and manage table reservations. Additionally, they should be able to view reservation data to optimize seating arrangements and staffing. Moreover, restaurant staff should be able to set seating preferences. On the other hand, customers should only be able to view the menu, make reservations, and track their reservation history. The system should also generate a summary report that highlights popular menu items and the frequency of reservations. This report will assist the restaurant management in making informed decisions about their offerings.

Customers should be able to make, modify, or cancel reservations through the system and receive confirmation notifications. Your objective is to design a user$-$friendly and efficient reservation system that enhances the dining experience for both the restaurant staff and the customers.

Specific requirements:

Model Design Requirements:

$$ Design your entity$-$relationship diagram $($ERD$)$ for the classes based on your understanding of complex entity relationships, including one$-$to$-$one, one$-$to$-$many, and many$-$to$-$many relationships.

$$ The web application should store the information of every class and relationship using forms. For example, the Person class may have properties such as ID$,$ Name, DOB, etc.

$$ Use appropriate data annotation and input validations for the HTML elements in the MVC forms. You can either use custom or default error messages.