This project is helping a global based company to design a system to cover the entire problem now they are facing about supply.
B&E is a Danish company that has more than 10 retailer shops around the UK; the products now they are selling are major supplied from Demark. The problem they are facing is the communication channel, there is no motivated way for them to use actually cover the communication problem. Because sometimes the telephone order is taken by a staff, and the retailer ring them again for confirm and another staff take the order again, therefore duplicate orders have been entered into the system for multi supply. This kind of problems always occurs.
As one of the consultant try to help to solve the problem they are facing, one of the suggestion for them is using an effective online website to cover the problem they are having.
This website will contain the supplier information, order form for supply and with the requirements that the company specified.
In this project's system design, database is a part of system function in the web-host system. Database is required to record all the data that needs to store for further view.
In database design, firstly, it must consider how many tables that need to design in order for further data store. Secondly, the entities in the tables include the data types. Some of the data must be unique like primary key in each table, there must not contain duplicate values.
Database table design
From the client requirements, the data from candidates, company users and administrators must store separately. Then while they get on the system, they need to have their unique username and password to get hold of the information that they need. When...