Monday, 25 April 2011

Bluetooth Information Website

Leave a Comment
This project covers design and development of a static website using XHTML, CSS and graphic design in Photoshop as part of assignment for Internet Development module.

The requirement was to develop a website which described a computing related topic, had a professional appearance at the front end, including a usable navigation scheme and consistent appearance and provided following functionality:
  • The Website contains five different sections about Bluetooth technology.
  • Each section has its own subfolder and its own index.html page.
  • All pages of the website use the same structure. The body of each page contains for major layers: Header, Navigation, ContentArea, and Footer. The ContentArea layer holds the other div elements with different styles.
  • All styling is defined in the separate CSS file.
  • All images correctly located in appropriately named folders.
* Material about Bluetooth technology has been taken partially from Wikipedia website and partialy from different sources on the Internet.
 
 
Read More...

Sunday, 17 April 2011

PHP Mini E-commerce application

Leave a Comment
The requirement was to develop a dynamic, PHP/MySQL powered version of Mini E-commerce website which provided the following functionality:
  • The website sells books which are grouped by categories. A user can browse the book catalogue, view book details and add the books into the Shopping Cart following a checkout page and a faked purchase process.
  • The Home page displays the newest book list.
  • The Browse page lists the recommended books which are presented based on the highest user ratings.
  • The shopping cart provides facility to change quantity and calculate the total charge.
  • The registration page collects personal information and credit card details.
  • The website supports sessions and cookies functionality. The cookies are saved for the users if they left the website without logout, and when they come back a Welcome message with the user’s name would be displayed and the automatic login would be applied.
  • The shopping cart content is saved into a session and will be presented to the logged in users, if the checkout process was postponed, when they come back.
  • Shopping Cart

  • Browse Books

  • Login

  • Home

  • Checkout Page

  • Registration


Read More...

Friday, 8 April 2011

Ficticious E-Commerce Book store based on Flex with XML, PHP, and MySQL

Leave a Comment
This section contains the documents related to design & development of a Rich Internet Application using Adobe Flex, XML, PHP, and MySQL.

This project was built as part of assignment for the Advanced Internet Development module which provided the following functionality:
  • Login: The user is provided with a means to log in and log out of the application.
  • Category Selection: The user is provided with a set of categories from which they can choose. Each category has a set of sub-categories and products associated with them. The user is able to easily locate the product they wish to purchase, or view the details of.
  • Product Selection: The user is able to locate and view details of a particular product through navigation, and add the product to their shopping cart.
  • Search: The user is able to locate and view details of a particular product through search, and add the product to their shopping cart.
  • Cart Management: The user is able to manage their shopping cart by deleting items, or changing their selections.
  • History Management: The user is able to view their previous orders as a list, with each order selectable such that the user can view further details of the order.
  • Checkout: The user is able to place their order by submitting the shopping cart to the server, along with the necessary details for payment.
The following is the architectural description of components for the entire application
  • Adobe Flex is used for the client side development of the application.
  • An XML language is created to describe the format for data being exchanged between the client and the server. An XML schema is provided for this language.
  • All exchanges between the client and the server take place over HTTP using XML documents which are valid according to the schema.
  • The server is implemented using PHP 5.
  • Data on the server side is persisted to a MySQL 5 database.
Note that security was not considered as requirements during application design.
 
 
Read More...

Sunday, 3 April 2011

XLETL

Leave a Comment
XLETL - solution for data warehouses which automates data integration of Excel spread sheets into SQL server using extract, transform, and load (ETL) process. This was my BSc (Honours) final year project. Below is the short description of the project and all documents associated with my final year project. Most of the documents have been converted to PDF, so you will need to download Adobe Acrobat Reader.

Extracting data from data sources, transforming and loading data into a data warehouse system is one of the most costs intensive tasks in the day-to-day activities of many IT companies. Data integration tools, available on the market, can be used to connect different sources and target systems to create ETL solutions but these tools are not always suitable. Many businesses' process of data exchange involves spread sheets. Internally generated or customer-provided data must be loaded into data warehouse. The purpose of this project is to design and develop the solution for data warehouse that will automate data integration of Excel spread sheets into SQL server using extract, transform, and load (ETL) process. The proposed solution is based on the idea of creating the ETL task workflow configuration for a specific data integration case, generating spread sheet template which will be used by a customer, and loading data, received from the customer into a data warehouse follow the strictly defined task configuration. This project embraces the design and development practice of variety of application types and architecture styles focusing on the utilisation of Microsoft technologies. The Unified Process Model has been used throughout the entire project life cycle. The implemented system can be useful for the small and medium enterprises that operate customer-centric businesses using a data warehouse and face data integration process on a daily basis.
  • Add database
  • Add task
  • Add timer
  • Add Transformation
  • Add user
  • Task management
  • Web login
  • Web tasks
Code repository can be found here.
Read More...