Week 5 FYP2

Week 5
Date: 03/03/2014 (Monday)

Title: Redefine the block diagram and setting upt the database


The block diagram has to be redefine to give clearer view of the overall functionality of the system.

The function of barcode scanner is to scan the barcode and send the identification of the product to the program. The program will now search in the database of the market for the product’s information based on the identification. After getting the information, the program will store all the information that it retrieved to the database of the user. The database of the user is linked to the website. User can view their scanned products and information in their account on the website via phone or computer.

Setting up the database 

The first step in constructing the software of the system is to construct the database of the system. Database can be defined as an organized collection of data. The database of the system is constructed by using MySQL Query Browser.  

The purpose of the database in the system is to be the source of data retrieval or to store any data that have been sent by the website or the program. The database of the system consists of 2 different types of databases. The first database is the customer’s database. It has the information of the customer’s account that has been registered, the shopping information, and the customer’s shopping list. The information of the customer’s account is retrieved from the website. When the customers registered their account in the website, the information then will be sent to the database to be stored. The information then will be used by the program to determine the availability of the customer’s account in the database. The shopping information and shopping list are retrieved from the program. When the customers have submitted their shopping information and shopping list, the data then will be stored in the database and later will used and shown by the website.

The database was constructed by adding schema in the MySQL query browser. And from there i just simply add the table for the schema.

Here's the video tutorial :

Customer's account information :

 

  

Note : The database was empty at first. This table is after registration of a customer. This is only to show the place that the customer registration information will be added at.

Customer's shopping information :

 


Note : The database was empty at first. This table is after the shopping trip of the customer. This is only to show the place that the customer shopping information will be added at.


 Customer's shopping list :

Note : The database was empty at first. This table is after the shopping list updated by the customer. This is only to show the place that the customer shopping list will be added at.

The second database that was created in this system is the supermarket’s database. The purpose of the database is to simulate the real world supermarket’s data base. In real world, a supermarket will update their database with all the information of the products they sell. The method is applied to this project where the products information is pre-updated in the database. The information will then be retrieved by the program. When a customer enters a product, the program will search the database for the information based on the barcode identification of the product. If the identification matches the identification in the database, the program will retrieve the information. If identification did not match, the program will tell the customers that the product is invalid.

Pre-updated products :