We're Open
+44 7340 9595 39
+44 20 3239 6980

[Solved]Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in A

  100% Pass and No Plagiarism Guaranteed

[Solved]Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in Assignment 1A in MySQL.

Assessment Task C – Critical Review Database Design Assessment weighting: 40% Submission Date/Time: Wednesday, December 06, 2017 at 9 PM (UK time) This is an individual assessment worth 40% of the module. Overview Working from the database you designed in Assessment A, you will produce a database using MySQL together with an web interface. You will cover possible security issues and critically evaluate your work. You will demonstrate collaborative group working skills by contributing to a group discussion board (with both original posts and responding to the posts of others) to help other students with technical issues during their development. Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in Assignment 1A in MySQL. Your database tables must be created using SQL statements which must be detailed in your final report. You will also supply a supporting .sql file which can be run by the assessor in order to create the tables in MySQL. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate. Using appropriate sample data and your own imagination, you will populate your finished tables. 2. Optimize and secure your database (10 marks) Apply suitable database optimization and query-tuning techniques – such as indexing and clustering to your final set of tables. Note and explain these in your supporting technical documentation. Create three new users on your database and allocate different security privileges and roles with respect to the database tables. Demonstrate what actions each user can/cannot perform. Note and explain these roles in your supporting technical documentation. 3. Produce wireframe mockups of the Flight Booking Website and build a basic functioning interface for website administrators. (30 marks) You now have a fully working, secure and optimized database. Use wireframes to mockup the stages that various users will take in the following scenarios: University of Derby Online Learning www.derby.ac.uk/online 12 of 16 □ a passenger registering with the website □ a passenger booking tickets for his family □ a passenger amending an existing booking □ The website administrator viewing all bookings on a flight □ The website administrator adding a new route to the Flight Booking Database Highlight any issues which arose or were picked up during the wireframe stage in a supporting report. Build a simple functioning web based interface using PHP, MySQL and HTML allowing the flight booking website administrator to: □ Log in as an administrator □ add a new booking □ amending an existing booking □ by delete an existing booking □ view all bookings on a particular flight NOTE: You will not be assessed on the graphic design of your wireframe mockups or final web interface which is meant to be a working prototype rather than a finished website. You do not need to spend time on the ‘look and feel’ of the finished design (e.g. colour scheme / logos / typography) etc. 4. Contribute to the Group Discussion board (10 marks) Collaborating with fellow students is an important component to this assignment. You will need to contribute to the Group Discussion Board and provide advice and assistance to fellow students. Please note that this should not involve you carrying out other students’ work for them. 5. Report on the security and performance issues involved in implementing your Flight booking web application (30 marks) Write a 1000 word critical evaluation of your final submission explaining the various security measures you would take in implementing the Flight Booking Database. Highlight any security issues such as SQL injection or cross-site scripting (XSS) attacks which might arise if your website application was made public and explain how these would be addressed. You should also report on how your database could be further improved in its performance. What you will need to submit for Part C A zip archive with the naming convention [Student-ID]_database_1b_

part2.zip containing: University of Derby Online Learning www.derby.ac.uk/online 13 of 16 □ A .sql file which the assessor will use to import the MySQL database □ The PHP files and images which make up your web interface □ A supporting word document with any special instructions for the assessor to support your web application. This word document should include the optimizing techniques and user role permissions set out in task 2 above as well as the wireframe design stage in task 3. □ A separate 1000 word critical evaluation reviewing the security and performance of your flight booking web application set out in task 5 above. ImportantNotes □ Make sure your full name and student ID are on the front page of the assessments □ Place a word count at the end of each of your reports □ Clearly label all tasks and take care to explain and discuss your technical work □ Clearly label and number all sections and sub-sections of your reports □ If you need to research, then fully reference all such sources using the Harvard notation □ Try and incorporate good-quality diagrams into your discussion □ Make sure you are an active participant on the group discussion board The detailed grading criteria are over the page…


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved]Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in Assignment 1A in MySQL.
  • Price: £ 109
  • Post Date: 2021-10-06T11:37:14+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in Assignment 1A in MySQL. [Solved]Tasks 1. Implement your database design in MySQL. (20 marks) You will implement the Flight Bookings database produced in Assignment 1A in MySQL.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

This is my second order which I booked recently at Insta Research. I just got my coursework completed expertly. Just waiting for good scores now.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The writer 0223 is really helpful. He gave me the best essay ever. Love you loads for such a great job and thanks again.