develop a dynamic web application

CRICOS Provider No. 00103D Page 1 of 4 Assignment 1: Term 2, 2014 Introduction This is an individual assignment in which you are required to develop a dynamic web application as described below using PHP, MySQL, JavaScript and CSS. Details of the weight of the assignment and due date are given in the course description. Task Description Database structure The web application uses a 3-table relational database stored on a server that records, for a small gardening business, the details of bookings for services of various types. The structure of the database is: CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE) SERVICE(SERVICE_ID, SERVICE_NAME, PRICE_PER_HOUR) BOOKING(CUSTOMER_ID, SERVICE_ID, DATE, TIME_WORKED) Each record in the BOOKING table refers to a booking made by one customer for one service on the date specified. Customers may book more than one service a day and this requires a separate record for each service. IDs are unique integers; NAMEs are strings of up to 30 characters; ADDRESS is a string of up to 40 characters; PHONE is a 10-digit numerical string starting with ‘0’ (there are no international numbers); PRICE_PER_HOUR is a positive number with 2 decimal places; DATE is in 'ddmmyyyy' format; TIME_WORKED is in ‘hhmm’ format. The service is carried out at the customer's address (for this exercise). No nulls are permitted except for TIME_WORKED; the entry for this field is not made until the service has been provided. The BOOKING table has a primary key that combines the primary keys of the other 2 tables and the date of the service. Primary keys have been underlined. Initial data When the database is set up it should be populated with data that you have chosen. Display this data as part of your documentation. Each table should have from 3 to 6 records initially. Examples of SERVICE_NAME include mowing, tree-pruning, weeding, clearing, hedge-clipping, planting and rubbish_removal. Booking forms Before implementing the database, use PHP and CSS to create a form that enables the business to enter the details for the BOOKING table when a customer books one or more services on any given date. Wherever appropriate you should use drop down boxes for user-friendly entry of data and to reduce entry errors. Use JavaScript to ensure that an entry has been made in each element of the form and that the entries are valid. For example, check that numbers have been entered in fields that are numerical and that the numbers entered are within the specified range. ITECH3224/6224 World Wide Web Technology 2 Faculty of Science ITECH3224/6224 World Wide Web Technology 2 Faculty of Science CRICOS Provider No. 00103D Assignment 1, 2014/17 Page 2 of 4 Test the form by posting the values of the entries in the borrowing form to a separate php file that will display the borrowing details in full, including information obtained from the other two tables (once the database has been implemented). Creating the database Use MySQL commands from the command line to create a database on the server with the structure specified and populated with the initial data. Test the database by writing a query on the command line that displays all initial data as described on page 1. Write PHP code that will enable users to create an account giving them access to the database with permission to query the database and add new bookings. Account usernames will generally be email addresses. However include username ‘tutor’ with password ‘guest’ as one of the accounts. User passwords should be encrypted with an MD5() hash function. Manipulating the database Write PHP code that connects the database with the application. Enable the user to manipulate the database in a variety of ways, using a column of 5 buttons, 1 per action, with an appropriate description attached. Four queries should be enabled that demonstrate at least the ability to select records, select fields and display data in sorted form. The fifth button should enable the hours worked for a specific service to be inserted into the appropriate record. Generating new bookings Allow recognised users to submit a valid form that creates an additional record or records being written to the BOOKING table. Additional task for ITECH6224 students On the topic of “Accessibility and Usability of Websites” identify four (4), relevant, independent resources. Use these resources to discuss the topic in about 500 words. Take care to cite appropriately. Further details Documentation Include in a Word document: • Initial data details • A list of either parts of the assignment you have completed or parts not completed • Details of specific assistance received from people other than lecturer or tutor and the names of those assisting ITECH3224/6224 World Wide Web Technology 2 Faculty of Science CRICOS Provider No. 00103D Assignment 1, 2014/17 Page 3 of 4 Assignment support This assignment is supported by the first 5 lectures and the first 6 labs. Work on the assignment should be spread over a number of weeks and done as soon as possible after the relevant lab has been mastered. Course Description Refer to the Course Description for details of submission to Moodle, late assignments, extensions, special consideration, plagiarism, student support, presentation of academic work and adopted reference style. Submission All files should be zipped and uploaded to Moodle by the due date and time. Check with your tutor as to whether a hard copy is also required. (Note that ‘also’ does not mean ‘instead of’). ITECH3224/6224 World Wide Web Technology 2 Faculty of Science CRICOS Provider No. 00103D Assignment 1, 2014/17 Page 4 of 4 Assignment 1 Marking Guide Term 2, 2014 Name ____________________________ ID ______________________ Marker ____________________ Criterion Maximum Obtained Initial data – requirements satisfied 1 Order forms ! Static form design ! Validation of entries 4 1 3 Creating the database ! Table structure ! Initial data entry 2 1 1 Manipulating the database ! Accuracy of queries and insertion ! Up to 3 marks deducted for lack of variety of queries 5 5 (-3) Generating new bookings ! Data capture ! New record creation 3 2 1 Additional task for ITECH6224 students ! Content ! Writing style ! Adherence to academic standards 5 3 1 1 Documentation ! Initial data ! Completion of tasks statement ! Assistance statement 3 1 1 1 Quality of code – layout, choice of names, etc. 2 Totals ! ITECH3224 ! ITECH6224 ! Final mark for ITECH6224 (Total * 0.8) 20 25 20