Skip to main content
留学咨询

辅导案例-KF6034

By May 15, 2020No Comments

Page 1 of 15 Programme: BSc Applied Computing Module Code: KF6034 Module Title: Object Oriented and Web Programming Distributed on: Monday 17th February 2020 Submission Time and Date: To be submitted by 14:00 BST on Tuesday 12th May 2020 Word Limit: For part A (Specification and Design) – 1000 words For part C (Reflective Report) – 1000 words Weighting This coursework accounts for 50% of the total mark for this module Submission of Assessment For parts A and C: Via TurnitIn accessed from the link in the Assessment section on eLP (more detailed instructions below) For part B: Via eLP (Blackboard) and by uploading to newnumyspace account (more detailed instructions below) It is your responsibility to ensure that your assignment arrives before the submission deadline stated above. See the University policy on late submission of work. Page 2 of 15 General Information This assignment constitutes 50% of the assessment for this module. It is in two parts, one of which leads to the other. The aims of the assignment, which will lead you to the fulfillment of the module learning outcomes, are to:  Develop a practical web solution using the PHP server-side scripting language and including dynamic web content by retrieving and manipulating data stored in a MySQL relational database and XML files.  Justify the design of your web database system with reference to relevant literature Your work, for all parts of the assignment, must be your own and, where you have used words from someone else (quotations), they should be correctly quoted and referenced in accordance to the Harvard (Northumbria) System. Referencing and academic writing support If you require guidance on citation, use the guide ‘Cite Them Right’ available from http://www.citethemrightonline.com/ For more support on academic writing and citation, you can also attend the Library’s Northumbria Skills Programme or access Skills Plus via the Library tab on the eLP (Blackboard). Part A – Specification and Design (20%) This part of the assignment covers the following module learning outcome:  Specify and design web database systems with justification Part B – System Development (60%) This part of the assignment covers the following module learning outcomes:  Build the presentation layer of multi-tier applications using an appropriate scripting language (e.g. PHP or Java).  Integrate and test software components that reside on either a web or database server Part C – Reflective Report (20%) This part of the assignment covers the following module learning outcome:  Critically reflect on the methodologies and tools used in developing solutions to programming problems. The deadline for all parts is Tuesday 12th May 2020 (no later than 2pm). Detailed submission instructions are below on page 12. Page 3 of 15 Scenario You are writing a system for clients to be able to import, save, retrieve and export information from book recommendation lists containing individual book details. The final system in production will ultimately allow multiple book recommendation lists to be imported. However for this assignment as the system is at the prototype phase, there is only one xml file of recommended books that you need to import and display which is at the following link: http://unn-cgel1.newnumyspace.co.uk/booklists/booklist.xml. Note: In order to view the XML structure from this feeds, it is recommended that you view the source of the page in the browser, e.g. view-source:http://unn-cgel1.newnumyspace.co.uk/booklists/booklist.xml. You can also see a sample of the XML in the Appendix of this assignment. You should use SimpleXML to access the XML file, extract the relevant XML and then reformat it in the way required. A list of the book details from the XML file should be displayed on the main page of your site in HTML and each title should link to the webpage where the book can be purchased on Amazon.co.uk (this link is provided in the xml file). This listing page should be available to all users. It represents the most recently imported recommended book list for the site. If a user logs in to the system then, additionally, they should be able to save the reference to any books so that they can create their own lists of books in a ‘my book list’ page. They should also be able to retrieve any previously saved book details from this list, add new books and also delete them. Please note that you may not be able to implement all the requirements that follow; this is to be expected. With a technical assignment such as this the requirements include some quite difficult parts that only a very strong student will be able to complete – this allows us to give a range of marks appropriate to ability. Look at the marking scheme on pages 7-11 for some idea of the breakdown of marks. Part A –Specification and Design (20%) You need to first consider relevant literature regarding the usability and interface design of websites and present some colour wireframes for your proposed solution annotated with key information relating to the interface design. The wireframes should be accompanied by a short report justifying your design choices which draw on references from relevant literature regarding usability and recommendations for effective interface design for websites (using Harvard referencing). This document should be no more than 1000 words in length. Marking This component of the assessment is worth 20% of the total marks available for the assignment. The criteria used for its marking will include:  The completeness and appropriateness of design documents (i.e. annotated wireframes)  The level at which the literature is analysed and relevance of the usability and interface design issues explored and justified  The use of references and examples from relevant literature to support the work.  Citation and the use of Harvard referencing The detailed marking scheme for part A is on page 7 of this assignment brief. Page 4 of 15 Part B – System Development (60%) Overview Read the XML structure in Appendix one which shows an example feed with the items that are the articles. This will help you better understand some of the detail that follows. Your website should be well-designed with a professional look and feel. You should use HTML5 for this assignment. You will need to implement the following:  A common header and footer for all pages displayed so that all pages in the site have a consistent look and feel.  The homepage should list all the book details from the XML file in the form of HTML. The XML elements you should display for each item element are: book title, author, year published, description and link.  You should use SimpleXML only, none of the other php libraries, to access the XML file, extract the relevant XML and then reformat it in the way required.  A search box on the homepage listing, allowing partial matching by book title or author using Xpath. Then only books matching the search criteria will be displayed on the front page.  A means of accessing an Amazon.com webpage for the particular book when the link from the front page is clicked.  A means by which a registered user can login which should be available from the homepage. You should use PHP sessions to manage persistence of the login state across all pages and store the date/time of the login.  A means by which a user, but only if logged in, can save book details to the saved_books database table (see accompanying database creation script on eLP) using PDO commands.  A means by which a user, but only if logged in, can retrieve and display any previously saved book references from the saved_books database table using PDO commands.  A means by which a user, but only if logged in, can delete any previously saved book references from the saved_books database table using PDO commands.
 Specifics Logging In Registered users should be able to login and logout, via a facility available from the front page. Any one of the three registered users (see the database table ‘members’) should be able to log in by typing their email and password (their login details are in the SQL script provided and in Appendix 2 below). Note that, for security, the passwords are stored on the database in encrypted form. Once logged in you should ensure persistence across all pages by using PHP sessions. You must also store the date/time of the login to the lastlogin field of the members table. Logging in will mean that the user has access to the menus and functionality for saving and retrieving books and book lists. Logging out should clear all session information. Front page Your site should have its own header and footer. The header area should contain appropriate system titles or images and menu options and a means of logging in and out. Show each book from the XML book list feed in an appropriate, well-designed layout, displaying the book title as the hyperlink, accompanied by the author, description and year published. Remember, if the user is logged in extra menu items and functionality are available. Books can be saved to a ‘my book list’ area by means of appropriate form elements (such as checkboxes, links or buttons) on the front page alongside the list of books. You should also be able to link to a list of saved books (‘my book list’ area) for the specific logged-in user. Page 5 of 15 There should be a search box on the front page. By default, the page should display ALL of the retrieved books, but what is listed will change in response to the Xpath search, if one is performed. Saving the Book Details to the User’s Book List You need to implement a means for a logged in user to save the references to multiple books in one action to the database for further reference, e.g. by selecting a checkbox next to each book’s details. A partial solution which would receive fewer marks would allow one book at a time to be saved to the book list. The user should not be allowed to save the same book twice to the book list. When a book is saved you should add to the database table called ‘saved_books the following data for each book:  book title, link, author, description and year published  bookid (this must uniquely identify a book. Use the bookid data here which represents the book’s ISBN, i.e. unique identifier)  a means of linking the logged-in user to the saved book  the date that the book was saved to the user’s book list Note: If you haven’t been able to write the code correctly which lists the articles directly from the XML file using SimpleXML, you could hard-code the book details. This would allow you to demonstrate that you can save the books to the database, and attempt partial marks for this section. Listing User’s Book List Items There should be a menu option, only available to logged-in users, that will list the user’s book list (i.e. their saved books) from the database. Deleting Saved Books from the Book List You need to implement a means for a logged in user to delete multiple saved books in one action from the database, e.g. by selecting a checkbox next to each saved book’s details. A partial solution which would receive fewer marks would allow one book at a time to be deleted. Export Book List to XML file There should be a means for members to be able to export their own book list details to an XML file. This XML file should have the same format as the one provided in the assignment for importing data. You should use file writing commands to create this XML file which should be named ‘exported_booklist.xml’ with today’s date prefixed (at the front) of the filename in the format ddmmyyyy. Note that all pages should validate without any HTML errors as reported by http://validator.w3.org using the HTML5 standard. All database access must be via PDO with the connection details stored separately in an included/required file or class. Prepared statements should be used for database access. The client will be using a MySQL database. The SQL database scripts and associated files needed are all in the assignment folder on eLP (Blackboard). * You must use SimpleXML for all XML interactions, and PDO for all database connectivity. You will lose marks if you do not. Marking This component of the assessment is worth 60% of the total marks available for the assignment. The marking scheme for part B is on pages 8-10 of this assignment brief. Page 6 of 15 Advice Please make sure you plan your code and the way different components will work together before you start writing any code. Make sure your code is indented and commented – your comments should be written first – writing pseudocode which become comments help make sure your code makes sense. Attempt all parts, it’s easier to get a few percent at the start of a question than get those last few percent trying to get a perfect solution to one part. In short getting less than half marks for all parts is better than getting almost full marks on only one part. Even if you don’t get all the XML parts working, though you probably should, don’t miss out those parts that require you to save things to the database. Even if some of the data is ‘hard-coded’ dummy data – you may get some marks for that. Part C – Reflective Report (20%) You must also write a reflective report (of no more than 1000 words in length) where you can generalise from specific failures or successes what you have learnt in order to take forward in future software development. What surprised you most? What do you wish you knew when you started? How could you have avoided problems that you encountered during development? 1. Evaluation: what do you regard as the successes and failures of the development: unresolved design problems, performance problems, etc? Identify which features of your system are the important ones. Point out design or implementation techniques that you are particularly proud of. Discuss which support tool(s) you used and their strengths and weaknesses. 2. Lessons: You should critically discuss the programming features that caused problems. What lessons did you learn from the experience? Consider how you might do it differently a second time round, and how any faults of the design and implementation may be corrected. 3. Known Bugs and Limitations: In what ways does your implementation fall short of the specification? Be precise. Although you will lose points for bugs and missing features, you will receive partial credit for accurately identifying those errors, and the source of the problem. Marking This component of the assessment is worth 20% of the total marks available for the assignment. The marking scheme for part C is on page 10 of this assignment brief. Page 7 of 15 Marking Scheme Part A: Specification and Design (20%) Mark range First (70 – 100) Upper Second (60 – 69) Lower Second (50 – 59) Third (40 – 49) Fail (30 – 39) Fail (0-29) General Criteria Assessment criteria Knowledge and understanding is comprehensive & exceptional both as to breadth and depth. Knowledge base is up- to-date and relevant, but also may be broad or deep. Sound understanding of topic. Reasoning and argument are generally relevant but not necessarily extensive. Knowledge is adequate but limited and/or superficial. Description/assertion rather than argument. Insufficient focus. Knowledge is limited and/or superficial; frequently inarticulate and/or irrelevant. Knowledge is very limited and/or superficial; frequently inarticulate and/or irrelevant with omissions. The completeness and appropriateness of wireframes 30% Excellent detail provided and comprehensive, wholly appropriate design documents presented (i.e. wireframes and site design) Very good detail provided and mos
tly complete and appropriate design documents presented (i.e. wireframes and site design). May be some omissions or lack of clarity. Satisfactory to good amount of detail provided and satisfactory design documents presented (i.e. wireframes and site design). May be some omissions or lack of clarity. Makes some attempt to provide detail on design documents (i.e. wireframes and site design). Design documents have been attempted but are not clear, appropriate and/or complete. Only basic detail on design documents (i.e. wireframes and site design). Design documents are incomplete, inappropriate and/or unclear. Poor design documents (i.e. wireframes and site design) which are incomplete and/or very simplistic. The level at which the literature is analysed and relevance of usability and interface design issues explored and justified. The correct use and citation of references and examples from relevant, appropriate literature to support the work. 70% Excellent analysis and evaluation of literature. All relevant usability and interface design issues have been fully explored and justified. Excellent use of references and examples from relevant literature to support the work. Excellent use of correct, appropriate citations and Harvard referencing. Very good analysis and evaluation of literature. Most relevant key usability and interface design issues have been explored and justified. Very good use of references and examples from relevant literature to support the work though could be used more frequently. Very good use of correct, appropriate citations and Harvard referencing. Satisfactory to good analysis and evaluation of literature. Some relevant usability and interface design issues have been explored and justified, however this could be more critical and in more depth. Satisfactory to good use of references and examples from relevant literature to support the work though could be used more frequently. Satisfactory to good use of some appropriate citations and Harvard referencing. Some attempt is made to analyse and evaluate appropriate literature and some relevant usability and interface design issues, however the level of this is superficial and lacking depth. Some attempt is made to use references and examples from literature to support the work, though should be used much more frequently and/or from more appropriate sources. Some citations and Harvard referencing though may be some omissions or errors. Literature is not discussed beyond a basic level. Little evaluation or analysis. Limited use of references and examples from literature to support the work. Limited use of appropriate citations and/or incorrect Harvard referencing. Inappropriate analysis and evaluation of literature. Poor quality references used and no examples from literature to support the work. Poor/no use of appropriate citations and/or incorrect Harvard referencing. Page 8 of 15 Part B – System Development (60%) Mark range First (70 – 100) Upper Second (60 – 69) Lower Second (50 – 59) Third (40 – 49) Fail (30 – 39) Fail (0-29) General Criteria Assessment criteria Knowledge and understanding is comprehensive & exceptional both as to breadth and depth. Knowledge base is up-to-date and relevant, but also may be broad or deep. Sound understanding of topic. Reasoning and argument are generally relevant but not necessarily extensive. Knowledge is adequate but limited and/or superficial. Description/assertion rather than argument. Insufficient focus. Knowledge is limited and/or superficial; frequently inarticulate and/or irrelevant. Knowledge is very limited and/or superficial; frequently inarticulate and/or irrelevant with omissions. Overall system design, usability, accessibility and aesthetics 15% The site has an excellent, consistent design, with wholly appropriate page structure and navigation, use of colour, space, content etc. Accessibility has also been considered throughout the design. The site has a very good consistent design, with mostly appropriate page structure and navigation, use of colour, space, content etc. Accessibility may need to be considered more throughout the design. The site has a satisfactory design, including page structure and navigation, use of colour, space, content etc. There may be some omissions or inconsistencies. Accessibility needs to be considered more throughout the design. The site has an adequate design, including page structure and navigation, use of colour, space, content etc. There are some omissions or inconsistencies. Accessibility needs to be considered more throughout the design. The site has a basic design, including page structure and navigation, use of colour, space, content etc. There are several omissions and/or inconsistencies. Accessibility needs to be considered more throughout the design. The site has a poor design, lacking consideration of page structure and navigation, use of colour, space, content etc. There are many omissions and/or inconsistencies. Accessibility needs to be considered more throughout the design. XML functions – displaying XML book details using SimpleXML and searching using Xpath 20% The code retrieves and displays book details appropriately with an excellent page design and usability. The search function works fully and has excellent usability. The code retrieves and displays book details appropriately with a good page design and usability. The search function works fully and has good usability. The code retrieves and displays book details satisfactorily with a mostly appropriate page design and usability. The search function works and has mostly appropriate usability. There may be some omissions or inconsistencies. The code retrieves and displays book details but there are some omissions or inconsistencies in the code and/or the page design and usability. The search function works to some extent but there are some omissions or inconsistencies in the code and/or usability. The code retrieves and displays book details in a basic manner. There are omissions or inconsistencies in the code and/or the page design and usability. The search function works in a basic manner but there are some omissions or inconsistencies in the code and/or usability. The XML functions are not working or have not been attempted. OR SimpleXML/xpath has not been used Page 9 of 15 Database interactions using PDO – saving books to booklist, displaying booklist and deleting saved books 25% The code saves, displays and deletes book details appropriately with an excellent page design and usability. Multiple books can be saved / deleted in one action. The code saves, displays and deletes book details appropriately with a good page design and usability. Multiple books can be saved / deleted in one action. The code saves, displays and deletes book details satisfactorily with a mostly appropriate page design and usability. Multiple books can be saved / deleted in one action. There may be some omissions or inconsistencies. The code saves, displays and deletes book details but there are some omissions or inconsistencies in the code and/or the page design and usability. OR PDO has not been used, therefore the maximum mark here is the pass mark. Multiple books cannot be saved / deleted in one action. The code saves, displays and deletes book details in a basic manner. There are omissions or inconsistencies in the code and/or the page design and usability. Multiple books cannot be saved / deleted in one action. The database interaction functions are not working or have not been attempted. Exporting saved books from the booklist to XML file using PHP file writing commands 10% The code creates an exported booklist which is formatted perfec
tly with all the correct elements and data. The code creates an exported booklist which is formatted very well with most of the correct elements and data. The code creates an exported booklist. There may be some omissions or inconsistencies in the formatting but all the elements and data are correct. The code creates an exported booklist. There are some omissions or inconsistencies in the formatting and some elements and data are incorrect. The code creates an exported booklist. There are several omissions or inconsistencies in the formatting and some elements and data are incorrect. The file writing function is not working or has not been attempted. Login and management using sessions 10% The code logs in and logs out users appropriately with an excellent page design and usability. PHP sessions are used correctly as is the password_verify() function. The code logs in and logs out users appropriately with a good page design and usability. PHP sessions are used correctly as is the password_verify() function. The code logs in and logs out users satisfactorily with a mostly appropriate page design and usability. There may be some omissions or inconsistencies. PHP sessions are used correctly as is the password_verify() function. The code logs in and logs out users appropriately but there are some omissions or inconsistencies in the code and/or the page design and usability. PHP sessions are not always used correctly or the password_verify() function. OR PDO has not been used, therefore the maximum mark here is the pass mark. The code to log in and log out users is not fully working as there are some omissions or inconsistencies in the code and/or the page design and usability. PHP sessions are not always used correctly as is the password_verify() function. The login and logout functions are not working or have not been attempted. Page 10 of 15 Coding standards 20% Excellent code quality. The code is clearly written, fully commented, and makes excellent use of classes and functions, and prepared statements for database access. The CSS and HTML are fully compliant with W3C guidelines. Very good code quality. The code is mostly well written and commented, and makes use of classes and/or functions, and prepared statements for database access. The CSS and HTML are mostly compliant with W3C guidelines. Satisfactory code quality. The code has some comments, makes use of some functions, and uses some prepared statements for database access. The CSS and HTML are mostly compliant with W3C guidelines. Adequate code quality. The code has some comments, but may not make use of functions, or prepared statements for database access. The CSS and HTML are not fully compliant with W3C guidelines. Basic code quality. The code has few comments, may not make use of functions, or prepared statements for database access. The CSS and HTML are not compliant with W3C guidelines. Poor code quality. Code comments are missing and the CSS and HTML are not compliant with W3C guidelines. Part C: Reflection (20%) Mark range First (70 – 100) Upper Second (60 – 69) Lower Second (50 – 59) Third (40 – 49) Fail (30 – 39) Fail (0-29) General Criteria Assessment criteria Knowledge and understanding is comprehensive & exceptional both as to breadth and depth. Knowledge base is up- to-date and relevant, but also may be broad or deep. Sound understanding of topic. Reasoning and argument are generally relevant but not necessarily extensive. Knowledge is adequate but limited and/or superficial. Description/assertion rather than argument. Insufficient focus. Knowledge is limited and/or superficial; frequently inarticulate and/or irrelevant. Knowledge is very limited and/or superficial; frequently inarticulate and/or irrelevant with omissions. Discussion including evaluation, lessons learnt, known bugs and limitations 100% Outstanding reflective report. All three components addressed and provide well thought out coverage of all aspects of work to an exceptionally high standard. Very good reflective report covering all aspects of work as required to a high standard. Good reflective report. All three components addressed. All of which show satisfactory understanding of what was required. Adequate reflective report. All three components addressed; one or two of three show satisfactory understanding of what was required. Poor reflective report. Attempted all three components but tended to be unjustified statements of achievement. Inadequate reflective report. Some attempt in at least one of the three components but none shows evidence of understanding Page 11 of 15 Assignment Submission This assignment is to be submitted electronically in three ways as follows: 1. You must submit the written reports for Assignment Part A (Specification and Design) and Assignment Part C (Reflection) via TurnitIn accessed from the links in the Assessment section on eLP (Blackboard). This is to help you avoid academic misconduct. Instructions on how to do this will be provided in the Assignments section for the module on eLP. 2. You are required to FTP ALL of the files that you used to implement parts A, B and C of the assignment to your newnumyspace account by 14:00 on Tuesday 12th May 2020. Your files should not be altered after that time. Your web solution MUST be designed to work on your newnumyspace web space. You should test your web solution to ensure that it is working prior to the specified hand-in date/time. The web address to get to your assignment solution should be http://unn-YOURUSERID.newnumyspace.co.uk/index.php (you substitute the text YOURUSERID in the above URL with your own user ID) 3. You must also zip all the files and subdirectories that make up your system into one zip file with the following naming convention: yourstudentID_xmlBook list.zip (Obviously, replace the part of the name that say’s ‘yourstudentID’ with your own studentID). Please also make sure you only use the .zip format. rar files or those of any other compression format won’t be accepted. In eLP (Blackboard) go to Assessment > Assignment Part B Submission > View/Complete Assignment: Assignment Part B Submission In Assignment Materials section click on the Browse button in the attach local file area and navigate to the required zip file. Click Submit (note that it must be Submit and not Save) You must only submit ONE zip file that contains all of the files you used to complete Assignment Parts A, B and C. Do NOT submit lots of files individually. When you add your zip file you MUST, in the Comments box, specify the exact web address of the home page for your solution to Assignment Part B. Assignment Feedback Feedback and marks for the assessments will be provided via My Grades which is accessible from eLP (Blackboard). A feedback sheet will also be available from My Grades for you to download. Feedback can be discussed in person if required. Page 12 of 15 Appendix One XML file example An example of the structure of the rss feed that delivers the books is shown in the following. Note each individual book is the element named ‘item’. Recommended Book List Sharing Share recommended book lists – import from other applications and export them en-us 1407198750 His Dark Materials: Northern Lights Philip Pullman https://www.amazon.co.uk/His-Dark-Materials-Northern-Lights/dp/1407198750 The first volume in Philip Pullman’s HIS DARK MATERIALS trilogy. Lyra Belacqua and her animal daemon live half-wild and carefree among scholars of Jordan College, Oxford. The destiny that awaits her will take her to the frozen lands of the Arctic, where witch-clans reign and ice-bears fight. Her extraordinary journey will have immeasurable consequences far beyond her own world. 1995 0007200285 Half of a Yellow Sun C
himamanda Ngozi Adichie https://www.amazon.co.uk/Half-Yellow-Chimamanda-Ngozi- Adichie/dp/0007200285 Winner of the Orange Broadband Prize for Fiction 2007, this is a heartbreaking, exquisitely written literary masterpiece, set in the era of the Biafran war in Nigeria. 2006 0141187761 1984 Nineteen Eighty-Four George Orwell https://www.amazon.co.uk/Nineteen-Eighty-Four-Penguin-Modern- Classics/dp/014118776X A dystopian novel which follows the life of Winston Smith, a low ranking member of ‘the Party’, who is frustrated by the omnipresent eyes of the party, and its ominous ruler Big Brother. ‘Big Brother’ controls every aspect of people’s lives. 1949 0143107321 The Adventures of Huckleberry Finn Page 13 of 15 Mark Twain https://www.amazon.co.uk/Adventures-Huckleberry-Finn-Penguin- Classics/dp/0143107321 In Missouri, during the 1840s, young Huck Finn fearful of his drunkard father and yearning for adventure, leaves his foster family and joins with runaway slave Jim in a voyage down the Mississippi River toward slavery free states. 1884 1780227892 A Suitable Boy Vikram Seth https://www.amazon.co.uk/Suitable-Boy-classic-bestseller/dp/1780227892 A tale of Lata, and her mother’s, attempts to find her a suitable husband, through love or through exacting maternal appraisal. At the same time, it is the story of India, newly independent and struggling through a time of crisis as a sixth of the world’s population faces its first great general election and the chance to map its own destiny. 1993 1408855658 Harry Potter and the Philosopher’s Stone J.K. Rowling https://www.amazon.co.uk/Harry-Potter-Philosophers-Stone/dp/1408855658 On Harry Potter’s eleventh birthday, he discovers that he is a wizard, and he has a place at Hogwarts School of Witchcraft and Wizardry. An incredible adventure is about to begin! 1997 Page 14 of 15 Appendix Two Database Structure Notes The memberID field in the table saved_books is a foreign key referencing the field memberID in the table members. memberID is the primary key of the members table and is therefore unique. The primary key of the saved_books table is a compound key of two fields bookID and memberID together. This ensures that the same book can’t be saved twice for the same member. For testing purposes three users are provided in the members table – no other users should be added. Details of the users can be found below and also, in the form of comments, in the sql script file accompanying this assignment. Email Unencrypted password [email protected] peter [email protected] fred [email protected] susan NOTE that the password field uses encryption, the password for each user is set to the users first name (in lowercase) then converted using the PHP password_hash function. This is the version of the password that you’ll see in the members database table. When logging in you’ll need to use another password function to verify the password. memberID email name password lastL ogin members saved_books bookID memberID (FK) bookTitle author description link yearPublished dateSaved Page 15 of 15 Assessment Regulations You are advised to read the guidance for students regarding assessment policies. They are available online here. Late submission of work Where coursework is submitted without approval, after the published hand-in deadline, the following penalties will apply. For coursework submitted up to 1 working day (24 hours) after the published hand-in deadline without approval, 10% of the total marks available for the assessment (i.e.100%) shall be deducted from the assessment mark. Coursework submitted more than 1 working day (24 hours) after the published hand-in deadline without approval will be regarded as not having been completed. A mark of zero will be awarded for the assessment and the module will be failed, irrespective of the overall module mark. These provisions apply to all assessments, including those assessed on a Pass/Fail basis. The full policy can be found here. Word limits and penalties If the assignment is within +10% of the stated word limit no penalty will apply. The word count is to be declared on the front page of your assignment and the assignment cover sheet. The word count does not include: Please note, in text citations [e.g. (Smith, 2011)] and direct secondary quotations [e.g. “dib-dab nonsense analysis” (Smith, 2011 p.123)] are INCLUDED in the word count. Students must retain an electronic copy of this assignment (including ALL appendices) and it must be made available within 24hours of them requesting it be submitted. The full Word Limit Policy is available here. Academic Misconduct The Assessment Regulations for Taught Awards (ARTA) contain the Regulations and procedures applying to cheating, plagiarism and other forms of academic misconduct. The full policy is available at here You are reminded that plagiarism, collusion and other forms of academic misconduct as referred to in the Academic Misconduct procedure of the assessment regulations are taken very seriously. Assignments in which evidence of plagiarism or other forms of academic misconduct is found may receive a mark of zero.

admin

Author admin

More posts by admin