Assignment

Implementation of dynamic content, server side (backend) and database for your web site using Microsoft Visual Studio 2012.

Requirements:

Database:

• At least a table to store details of the 10 events (details in Assignment 1),
• At least a table to store online event bookings made by visitors (details in Assignment 1),
• At least a table to store feedback posted by visitors on each event (details in Assignment 1),
• These above tables are to be in the same database created by Visual Studio for users and roles (details of the database in Week 9 tutorial).

Users and roles:

• At least 2 roles which are visitor and admin staff are to be created. You can add more roles, e.g. guest.
• A visitor can

• view (read-only access) the information on the web site,
• make online event booking after logging in, and
• post his/her feedback to each of the 10 events after logging in.

• A visitor (and guest if you have this role) cannot make any changes on the web site.
• An admin staff can

• make changes to the content of the 10 events,
• create and delete the 10 events, and
• remove any feedback posted by visitors.
• remove any booking submitted by visitors.

Please submit a report along with your ASP.NET Web Forms Application project; adequately and coherently explaining how you addressed the above issues

The scenario of the assignment: as a part of the celebration of the centenary of Canberra, you are commissioned to design a web application which provides information about a brief history of Canberra (It can just be a time-line.), 5 major tourist attractions, 3 famous people from Canberra and an events calendar with ten events. Your web application also allows visitors make on-line events' booking and post their feedback on the events attended. Maximum number of web pages of your assignment is six.

There are two levels of access of the web site via web browsers, visitors' access and admin staff's access.

A visitor can view (read-only access) the information on the web site, make on-line event booking and post his/her feedback.

An admin staff can perform the following privileged tasks in addition to what a visitor can do:

1. Make changes to the content of web pages;
2. Create, delete, and edit the events.
3. Remove the feedback posted by visitors;