Acch3224 Unit 1 Assignment

1010 Words5 Pages
ITECH3224/6224 World Wide Web Technology 2 Faculty of Science Assignment 1 Introduction Term 1, 2014 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 the details of books borrowed from a library. The structure of the database is: BORROWER(BORROWER_NUMBER, BORROWER_NAME, EMAIL) BOOK(ISBN, TITLE, AUTHOR, PUBLISHER, YEAR_OF_PUBLICATION, NUMBER_OF_COPIES) BOOK_BORROWED(BORROWER_NUMBER, ISBN, COPY_NUMBER, DATE_BORROWED) Each record…show more content…
Check that numbers have been entered in fields that are numerical and that the numbers entered are within the specified range. 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. Querying the database Write PHP code that connects the database with the application. Enable the user to interrogate the database in a variety of ways, using a column of 5 buttons, 1 per query, with an appropriate description attached. Queries should demonstrate at least the ability to select records, select fields, display in sorted form and count. Generating new bookings Allow…show more content…
00103D Insert file name here Page 2 of 4 ITECH3224/6224 World Wide Web Technology 2 Faculty of Science 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 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’). CRICOS Provider No. 00103D Insert file name here Page 3 of 4 ITECH3224/6224 World Wide Web Technology 2 Faculty of

More about Acch3224 Unit 1 Assignment

Open Document