Higher National Diploma in Computing: Online Library Management System

This report details the design and development of an online library management system, as part of a BTEC Higher National Diploma in Computing, Unit 10: Web Design and Development. The assignment covers a range of topics, including server technologies, communication protocols, DNS, search engine optimization, front-end and back-end technologies, and the comparison of online website creation tools versus custom-built sites. The student designed a multi-page website using PHP, JS, and MySQL, and implemented a database design. The report includes wireframes, client and user requirements, code snippets, and screenshots of the user interface. A test plan was created and evaluated to review the website's performance and design, and user documentation was prepared. The report provides a comprehensive overview of the web design and development process, highlighting the technical challenges faced and the evaluation of the final product.

Paul Marky
Web Design And Development
pg. 1
Higher Nationals
Internal verification of assessment decisions – BTEC (RQF)
INTERNAL VERIFICATION – ASSESSMENT DECISIONS
Programme title BTEC Higher National Diploma in Computing
Assessor Internal Verifier
Unit(s) Unit 10: Web Design and Development
Assignment title Online Library Management System
Student’s name Paul Marky
List which assessment
criteria the Assessor has
awarded.
Pass Merit Distinction
INTERNAL VERIFIER CHECKLIST
Do the assessment criteria awarded match
those shown in the assignment brief? Y/N
Is the Pass/Merit/Distinction grade awarded
justified by the assessor’s comments on the
student work?
Y/N
Has the work been assessed
accurately? Y/N
Is the feedback to the student:
Give details:
• Constructive?
• Linked to relevant assessment
criteria?
• Identifying opportunities for
improved performance?
• Agreeing actions?
Y/N
Y/N
Y/N
Y/N
Does the assessment decision need
amending? Y/N
Assessor signature Date
Internal Verifier signature Date
Programme Leader signature (if
required) Date

Paul Marky
Web Design And Development
pg. 2
Confirm action completed
Remedial action taken
Give details:
Assessor signature Date
Internal Verifier
signature Date
Programme Leader
signature (if required) Date

Paul Marky
Web Design And Development
pg. 3
Higher Nationals - Summative Assignment Feedback Form
Student Name/ID
Unit Title Unit 10: Website Design & Development
Assignment Number 1 Assessor
Submission Date Date Received 1st
submission
Re-submission Date Date Received 2nd
submission
Assessor Feedback:
LO1. Explain server technologies and management services associated with hosting and managing websites.
Pass, Merit & Distinction
Descripts
P1 P2 M1 M2 D1
LO2. Categorise website technologies, tools and software used to develop websites.
Pass, Merit & Distinction
Descripts
P3 P4 M3 D1
LO3. Utilise website technologies, tools and techniques with good design principles to create a multipage
website.
Pass, Merit & Distinction
Descripts
P5 P6 M4 D2
LO4. Create and use a Test Plan to review the performance and design of a multipage website.
Pass, Merit & Distinction
Descripts
P7 M5 D3
Grade: Assessor Signature: Date:
Resubmission Feedback:
Grade: Assessor Signature: Date:
Internal Verifier’s Comments:
Signature & Date:
* Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have
been agreed at the assessment board.

Paul Marky
Web Design And Development
pg. 4
Pearson
Higher Nationals in
Computing
Unit 10: Web Design and Development
Assignment 01
General Guidelines
1. A Cover page or title page – You should always attach a title page to your assignment. Use previous page as
your cover sheet and be sure to fill the details correctly.
2. This entire brief should be attached in first before you start answering.
3. All the assignments should prepare using word processing software.

Paul Marky
Web Design And Development
pg. 5
4. All the assignments should print in A4 sized paper, and make sure to only use one side printing.
5. Allow 1” margin on each side of the paper. But on the left side you will need to leave room for binging.
Word Processing Rules
1. Use a font type that will make easy for your examiner to read. The font size should be 12 point, and should be
in the style of Time New Roman.
2. Use 1.5 line word-processing. Left justify all paragraphs.
3. Ensure that all headings are consistent in terms of size and font style.
4. Use footer function on the word processor to insert Your Name, Subject, Assignment No, and Page Number
on each page. This is useful if individual sheets become detached for any reason.
5. Use word processing application spell check and grammar check function to help edit your assignment.
Important Points:
1. Check carefully the hand in date and the instructions given with the assignment. Late submissions will not be
accepted.
2. Ensure that you give yourself enough time to complete the assignment by the due date.
3. Don’t leave things such as printing to the last minute – excuses of this nature will not be accepted for failure
to hand in the work on time.
4. You must take responsibility for managing your own time effectively.
5. If you are unable to hand in your assignment on time and have valid reasons such as illness, you may apply (in
writing) for an extension.
6. Failure to achieve at least a PASS grade will result in a REFERRAL grade being given.
7. Non-submission of work without valid reasons will lead to an automatic REFERRAL. You will then be asked to
complete an alternative assignment.
8. Take great care that if you use other people’s work or ideas in your assignment, you properly reference them,
using the HARVARD referencing system, in you text and any bibliography, otherwise you may be guilty of
plagiarism.
9. If you are caught plagiarising you could have your grade reduced to A REFERRAL or at worst you could be
excluded from the course.

Paul Marky
Web Design And Development
pg. 6
Student Declaration
I hereby, declare that I know what plagiarism entails, namely to use another’s work and to present it as my own
without attributing the sources in the correct way. I further understand what it means to copy another’s work.
1. I know that plagiarism is a punishable offence because it constitutes theft.
2. I understand the plagiarism and copying policy of the Edexcel UK.
3. I know what the consequences will be if I plagiaries or copy another’s work in any of the assignments for this
program.
4. I declare therefore that all work presented by me for every aspects of my program, will be my own, and where
I have made use of another’s work, I will attribute the source in the correct way.
5. I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between
myself and Edexcel UK.
6. I understand that my assignment will not be considered as submitted if this document is not attached to the
attached.
Student’s Signature: [e-mail] Date: 30.11.2020
(Provide E-mail ID) (Provide Submission Date)
Assignment Brief

Paul Marky
Web Design And Development
pg. 7
Student Name /ID Number
Unit Number and Title Unit 10- Web Design and Development
Academic Year 2017/2018
Unit Tutor
Assignment Title Online Library Management System
Issue Date
Submission Date
IV Name & Date
Submission Format:
Unit Learning Outcomes:
LO1 Explain server technologies and management services associated with hosting and managing
websites.
LO2 Categorise website technologies, tools and software used to develop websites.
LO3 Utilise website technologies, tools and techniques with good design principles to create a multipage
website.
LO4 Create and use a Test Plan to review the performance and design of a multipage website.
Assignment Brief and Guidance:

Paul Marky
Web Design And Development
pg. 8
Assignment Brief
Borrowing books, returning books or viewing the available books at the Library of the Lowa State University
is currently done manually.
Online Library Management System supports to overcome the above-mentioned problems. This system
would be used by members who may be students or professors of that University to check the availability
of the books and borrow the books., The librarian can update the member details and the book lending
details.
Online Library Management System will include the following information.
 The librarian, students and the professors can register and login to the system
 Any of the above users can update their profile details including the password
 The authorized users can reserve a book for 24hours
 The authorized users can check book availability
 The librarian can check the member status and update the lending details (If the book is for the
lending)
 The system allows the Librarian to create the books catalog, add/delete books and maintain the
books catalog.
 The librarian can update the book return details
 The librarian can calculate the fine for the late returns if necessary
 The users can search the books according to the categories (Novels, Frictions, etc.)
Task 1 - Server technologies and management services associated with hosting and managing websites
(LO1)
1.1 Differentiate the communication protocols, server hardware, operating systems and web server
software with regards to designing, publishing and accessing a website.
1.2 Define the types of DNS and the uses of it, with clarifications on how domain names are structured.
1.3 Analyze the effect of search engines on website performance. Provide evidence-based support for
improving a site’s index value and rank through search engine optimization.
1.4 Identify and explain the common web development technologies and frameworks. Explain the tools
and techniques chosen to the web application and hence justify, by giving reasons, why a web
application is suitable for the given scenario.

Paul Marky
Web Design And Development
pg. 9
Task 2 - Categories website technologies, tools and software used to develop websites (LO2)
2.1 Define the relationships between front-end and back-end website technologies and explain how the
front-end and the back-end relate to presentation and application layers.
2.2 Critically compare the different between online website creation tools and custom-built sites.
Consider Followings: design flexibility, performance, functionality, User Experience (UX) and
User Interface (UI).
2.3 Compare and contrast the tools and techniques available to design and develop a custom-built web
Applications.
Task 3 - Utilize website technologies, tools and techniques with good design principles to create a
multipage website (LO3)
3.1 Design a suitable web application solution for the given scenario. Provide evidences of the design,
multipage website supported with fidelity wireframes and a full set of client and user requirements.
Use your design document with appropriate principles, standards and guidelines to produce a branded,
multipage website supported with realistic content.
Note - Synthesize client and the server-side functionalities in the proposed design
3.2 Implement the designed system using PHP, JS and MySQL. Screenshots of important code lines with
proper comments and user interfaces filled with sample data must be attached to the
documentation. Apply a database design for the proposed system and provide the well normalized
database design of the proposed system.
3.3 Critically evaluate the web design and development process against your design document and
analyse any technical challenges you faced in development.

Paul Marky
Web Design And Development
pg. 10
Task 4 - Create and use a Test Plan to review the performance and design of a multipage website
(LO4)
4.1 Evaluate the Quality Assurance (QA) process and review how it was implemented during your
design and development stages.
QA process is expected to discover design issues and development errors while testing a
product’s user interface (UI) and gauging the user experience (UX).
4.2 Critically evaluate the results of your Test Plan and include a review of the overall success of your
multipage website; use this evaluation to explain any areas of success and provide justified
recommendations for areas that require improvement.
4.3 Prepare a user documentation to properly guide the users of the implemented system.
Note: User documentation should be simple and understandable by anyone. Use screenshots and
provide stepwise guidance.

Grading Rubric
Grading Criteria Achieved Feedback
LO1 Explain server technologies and management services associated with
hosting and managing websites
P1 Identify the purpose and types of DNS, including explanations on how
domain names are organized and managed.
P2 Explain the purpose and relationships between communication
protocols, server hardware, operating systems and web server software
with regards to designing, publishing and accessing a website.
M1 Evaluate the impact of common web development technologies and
frameworks with regards to website design, functionality and
management.
M2 Review the influence of search engines on website performance and
provide evidence-based support for improving a
site’s index value and rank through search engine optimization.
D1 Justify the tools and techniques chosen to realize a custom built
website.
LO2 Categories website technologies, tools and
software used to develop websites
P3 Discuss the capabilities and relationships between front-end and back-
end website technologies and explain how these relate to presentation
and application layers.

P4 Discuss the differences between online website creation tools and
custom built sites with regards to design flexibility, performance,
functionality, User Experience (UX) and User Interface (UI).
M3 Evaluate a range of tools and techniques available to design and
develop a custom built website.
LO3 Utilize website technologies, tools and techniques
with good design principles to create a multipage
website
P5 Create a design document for a branded, multipage website supported
with medium fidelity wireframes and a full set of client and user
requirements.
P6 Use your design document with appropriate principles, standards and
guidelines to produce a branded, multipage website supported with
realistic content.
M4 Compare and contrast the multipage website created to the design
document.
D2 Critically evaluate the design and development process against your
design document and analyse any technical challenges.
LO4 Create and use a Test Plan to review the
performance and design of a multipage website
P7 Create a suitable Test Plan identifying key performance areas and
use it to review the functionality and performance of your website.
M5 Evaluate the Quality Assurance (QA) process and review how it was
implemented during your design and development stages.