The coursework assignment is an individual assessment weighted 40% of the marks for the module. It is designed mainly to assess students' practical problem-solving skills and critical thinking/evaluation on the design and development of database systems. It requires the student to analyse, design and implement a web-based database application based on a given business case study. You are asked to provide a software solution as well as appropriate documentation detailing the design and implementation of the system. 1. Case Study - Titanic Leisure Centre Titanic Leisure Centre is a medium sized Leisure Centre in the London Borough of Folgate. It contains a gym, a large sports hall suitable for indoor sports such as 5-aside football, badminton and basketball, a smaller sports hall used for martial arts and two swimming pools (one large and one small). Titanic Leisure Centre is run by Mr. Radagast Imperio and employs various other staff such as gym instructors, receptionists and assistants. It also employs various instructors for particular sessions such as Judo and Karate. Customers of Titanic Leisure can either be full members who pay a monthly fee by direct debit, associate members who pay a fixed yearly fee and get a reduction on whatever activity they want to do or guest members who pay full price for activities as they do them. Depending on the room particular sessions might be booked by individuals, set aside for a community activity, or they might be open to all. So, for example, badminton sessions must be booked by an individual customer. Where an activity is organised by Titanic themselves then it is marked as being booked to 'TITANIC'. An example of this is a Karate or Judo session where an instructor is provided. Example of customer record list and an activity sheet for a hall are shown in the following figure 1and 2. You have been sub-contracted by WOFU as a Junior Database Developer to design and implement a prototype of the web-based database system for Titanic Leisure Centre. On completion of the system, you are required to provide a full set of documentation of the system to WOFU. Your prototype of the system will be developed using Oracle SQL Developer Data Modeler and ASP.NET with C# at London Met.