DEV Community: Lontchi12

How to Download & Install MongoDB on Windows 10

Lontchi12 — Wed, 16 Dec 2020 19:37:26 +0000

Introduction

What is MongoDB?

MongoDB is a document-oriented NoSQL database used for high volume data storage. Instead of using tables and rows as in the traditional relational databases, MongoDB makes use of collections and documents. Documents consist of key-value pairs which are the basic unit of data in MongoDB. Collections contain sets of documents and function which is the equivalent of relational database tables. MongoDB is a database which came into light around the mid-2000s.
The installers for MongoDB are available in both the 32-bit and 64-bit format. The 32-bit installers are good for development and test environments. But for production environments you should use the 64-bit installers. Otherwise, you can be limited to the amount of data that can be stored within MongoDB.
It is advisable to always use the stable release for production environments.
In this tutorial, you will learn how to Download & Install MongoDB on Windows
The following steps can be used to install MongoDB on Windows 10

Step 1

Go to the link https://www.mongodb.com/try/download/community and Download MongoDB Community Server. We will install the 64-bit version for Windows.

Step 2

Once download is complete open the Microsoft installer file. Click Next in the startup screen

Step 3

Accept the End-User License Agreement
Click Next

Step 4

Click on the "complete" button to install all of the components. The custom option can be used to install selective components or if you want to change the location of the installation.

Step 5

Select “Run service as Network Service user”. Take note of the data directory, we’ll need this later.
Click Next

Step 6

Click on the Install button to start the installation.

Step 7

Installation begins. Click Next once completed

Step 8

Click on the Finish button to complete the installation

Step 9

Go to Go to " C:\Program Files\MongoDB\Server\4.0\bin" copy the path and include in your systems environment.

Step 10

Go to your command prompt and type ‘’mongo’’.

Congratulations!!! You just downloaded and installed MongoDb on Windows 10. Thank you for your time please do not forget to like and leave a comment.

Database Design of a Restaurant Management System from user story to relational Model

Lontchi12 — Mon, 30 Nov 2020 20:51:51 +0000

The Restaurant Management System is a web application. This system is to automate day to day activity of a restaurant. Restaurant is a kind of business that serves people all over world with ready-made food. This system is to provide service facility to restaurant and also to the customer. This restaurant management system can be used by employees in a restaurant to handle the clients, their orders and can help them easily find free tables or place orders. The services that are provided is food ordering and reservation table management by the customer through the system, customer information management and waiter information management, menu information management and report. After a successful login the customer can access the menu page with the items listed according to the desired time. The main point of this system is to help restaurant administrator manage the restaurant business and help customer for online ordering and reserve table. The user can search for a menu according to his choice i.e. according to price range and category of food and later he can order a meal.

USER STORY

Restaurant Manager
As a restaurant manager: I should be able to update information about my restaurant
As a restaurant manager: I should be able to view weekly sales for my outlet
As a restaurant manager: I should be able to view the current inventory position of the restaurant
Customer
As a customer: I should be able to browse through the menu and look at the various food options available in the restaurant along with the price for each item.
As a customer: I should be able to select items from the menu and add them to my cart/order
As a customer: I should have a cart containing all the chosen items so far, accessible all the time
Chef
As a chef: I should be able to view the current queue of orders
As a chef: I should be able to accept the orders
As a chef: I should be able to update the order status to ready once the order is prepared
Waiter
As a waiter: I should be able to view the current queue to see the ready orders for pickup
As a waiter: I should be able to mark the orders as picked up on the common queue
As a waiter: I should be able to view the feedback of customers concerning the meal and service
Supplier
As a supplier: I should be able to view the inventory items so as to supply the lacking ingredients to the chef
As a supplier: I should be able to update the food items as available when supplied
As a supplier: I should be able to update information about the ingredients/food stuff and some of their advantages when consumed

ER-DIAGRAM

An E-R diagram is used to represent the E-R model. It contains all known entities for the given scenario, their attributes, identifiers, and the relationships that exist among the entities.

As seen on figure above the ER diagram has six entities which are made up of various attributes including the entity’s primary key and other attributes like the name, salary, address and phone.

RELATIONAL MODEL

The relational diagram is a graphical representation of relational databases' entities, attributes that are present in those entities and the relationship among these entities.

CHEF

Chef id is the unique id to identify the chef with a datatype of integer
Chef name is Identity of the chef with a datatype of varchar
Salary is Remuneration of the chef at the end of the month with a datatype of float

MEAL

Meal id is the unique identifier of the meal table with a datatype of integer
Price is the amount tagged to a particular quantity of food with a datatype of float
Name is the identifier of the meal with a datatype of varchar
Chef id Unique identifier comes to meal because of the many to one relationship

SUPPLIER

Supplier id is The unique id to identify the supplier with a datatype of integer
Supplier name is The name to identify the supplier with a datatype of varchar
Supplier city is The town in which the supplier lives in with a datatype of varchar
Phone is The digits used to get in contact with the supplier with a datatype of integer
Chef id Unique identifier comes to supplier table because of the many to one relationship

CUSTOMER

Customer id is The unique id to identify the customer with a datatype of integer
Customer name is The name to identify the customer with a datatype of varchar
Address is The particular place where the customer lives with a datatype of varchar
Phone is The digits used to get in contact with the customer with a datatype of integer
Waiter id is Unique identifier comes to customer because of the many to one relationship

WAITER

Waiter id is The unique id to identify the waiter with a datatype of integer
Name is The name to identify the waiter with a datatype of varchar
Salary Remuneration of the waiter at the end of the month with a datatype of float
Phone is The digits used to get in contact with the waiter with a datatype of integer

INGREDIENT

Ingredient id is The unique id to identify the waiter with a datatype of integer
Name is The name to identify the ingredient with a datatype of varchar
Description is What the meal is all about with a datatype of varchar
Meal id is the Unique identifier comes to ingredient table because of the many to one relationship

ORDERS

Customer id is The unique id to identify the customer with a datatype of integer
Meal id The unique identifier of the meal table with a datatype of integer

PROVIDES

Supplier id is The unique id to identify the supplier with a datatype of integer
Ingredient id is The unique id to identify the waiter with a datatype of integer

NORMALIZATION

The table is already in the first normal form because all attributes are atomic and each table is identified by its own unique attribute.
The table is also in the second normal form because all non-prime attributes are functionally dependent on the prime key attribute.
But the table is not in the third normal form because we find out in the supplier table that the supplier address can be dependent on the supplier city so we split the supplier table and take out the address attribute so that there should be no functional or partial dependencies.

In conclusion the restaurant management system helps to facilitate the work of a restaurant manager to manage the restaurant business and help customer for online ordering and reserve table. Thank you and hope you enjoyed.

How to Download and Install MySQL Workbench 8.0 on Windows 10

Lontchi12 — Sat, 24 Oct 2020 17:29:04 +0000

1-What is MySQL Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

2-Installation Process of MySQL Workbench

Step 1

To download MySQL workbench, visit MySQL website in your web browser and download URL:
https://www.mysql.com/products/workbench/

Step 2

Click on "MySQL installer for Windows". Then, navigate the downloading location and the file will be automatically downloaded.

Step 3

Double-click the downloaded file to launch the MySQL installer.

Step 4

Setup window will appear on the screen. Then, click on the "Next" button.

Step 5

Select the folder in which you want to install your MySQL Workbench and click on “Next”.

Step 6

Choose the setup type that best suits your needs and click on “Next”.

Step 7

"Ready to Install" window will appear on the screen, then click on the "Next" button.

Step 8

MySQL Workbench installation process

Step 9

Click on the “Finish” button when the installation is completed

Step 10

"Welcome to MySQL Workbench" will appear on the screen and you are now ready to design your databases.

Conclusion

By following the above methods, you can download and install MySQL Workbench 8.0 on windows 10 without any issues

I hope you enjoyed this document.

Thanks for reading

How to Install and Configure XAMPP on Windows 10

Lontchi12 — Sat, 24 Oct 2020 13:53:27 +0000

1-What is XAMPP

XAMPP is a free and open-source tool used by web developers in the Windows family and other platforms to set up the development and testing environment. XAMPP server comes with the XAMPP control panel to manage all its components easily.

XAMPP stands for (X) Cross-platform, (A) Apache, (M) MySQL, (P) PHP, (P) Perl and with some additional modules including phpmyadmin (for the database), FileZilla, Mercury, and Tomcat.

Once you have installed and configured the XAMPP server in your system, you can easily work with any CMS like WordPress, Joomla, Drupal and more. XAMPP server works like a local server in your system that is generally used by PHP developers to test the websites (web-projects).

This document will show you the various steps on how to install and configure the XAMPP server on Windows 10.

2-Installation Process of the XAMPP Server

Step 1

To download the XAMPP server, visit the Apache Friends website in your web browser URL: https://www.apachefriends.org/download.html.

Step 2

Click on "XAMPP for Windows". Then, navigate the downloading location and the file will be automatically downloaded.

Step 3

Double-click the downloaded file to launch the XAMPP installer.

Step 4

Setup window will appear on the screen. Then, click on the "Next" button.

Step 5

Select the components that you want to install and click on the "Next" button. By default, all components are selected in your XAMPP installation.

Step 6

Choose a folder to install the XAMPP and click on the "Next" button.

Step 7

Uncheck or Check the "Learn more about Bitnami for XAMPP" option and click on the "Next" button.

Step 8

"Ready to Install" window will appear on the screen, then click on the "Next" button.

Step 9

Xampp installation process

Step 10

Click on the “Finish” button when the installation is completed

Step 11

Start the XAMPP control panel through the "Run as administrator" option.

Step 12

"XAMPP Control Panel" will appear on the screen and click on "Start" action to start the "Apache" and "MySQL" modules.

Conclusion

By following the above methods, you can install and configure the XAMPP server on Windows 10.

I hope you enjoyed this document.

Thanks for reading.