DEV Community: livingstone94

how to download and install MongoDB on windows

livingstone94 — Tue, 15 Dec 2020 14:34:08 +0000

 Follow the below steps to install the proposed file

MongoDB is a document-oriented NoSQL database used for storing large volumes of data. MongoDB is a database that appeared until the mid-2000s. It falls under the category of NoSQL databases

Figure 1: To Get the Download File of MongoDB from Website

Step 1:

Open the file. We have installed for 64-bit version with the name as “MongoDB-win32-x86_64-2008plus-ssl-v3.4-latest-signed”. It is saved in the Local Disk C:/, click on the file where you’ve saved it to start the wizard.

Figure 3

 Step 2: Click “Next“.

Figure 4

  Step 3:

Tick the check box next to ‘I accept the terms in the License Agreement’ and again click on “Next“.

Figure 5

 Step 4:

Click “Complete” to install all the features of MongoDB. As for “Custom”, this option would be used to install only the specific components of MongoDB and also if a user wants to change the location of where the installation must be done.

Figure 6

    Step 5:

Click “Install” to begin the installation drive.

Figure 7

Figure 8

   Step 6:

After the installation has been finished. Simply, click “Finish“.

Figure 9

E-LEARNING DATABASE DESIGN

livingstone94 — Tue, 01 Dec 2020 00:42:01 +0000

This article will discuss the step by step process on how to prepare the entity relationship diagram or ERD of the project entitled ELearning.

Before we process the tutorial and explanation on how to create ERD for the ELearning system, let us explain and describe the purpose of the ELearning system.

                       Brief overview of the user story

E-Learning represents an innovative shift in the field of learning, providing rapid access to specific knowledge and information. It offers online instruction that can be delivered anytime and anywhere through a wide range of electronic learning solutions such as web-based courseware, online discussion groups, live virtual classes, video and audio streaming, web chat, online simulations, and virtual mentoring.

                    We can start now!

The first step in the development of the ELearning system is to prepare that will serve as the basis later on in the creation of the actual database.

We will create and explain the process of making the entity relationship diagram of the ELearning système.

 Let’s start from the symbols used in the ER Diagram.

📎Entity is represented by the rectangle shape. The entity will be our database table of the ELearning system later on.

📎Attribute is represented by diamond shape. This will determine the relationships among entities. This is usually in a form of primary key to foreign key connection.

    We will follow the 3 basic rules in creating the ER diagram.

🔎Identify all the entities.
🔎Identify the relationship between entities.
🔎Add meaningful attributes to our entities.

STEP 1. In the ELearning system we have the following entities

📌 Student
📌 Result
📌Lesson
📌Lesson Category
📌Lesson Video
📌Quiz
📌Lesson PDF
Our design of ELearning system consists of 7 entities; the specified entities will be our database tables in the design and implementation of eLearning database schema.

We will now draw the entities of the ELearning system specified above and it will be the ELearning system.

  STEP 2

After we have specified our entities, it is time now to connect or establish a relationship among the entities.
✔ Students view their scores for every lesson (1 to many relationship).

✔ A lesson belongs to a specific lesson category (1 to 1 relationship).

✔ A lesson contains multiple videos (1 to many relationship)

✔ A lesson contains multiple pdf files ( 1 to many relationship)

✔ Every lesson has an assessment in a form of quiz (1 to 1 relationship).

        STEP 3

The last part of the ERD process is to add attributes to our entities.
Student Entity has the following attributes:
🔑ID – primary key represented with underline
🗝 Student ID No
🗝 First name
🗝 Last name

Result Entity has the following attributes:
🔑ID – primary key represented with underline
🔑Student ID – foreign key
🔑Lesson ID – foreign key
🗝Score
🗝Total Item
🗝Date Recorded

Lesson Entity has the following attributes:
🔑ID – primary key represented with underline
🗝Name
🗝Contents
🗝Category ID

Lesson Category Entity has the following attributes:
🔑ID – primary key represented with underline
🗝Name
🗝Description

Lesson Video Entity has the following attributes:
🔑ID – primary key represented with underline
🔑Lesson ID – foreign key
🗝Video File

Quiz Entity has the following attributes:
🔑ID – primary key represented with underline
🗝Lesson ID
🗝Question
🗝Correct Answer
🗝Answer 1
🗝Answer 2
🗝Answer 3
🗝Answer 4

Lesson PDF Entity has the following attributes:
🔑ID – primary key represented with underline
🔑Lesson ID – foreign key
🗝PDF File

The next step is to convert the plan designed on ER Diagram into
the actual database

        Database schema with description of table

This section will discuss the different tables of the E-learning system

📝 tbl student (id, studentidno, last name, firstname) table stores information of students such as student id number, firstname and lastname

📝tbl lesson category (id, categoryName, description) is the table that stores the category name and description

📝tbl lesson (id, lessonName, content, categoryid) table stores information about the lessons or topics, it includes the name of the lesson, the contents and the category where it belongs.

📝tbl lesson pdf (id, lessonID, pdfFile) The system can accept lessons in pdf format and the table to store that record is the tbl lesson pdf. The table is connected to the lesson and the table also stores the location of the pdf file.

📝tbl lesson video (id, lessonID, videoFile) Aside from lessons in pdf format, you can also upload a video presentation for your lessons, tbl lesson video is the table for storing the video files or the location of the videos.

📝tbl quiz (id, question, ans1, ans2, ans3, ans4, correctAnswer, lessonID) The way to evaluate if the students had gain knowledge is to give them a test. Elearning system is a way to learn things using your electronic devices such as your computers or mobile devices, it is also a platform to test your students as well. The table for storing the questions is tbl quiz, it stores information about the questions and the choices.

📝tbl result (id, student id, lessonID, score, totalItem, date) is the table for storing the scores of the student, it also includes the lesson and the date.

   Relationship of tables

The relationship is used to cross reference information between tables.

              MySql workbench
                     ⇓

HOW TO INSTALL MySQL WORKBENCH

livingstone94 — Sat, 24 Oct 2020 20:27:49 +0000

Download the installation le. It can be easily found by searching for MySQL Workbench in Google.
Install MySQL via the installe
To install MySQL using the installer, double-click on the MySQL installer file and follow the steps below

click next

4.click next to install to this folder

5.choose complete and click next

6.click install to begin installation

7.the installation is already taking place
please, wait for the process!

8.this is the end for the process
click finish

How to download and install xampp for window

livingstone94 — Sat, 24 Oct 2020 18:46:35 +0000

Downloading XAMPP
Start the .exe file
Once your file has downloaded, all you need to do is launch the .exe file.
Disable antivirus software

Disable your antivirus as this may cause erratic behavior of some XAMPP components.It is therefore advisable to deactivate the software until the installation is complete.

4.Disable UAC
Besides antivirus, User Account Control can also be a problem
when installing XAMPP. You will need to deactivate it

5.Start Setup-Wizard
Once you have deactivated any security programs that could cause problems during the installation of XAMPP, click on "next" to

6.Choice of software component

You will be able to select the components you want to install on your Computer when installing XAMPP. If you are using a test environment, it is best to be guided and install all the components. Click on "next" to continue with the installation

7.Choice of installation file
You will be able to choose the installation folder for your software and its components. By default, the software will create an XAMPP folder at the root of your hard drive.

8.Start the installation
The installer is now ready to install XAMPP. Click "Next" and wait for the installer to unzip and install the selected components

XAMPP Management Controller
The XAMPP control panel gives you complete control over all installed XAMPP components. You can use the CP to start / stop different modules, launch the Unix shell, open Windows Explorer and see all the operations running in the background. The actions offered by this interface are as follows:

Config: Allows you to configure XAMPP as well as components
NetStats: Displays current processes on your local computer
Shell: Open a UNIX cell
Explore: Open XAMPP folder in Windows
Services: Shows the services running in the background
Help: provides help links through the user forum
Finish: Close the XAMPP Management Controller