ICTDBS504 - Integrate database with a website

{`
Qualification Name/Code ICT50715 Diploma of Software Development
Competency Code/ Unit(s):-   ICTWEB502 - Create dynamic web pages / ICTWEB505 Develop complex web page layouts / ICTDBS504 Integrate database with a website
`}

Structured Activities: Assessment Task 3 – Project

Written work:

Assessment tasks are used to measure your understanding and underpinning skills and knowledge of the overall unit of competency. When undertaking any written assessment tasks, please ensure that you address the following criteria:

• address each question including any sub-points
• demonstrate that you have researched the topic thoroughly
• cover the topic in a logical, structured manner
• your assessment tasks are well presented, well referenced and word processed
• your assessment tasks include your full legal name on each and every page.

Application of the unit:

ICTWEB502: This unit describes the skills and knowledge required to produce both server and client-side content. It applies to individuals working as web developers who are responsible for creating dynamic pages to provide interaction between the user and the website. They use highly developed technical and analytical skills when developing the user-website interface.

ICTWEB505: This unit describes the skills and knowledge required to design and create a web page layout, to suit a range of devices and a variety of browsers, to industry standards. It applies to individuals who work as web designers and web developers, have a highly developed understanding of design principles and apply technical skills proficiently, according to unique specifications.

ICTDBS504: This unit describes the skills and knowledge required to ensure the database is integrated with a website. It applies to individuals employed as web developers who are responsible for creating data-driven web applications.

Context

Purpose of this assessment is to assess skills and knowledge required to design web page layout and create website.

This assessment takes place in International Institute of Business and Information Technology (IIBIT) computer lab.

The following factors must be observed during assessment – please follow WHS instructions given by your trainer and ones put on the wall.

This assessment is due when you are instructed by your trainer.

You need to demonstrate ability to:

• produce dynamic web pages that include both client and server-side dynamic content
• create efficient and effective code to meet technical requirements
• test the website and code in a variety of web browsers.
• produce dynamic web pages that include both client and server-side dynamic content
• create efficient and effective code to meet technical requirements
• test the website and code in a variety of web browsers.
• produce dynamic web pages that include both client and server-side dynamic content
• create efficient and effective code to meet technical requirements
• test the website and code in a variety of web browsers.

You need to demonstrate knowledge of:

• explain web-programming concepts, including:
  • authentication and web security
  • hypertext transfer protocol (HTTP)
  • session management
  • stateless programming
• identify and describe internet technologies including:
  • programming control structures
  • object-oriented programming
• recognise and outline various web browsers.
• explain the principles of web site design
• describe and apply the following in web site design:
  • hypertext markup language (HTML) and extensible hypertext markup language (XHTML)
  • cascading style sheet (CSS)
  • hypertext transfer protocol (HTTP)
  • techniques to correct browser incompatibilities
• outline World Wide Web Consortium (W3C) standards, and explain their application to web design.
• describe a database structure
• outline Internet technology as it relates to the use of databases
• identify and apply programming control structures, including object-oriented programming and structured query language (SQL)
• explain web programming concepts, including:
  • authentication and web security
  • hypertext transfer protocol (HTTP)
  • session management
  • defining the principles of stateless programming.

Content Management System (CMS) in PHP using MySQL, HTML, CSS

A content management system is a computer program that allows publishing, editing and modifying content as well as maintenance from a central interface. Such systems of management provide procedures to manage workflow in a collaborative environment. These procedures can be manual steps or an automated cascade. CMSs have been available since the late 1990s.

CMSs are often used to run websites containing blogs, news, and shopping. Many corporate and marketing websites use CMSs. CMSs typically aim to avoid the need for hand coding but may support it for specific elements or entire pages. Source: Wikipedia

Anatomy of CMS:

Description of tasks to perform in CMS

You are requested to create a CMS for a popular company ABC Solutions, which can help to improve sales, increase user satisfaction, or assist in communicating with the public and also provide support to business goals and strategies.

The following are the requirements to create a CMS:

1. Public Area which is read only area.
   1. Site Pages
   2. Page Content
2. Admin area where the admin can perform the CRUD operations.
   1. Login page
   2. Admin Menu
3. Admin Menu
   1. Manage content
   2. Manage Admin

The following screen shots are for your reference.

The systems analysis designer has made the following implementation recommendations:

{`
Database/ Tables
Use MY SQL to create the following tables:
Subjects – ID, MenuName, Position
Pages – ID, SUB_ID, MenuName, Position, Content
Admin - ID, username, password
Note: You may use three database tables to store the records.
`}

Documentation

The CMS should have the following features:

• The homepage listing list of articles
• Navigations
• Admin login/logout features
• Add a new article
• Edit an existing article
• Delete an existing article

Remember to provide the descriptions of the database.

Produce a detailed documentation of your program highlighting the classes, data structures and database table structures to be used. You also need to provide the layout of your user interface using screen shots or story boards. Prepare a short presentation of your application with all the screen shots you have taken and present the same in the class.

Testing the Application

You are required to test your application using dummy data of your own and provide screen capture of all the functionalities of the application.

The following are some suggestions to test the CMS:

• Since CMS is a read only system, the users are not allowed to change the content, test your application as user and check if the user are able to change any content and provide the screen shot of the same. Similarly log in as Admin and check if you are able to change the content. 
• Most users expect the response in short time, say 3 seconds, and test the time taken for the navigation to open.

Using above as reference create atleast five more test cases and test your application. The screen capture of all your tests has to be provided.