This is a web application that provides users to do an E-commerce about opening a book store. By using the application that has an OLTP part for customers and data warehouse part for the business owner. The main feature for that OLTP part is user able to select books and then check out after finished choosing books from the application. For the data wear house part, this application has the admin page which can use for show number of books that sold per year, books which weren't sold in each year, and the number of books sold per year in each category.
We recommend using this application with MySQL server for Microsoft Windows operation system
- NPM
- Browser (Reccomended Chrome)
- MySQL server
- MySQL GUI tools (Reccomended MySQLWorkbench)
-
Clone project reposity. Go to your workspace and then clone the project.
$ cd your_workspace $ git clone https://github.com/KameriiJ/Perfecto_Online_Book_Store.git
-
Install MySQL server. You can download it here: download (download the latest version) then start a server
Or you can use docker by
$ docker pull mysql $ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag
-
Add data base to your server by using your MySQL GUI tools (In this case MySQLWorkbench)
-
Create a connection with your server as in the picture
-
Go to task server and press Data Import
-
Import the data base that is attach in this directory and set the Default Target Schema by adding new schema
then your data base is all set
-
- Last thing to be concerned. If your server has a password, you must provide that pass word for the script to start a connection you can add your password at script.js file
Then run
$(Perfecto_Online_Book_Store) node script.js
You can using application here
To go to the admin page here
