This document provides an overview of how the company would like the software, database and website to function, the look and feel of the GUI and addition information relevant to the project.
1.1 Goals and Objectives
To create a front-end for a set of relational databases that provides services through the internet and to create a back-end that allow users to access, modify and query the relational databases and do additional functions that will be specified later on in the brief. Create a database by using data that is currently in a form of an excel database. Normalize database.
1.2 Statement of Scope
Normalize data provided by company and design SQL database without any redundancies using a RDBMS
At the back-end the software will retrieve data from an SQL server upon user defined queries and user must be able update the database by uploading of an excel database and the software should be able to take certain columns from the uploaded excel database and populate those to the appropriate columns in the SQL database. Software should have filter options allowing user to be able to see different data as requested. There will be an API that communicates with the company’s courier company that will log in orders automatically using data from tables from the SQL database.
Create a home page that will state basic information about the company and what the site is meant for, there should be certain links on home page (SIGN UP / LOG IN). Create a log in and sign up page that requires clients to sign up or log in. If signs up chosen, page must appear that allows client to enter certain information and store information into a SQL database and then it should redirect client to log in page where client will use entered information to log in. As soon as client logs in, they will be redirected to the dashboard page. To create a dashboard that displays certain statistics buy using the information from the SQL database tables, dashboard page will have other options that will be specified later in brief and must have links to other pages (status and schedule). Status and schedule page will allow clients to enter a serial number that when entered will display certain data that will be retrieved from the SQL database. The status and schedule pages will have additional Report that will show clients specific data exported from the database. It should also have an alternative to log in using you Facebook account
1.3 Major Constraints
• Software must operate in Microsoft environment
• Website must work in various browsers (I.e. MS Explorer, Google Chrome, Firefox)
• Back-End should have quick response time to the data.
• The information store will be a SQL database.
Please find on the attached files, a full brief of the project. Please note that if the freelancer who wants to take the project is allowed to make additions or can give us advice on how the project can be implemented (after reading the brief). We are willing to do negotiation on the whole project as long as if the final product will be of quality and we are happy with it. Thank you. We look forward in hearing from you. (We require some one skilled to advice the company on the project as well.)