Application Requirements:

The web application must be created using MVC

ASP.NET technology using C# for the backend and

SQL express for the database..

The home page must show group details, including student ID and student full names, in a table.

Create model classes that are specific to ERD

All the pages should have a logo and a navigation menu.

Use CSS to use your custom design for the web pages.

The web application must be ready to run without any additional configurations. Assessment type: Create MVC web application $-$ Group Assignment $(3-4$ students per group$)$

Assessment purpose: This assessment will allow students to demonstrate that they can develop dynamic

website using

ASP.NET Data Controls. Students are required to develop, test and maintain a dynamic

Internet application for business using an integrated suite of software tools. This assessment contributes to

learning outcomes b$,$ c$,$ d and e$.$

Value: $35\%$

Due date: Week $12$

Assessment topic: Create an MVC web application

Task Details:

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.