logo

Web Database Application Development and Evaluation

   

Added on  2019-09-18

8 Pages2397 Words406 Views
 | 
 | 
 | 
Course: COMP1686 Web Database ApplicationsContribution: 100% of course107: Web Database Applications - Term 1 - MAC PDF file required - ZIP file also required Greenwich Course Leader: DrMadeleineTogher Due date: 21st November 2016This coursework will be marked anonymouslyYOU MUST NOT PUT ANY INDICATION OF YOUR IDENTITY IN YOUR SUBMISSIONThis coursework should take an average student who is up-to-date withtutorial work approximately 50 hoursLearning Outcomes:A,B,C,D,E,F Plagiarism is presenting somebody else’s work as your own. It includes: copying information directly from the Web or books without referencing the material; submitting joint coursework as an individual effort; copying another student’s coursework; stealing or buying coursework from someone else and submitting it as your own work. Suspected plagiarism will be investigated and iffound to have occurred will be dealt with according to the procedures set down by the University. All material copied or amended from any source (e.g. internet, books) must be referenced correctly according to the reference style you are using.Your work will be submitted for electronic plagiarism checking. Any attempt to bypass our plagiarism detection systems will be treated as a severe Assessment Offence.Coursework Submission RequirementsAn electronic copy of your work for this coursework should be fully uploaded by midnight (local time) on the Deadline Date.The last version you upload will be the one that is marked.For this coursework you must submit a single Acrobat PDF document. In general, any text in the document must not be an image (i.e. must not be scanned) and would normally be generated from other documents (e.g. MS Office using "Save As .. PDF").For this coursework you must also upload a single ZIP file containing supporting evidence.There are limits on the file size. The current limits are displayed on the coursework submission page on the IntranetMake sure that any files you upload are virus-free and not protected by a password or corrupted otherwise they will be treated as null submissions. Comments on your work will be available from the Coursework page on the Intranet. The grade will be made available in the portal.You must NOT submit a paper copy of this coursework. All coursework must be submitted as aboveThe University website has details of the current Coursework Regulations, including details of penalties for late submission, procedures for Extenuating Circumstances, and penalties for Assessment Offences. See http://www2.gre.ac.uk/current-students/regsfor details.
Web Database Application Development and Evaluation_1

Detailed Specification for the Greenwich Cinema Booking Company Web ApplicationThis coursework is to be carried out individuallyThe Greenwich Cinema Booking Companyhas a number of cinema venues, with one inCentral Greenwich, one in East Greenwich and one in South Greenwich. There is a flat rateprice for the tickets which is dependant only on its type/category. Price doesn’t depend on theseason for this cinema company. The data held on each cinema is the address which is madeup of street, city, county, postcode and the telephone number. Each cinema is given a cinemanumber, which is totally unique throughout the company.Each cinema is allocated staff, including a Manager. The Manager is responsible for the day-to-day running of a cinema. The data held on a member of staff is his or her name, positionand salary. Each member of staff is given a staff number, which is unique throughout thecompany. Each cinema has 200 seats of various price ranges such as (Luxury, Superior, Standard orBudget etc.). The data held on a seat is the Seat No, Lounge No, category, cost, status. TheLounge No should uniquely identify the viewing lounge within a particular cinema but youmay want to consider how to make it unique across the 3 separate cinema venues. The statusof a seat on a particular date and time of film indicates whether the seat in one of the cinemasviewing lounges is available for purchase. Before booking a ticket for a film, a customer must first register as a member of theGreenwich Cinema Group. Each member is given a member number, which is uniquethroughout all hotels of the company. Once registered, a member is able to book cinematickets of their choice. The data held on each customer booking is the booking number, thefull name and number of the member, the cinema lounge number, and the dates of the filmthat the seat/seats numbers that are booked. The booking number is unique throughout thecompany.The owner of The Greenwich Cinema Booking Company has approached you to set up aprototype online registration system for customers to register and search for and book cinematickets. The online system could also allow for the administrator to maintain the databasetables.
Web Database Application Development and Evaluation_2

You are required to submit an interim report which should be checked by your tutor. (This will not be graded but merely to assist your progress and should be returned with feedback. This should be submitted around the middle of the course and the date will be given by your tutor) Design the following ERDs for the Greenwich Cinema Booking Companydatabase. a.Conceptual Model and b.Mapped Logical Model 1.Design user interfaces that you intend to implement for Security Level 1 and 2.Include these designs as screenshots. **Your tutor will provide you with formative feedback for the interim report which you shouldthen use to improve your coursework for final submission. The tutor will also check your weeklyprogress of your tutorial work. **You are required to implement the following for a final demonstration and product upload:You should extend the given ASPnetDB or equivalent Security database (security tablesshould hold users’ login details) to contain the data required for the application. This willdepend on the version of Visual Studio that you have used to build your product. Add yourtables and relationships which were designed for the interim report to the Security databaseso that you have one final database. The database should contain relevant tables, attributes,relationships and referential integrity. It will be used as the back end for your web databaseapplication. 1.A web application which includes the following possible levels of security:a.Security Level 1 is the basic area that all users can view without registeringor logging in. You should create the following lists to be displayed at thislevel:i.A list of available seats for a particular price range (i.e. Luxury,Superior or Budget etc.) and film date.ii.A list of various films which are showing and their dates.iii.A list of films and date of showing at each separate cinemaAll data presented for the above (i, ii and iii) should come from the database.b.Security Level 2 is for people who have a customer account and can login tothe web site. Here you will need to set up the following functionality:i.Create a form for new customers to register (sign up) to the system(save the role for this new user as customer),ii.Allow the customers to amend their details once logged in,
Web Database Application Development and Evaluation_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Yoga Session Reservation System
|8
|1856
|284

Software Engineering Project Management
|6
|2834
|384

Logbook (coursework no. 1)
|5
|1879
|445

Database Manipulation and Querying
|9
|2866
|548

Changing the Mindset of Management Team
|10
|2475
|316

Financial Analysis and Recommendation Report
|3
|817
|224