Database Management System Project

This assignment focuses on designing and implementing a database-driven application. Students will create a database schema, write queries to retrieve information, and develop a program interface to present the data to users. The project emphasizes understanding database concepts like design, query languages (SQL), and program interfaces for interacting with databases.

IT

Table of Contents
1. Introduction.......................................................................................................................................2
2. Xampp................................................................................................................................................2
3. Need for online web system application.........................................................................................12
4. System functions..............................................................................................................................14
5. Implementation................................................................................................................................17
6. Conclusion........................................................................................................................................22
7. References........................................................................................................................................22
1

1. Introduction
The project will be implemented in MySQL xampp. Requirements of the project will be
met. The screenshots will be clearly explained. XAMPP, is done by php and the required website
for the staff and the student login is created. It has all the server details for running without the
use of another computer. Basically, this bundle incorporates a few applications and
administrations all packaged together for quick and simple arrangement. The web server unit has
adaptation 1.8 that will take time to attain and will have different upgrades and fixes. As per the
requirements the login id for the staffs and the students to pass the information will be created. It
will be created for reducing the working time and to reduce the paper work. A webpage with the
Home page with the welcome note and the login page for the students and login page for the
staff. In window basic it includes the path for the website creation.
Aim
The aim is to create webpage and to provide login access to Student and the staff of the
institution, so that they can update all the details regarding the academic session and to pass
information to the students in an effective manner.
Objective
The objective for developing the online web application is to reduce paper work and to reduce
the time management. By doing this reduces the work and to increase the work efficiency. The
project provide the information about the notification or other data that is to be transferred to the
students. A flexible system with the essential documents is provided.
2. Xampp
It is developed by Apache Friends involves MariaDB database, interpreters and Apache
HTTP server for the scripts which is written in the Perl Programming and PHP languages. It is an
open source cross-platform. It is a free and web server solution stack package. Cross-platform,
Apache, MariaDB, PHP and Perl denotes as XAMPP. Xammp is a lightweight Apache
distribution. Developing process is made easy for the developers. A web server is created using
the deployment and testing purpose. Each and everything is required to set up in web server. The
extractable file includes database, scripting language and server application. XAMPP works well
on Mac, windows and Linux. It provides aids to create and manipulate databases in SQLite and
MariaDB. It has the capability to serve the web pages on www.The password-protect is the
2

significant package part. The special tool is presented in XAMPP. FileZilla program has a
benefits while installing CMS such as WordPress or Joomla.
1. It is Easy to install as contrast with other web server resembles WAMP.
2. It is Multi Cross Platform which implies XAMPP is accessible for Windows and Linux.
3. WordPress, OpenSSL, MediaWiki, phpMyAdmin, Joomla are included.
4. Both full and a standard rendition (Smaller adaptation) is offered in XAMPP.
5. It can begin and stop the entire webserver+database stack with one summon.
To create MySQL database by XAMPP
Step 1:
First open the browser. Then enter the url.
It brings MySQL setup page.
3

Step 2:
For the database, enter the name and click create button. The entered name should be in the form
of numbers, sixty four characters or less, underscores and composed letters. The number should
be avoided at the starting of the name. The proper name indicates the database purpose. The
other setting should not be changed.
Step 3:
Confirm that the database is successfully created.
4

The created database is used by any other application which needs MySQL database.
OPERATIONS: There are many MySQL operations such as update, insert, create, select and delete
by using Xampp server.
1. The foremost step is to install Xampp server in machine.
2. Then go to the Xampp folder. Then open the file xampp-control.exe.
3. Then start MySQL, FileZilla and Apache module which is displayed below.
5

4. Then open the browser. Now enter the url.
Then we can navigate the next window.
5. Now click phpMyadmin.
6. The window phpMyadmin will be presented.
6

7. Then click the database tab which show at left hand side which is displayed below.
8. Presented the next window.
9. Then enter the database name then click create button. It creates the database that get include
to recent database list.
10. Then click mydatabase which is the name of the database.
7

11. The next will be appear after click the mydatabase.
12. Naming the table as well as indicate the column number to add. Then click go button. The
field should be entered and saved.
13. Create the table structure after click the save button.
14. In the table, if we wish to insert the record, click insert tab.
15. The next window will be presented where we will insert the record into the table after
clicking insert tab.
8

16. Click browse to see the contents of the table after insert the record.
17. In MySQL database, to trigger queries, click database name which is at left hand side.
18. Then click SQL tab. The dialog box will be shown.
9

19. We could fire SQL queries.
In the table, to update the record, update command is used.
It will alter the 2nd record that has id which is equal to 2.
20. Then click browse tab. It will display updated structure of table.
21. Likely, we could use the command such as select, delete and insert to preform the
corresponding operations in the table.
22. To demonstrate the select command, sql tab is selected and the query is written in it.
23. Likewise, we could perform several operations on the database.
Hence on xampp server, we successfully performed the fundamental operations of MySQL.
10

PROCEDURES: As a matter of course, when you introduce XAMPP in your windows machine,
the root secret word for the MySQL is set to purge. In any case, this isn't prescribed, as the
MySQL database without a secret word will be open to everybody. To dodge this, a
legitimate/secure secret word must be set to the client root. To do it in XAMPP, there are two
ways.
First method:
Through the web interface, reset xampp MySQL root password:
After you began your XAMPP server, go to the program and sort the URL
Incase if the XAMPP is changed server port, you have to incorporate that port number
likewise in past URL. The security page will be indicated where you can change the root secret
word for MySQL. This will refresh the phpMyAdmin config too.
Second method:
Through SQL update, reset xampp MySQL root password:
1. Begin the Apache Server and MySQL occasions from the XAMPP control board.
2. After the server began, open any web program and give
On the off chance that you are running.
3. This will open the phpMyAdmin interface. Utilizing this interface we would manager be
able to the MySQL server from the web program.
4. In the phpMyAdmin window, select SQL tab from the correct board. This will open the
SQL tab where we can run the SQL questions.
5. Presently sort the accompanying inquiry in the text area and snap
6. Presently you will see a message saying that the question has been executed effectively.
7. On the off chance that you revive the page, you will get a blunder message. This is on
account of the phpMyAdmin design record doesn't know about our recently set root
password. To do this we need to alter the phpMyAdmin config document.
8. Open the record [XAMPP Installation Path]/phpmyadmin/config.inc.php in your most
loved word processor.
11

9. Scan for the string
And transform it to this way,
Here the 'watchword' is the thing that we set to the root client utilizing the SQL inquiry.
10. Presently all set to go. Spare the config.inc.php document and restart the XAMPP server.
3. Need for online web system application
Enhanced User Experience
Giving a fresh out of the box new instructive culture to every one of the schools over the world is
the rousing variable behind the improvement of this arrangement (Complete, Concrete, Concise,
2017). Understanding all the down to earth challenges expected to look in the running of a
school has influenced us to go for such a school administration programming, which can
guarantee you the best involvement in your decision of work (Barenji & Değirmenci, 2015).
School over Phone
The PDA amicable plan lets heads to see or alter the organization information whenever via
telephone. This school administration framework programming has been turned out to be very
responsive over iOS, Windows and Android telephones. As individuals these days lean toward
additional on telephones and tablets these propelled highlights enables your Web to class ERP
with the additional preferred standpoint to its openness. (Zhang, 2013).
Training Simplified
Our ensured and stable gushing over any programs causes heads to get to or adjust information
from anyplace whenever without interferences. Notwithstanding the move among Chrome,
Firefox or Explorer, clients can get to our product at the ideal quality (Mu, Bai, Luo & Zhang,
2012).
Speculation of the best brains
In the event that you are prepared to partake in the computerized school transformation, at that
point this is the correct goal for you. Web School ERP can manage every one of the errands that
12

you have to look in an instructive foundation in its longest run. Our master group can offer you
the best item that you are searching for and offers full control over the framework with its easy to
understand highlight (Swarup & Kapoor, 2014).
Extremely valuable for less the cost
The immense plausibility of the authoritative database that we let out for your organization
administration arrangement comes in different bundles in order to coordinate both your
specialized necessity and spending range. We guarantees best and secure reinforcement for your
school records at the best costs (Tarr, 2012).
Customizing Data
Customers have arrangement for refreshing our product for a superior reference involvement in
the organization and control of foundation information. In account with changing frameworks or
educational programs in the training, clients have alternatives for rolling out improvements
whenever. The security and protection is no chance bargained, in order to guarantee that lone the
correct client is having the control of this product (Stephan, Mohammed & Abbas, 2015).
Novel scholastic reinforcement
Dissimilar to numerous other instructive programming, the Web School ERP remains ideal for
giving extra customization includes that let information to be refreshed frequently. Multiple
access and control to our product improves the entire executives to get affirmed with the updates
(Demina & Postyrnak, 2016).
Arousing what's to come
We will be will undoubtedly be solid and submitted in contributing towards the fate of scholastic
administration. With the refined substance and outline, we keep up our principles, and with
refreshed security conventions we guarantee privacy of our customer information (Li, An & Li,
2017).
Overseeing school every minute of every day
13

Our client benefit staffs will be accessible round the clock to hear customer issues and resolve
them at the soonest. We are quite satisfied to take a shot at any of your needs with respect to our
school administration software. With Web School ERP, dealing with an instructive association is
set aside a few minutes (Qiu et al., 2012).
4. System functions
Login to the website, and use the company’s tools as allowed. The page of Word press Admin is
opened. Username and secret key are need to be entered. The username and watchword will be
given by your site designer. In order to login to the Word Press Admin, there are 3 steps to
follow
 Enter the Username and Password
 Tap the Remember Me box to stay signed in for till 14 days.
 Tap the Log In catch to access the Word Press Admin.
On the off chance that you overlook your watchword, you can tap the Lost your secret word?
Interface Follow the on-screen guidelines to get an email with a connection to reset your secret
word. When you have effectively signed in, you will be welcomed by the Word Press Dashboard
in the Word Press Admin
The Word Press Admin Dashboard
Header
 The header shows up over Word Press Admin bar.
 Name of the administrator screen that you are right now seeing
 Screen Options tab to redo the look of the current administrator screen
 Help tab for access to data about the current administrator screen
Menus
 Dashboard, Pages, Posts, and so on.
 Staff Menus: staff and Catalog
Administrator Screen
The Staff Admin Menu. From the Staff menu in the Word Press Admin, you can get to the
screens that will deal with all parts of your online store. In the event that the Staff menu does not
show up in your Word Press Admin screens, see the Installation segment for points of interest on
introducing and initiating Staff.
14

The advantages of understudies coordinating diary composing over the educational modules are
sufficiently reported. From an instructor's point of view, there are couple of exercises that can
trump diary composing for understanding and supporting the advancement of understudy
considering. Journaling turbo-charges interest. The unbelievable Toby Fulwiler, writer of The
Journal Book, expresses, "Without a comprehension of our identity, we are not prone to see
completely why we think about science instead of ranger service, writing as opposed to
reasoning. At last, all information is connected; the diary clears up the relationship."
If you need any admin login website then it may quite useful.
Strategy 1: Adding URL
This is the first and most straightforward strategy to discover administrator login page.
Strategy 2: Using Various Script
You can utilize different contents like different administrator discoverer to get the administrator
page. Here, demonstrating to you a valuable contents which will help you to get the
administrator page. Discharge my own administrator discoverer content soon and update here.
To run this content you initially need to introduce Active Perl.get it from
Presently duplicate the code of http://pastebin.com/WWZszURW and spare it as anything.pl and
run the content to get the login page of the coveted site. (Remember it’s a python Script).
Strategy 3: Crawling programming
You can utilize different creeping instrument to slither the site and get the login page. These site
slither every one of the pages of the site and demonstrate the rundown of all pages and registries.
Technique 4: Crawling
Of course different web crawlers slither the whole webpage and by utilizing robots.txt the
website proprietor really gives the rundown of connections that are not to be slithered by the
motor. Presently most of the time the administrator request that the motor not slither the
administrator page so in the event that you see the robots.txt you can get the connection to the
login page.
Strategy 5: Google Dorks
Google dorks are sometime exceptionally valuable on the off chance that you know to utilize it
properly.so here are some case of helpful Google dorks that will help you in discovering
administrator login panel of a site.
Technique 6: Using Online Admin Finder/Scanner
15

There are numerous such online administrator discoverer
Strategy 7: Tool
The World View delineate where on Earth your clients are getting to Duo secured
administrations. Effective verifications are appeared as a green checkmark, while a red X
banners confirmation disappointments. Confirmation blunders appear as a dim X, and
verification endeavors denied by an end-user and set apart as extortion are a red outcry point.
You can utilize the + and - catches to zoom in and out on the guide. The Authentication Log
records data about the last ten logons, including the date and time, he username, which
application was utilized, the second factor sort utilized, regardless of whether the validation was
fruitful or not and why, the source IP address and a rea (if the logon began from an open IP
address), and the customer OS, program, and module data. "Login" connect on the privilege to
see extra occasions can be tapped.
Heuristics principles
Framework grade
The clients are made aware of happenings about the suitable disapproval in the correct duration
by the framework.
Match amongst framework and this present reality
In its place of framework arranged terms, the clients dialect are read out by the framework to the
client using words, expressions and ideas. Data is insisted to demonstrate features and practical
demand after the honest traditions are looked up.
Client control and flexibility
Framework workings are taken up the clients using botch. A simply printed "crisis exit" which
will be out of the adverse stage without a prolonged conversation. After doing this the problem is
fixed and again tried.
Consistency and gauges
Different words, situations, or functions that is a same entity is not considered by the clients.
This is done after the traditions of state.
Blunder anticipation
16

In any situations watchful plan retains a problem beyond the blunders. The blunders that are in
liable cases are distributed. Before the clients are viewed on their action a choice of confirmation
is provided for the clients.
Assessment of acknowledgment
Client's storage stack is restricted by doing activities, stuffs and selections clear. The information
that is opening from single entertainer in the transaction is not reused by the client. At any
position framework procedures are made visible and successfully reused.
Flexibility and ability of utilization
Quickening agents — the learner client repeatedly quicken the link between the master client
with target that the framework uses only staff and students can visit the webpage to get the
notifications.
Stylish and moderate plan
Information that are irrelevant or it is essential for some time period is present in the discussed
ought. Extra information in an argument opposes with the valid information and decreases their
qualified deceivability.
Clients are allowed to observe, examine, and recover from blunders
In a simple code the blunders are conversed and problems are shown properly, and valid solution
is suggested.
Help and documentation
The framework may be used lacking documents beyond the circumstance, this will be significant
for providing support and documents. Instead it is focused on the task of the client, the
information can be several entity. Steps are made perfect but not spacious.
5. Implementation
Stage 1: Open Xampp Control Panel
Start Apache, Tomcat and MySQL servers.
Stage 2: Create Database
Create a database named test and tables are created from the queries provided in db.txt file. The
file is attached. Use Shell window option in Xampp Control Panel to do this.
17

Stage 3: Main page
All the php and html files should be presented inside htdocs folder which is located in xampp
main folder. The index.php file is the main page view and all other files are linked to it and are
performed together.
A dashboard is created using html and css and all the functionalities of login section is working
perfectly. It is done using iframes and the image section, wordings about mission, vision and the
staff/student/admin login are three separate frames and are put together into a single one in the
main page.
Index.php when opened will look like this.
18

This is the Staff section and the images will appear in the background during the login and
registration processes and it is kept at the right side and information in the left side. This format
is followed in all login and registration pages.
When new entry is selected they have to enter their staffid and new password of their desire and
the information will be stored in the staff table. Using this they can login into the staff section.
19

After entering new staf details it will be added to the database.
20

This is login page for existing staff. Only registered staffs can log in otherwise they shoud
register first by signing up in the previous page.
After logging in the following options will be available. They can update their profile, the can
view or update the student marks and finally the notification area to enter announcement to reach
the students.
21

After selection the update profile option they are supposed to enter their details so that their
profile will be updated.
22

After entering the profile details if the profile already exists then the message will come like
updated to the database. If the profile is entered for the first time then it will come like added to
the database.
Below is how the announcements are entered by the staff in the notification area and then it will
be submitted to update in the notification board of the student profile.
23

After submitting the announcement will be updated in the databse and it will be displayed in the
student profile when they look at the notification board.
The upload notes page will look like this
24

This is the page that appears when student option is selected in the first page.
25

Below is the registration page for new users. Recaptcha facility is added for security pruposes.
26

Below page is displayed when existing user select log in option.
27

When existing user in the database is entering his details successfully the main page of that user
will appear like below.
28

When update profile is selected the student can update their profile details and it will be stored in
the database.
29

When the view notification option is selected the announcements that are made by the staff will
be visible to the students.
30

The notes uploaded can be downloaded by the student by selecting the file.
31

Only one admin is in the database and the username is 12345 and password is admin. Only when
this data is entered admin page will log in. A new admin can also be added directly in the databse
if needed.
32

Since a registration page is available for both staff and student sections only the details of all the
student profile and staff profile is viewed by the admin. A admin cannot change the personal
details of any staff or student. It can be done only by that logged in staff or student.
33

34

When update databse is selected the below choices will appear
The staff id is entered and it will be removed from the database
35

After successful removal operation.
36

If wrong id is entered the below message will display.
The view report option will generate a report containing the total count of registerd staffs and
students and also the total number of announcements.
37

6. Conclusion
Thus webpage is created using the system requirements. The need for the online web system
application is also provided. This project have been demonstrated the starting ideas that will
enable you to set up improvement condition, make and oversee a database, and compose a
program that interfaces with a database and recovers information to be provided to the students.
Despite the fact that these ideas are vital ones, they are in no methods the finish of an
application. By utilizing the address book program for instance, there is still a great deal of
highlights that can be actualized in such an application. The detailed description for the system
requirement is also provided. The screenshots are explained clearly.
38

7. References
Barenji, A., & Değirmenci, C. (2015). Robot Control System based on Web Application and
RFID Technology. MATEC Web of Conferences, 28, 04001.
http://dx.doi.org/10.1051/matecconf/20152804001
Complete, Concrete, Concise. (2017). Creating a MySQL Database using XAMPP. [online]
Available at: http://www.complete-concrete-concise.com/web-tools/creating-a-mysql-database-
using-xampp [Accessed 25 Oct. 2017].
Li, Y., An, G., & Li, X. (2017). Design of All Digital Flight Program Training Desktop
Application System. MATEC Web of Conferences, 114, 02017.
http://dx.doi.org/10.1051/matecconf/201711402017
Mu, Z., Bai, X., Luo, Y., & Zhang, M. (2012). The Effect of Component Distibution Varition on
Bending Modulus of Gradient Interpenetrating Polymer Networks (IPN). Applied Mechanics
And Materials, 184-185, 1317-1322. http://dx.doi.org/10.4028/www.scientific.net/amm.184-
185.1317
Qiu, F., Ni, F., Chastain, B., Huang, H., Zhao, P., Han, W., & Di, L. (2012). GWASS: GRASS
web application software system based on the GeoBrain web service. Computers &
Geosciences, 47, 143-150. http://dx.doi.org/10.1016/j.cageo.2012.01.023
Stephan, J., Mohammed, S., & Abbas, M. (2015). Neural Network Approach to Web Application
Protection. International Journal Of Information And Education Technology, 5(2), 150-155.
http://dx.doi.org/10.7763/ijiet.2015.v5.493
Swarup, S., & Kapoor, D. (2014). Web Vulnerability Scanner (WVS): A Tool for detecting Web
Application Vulnerabilities. International Journal Of Engineering Research, 3(2), 126-131.
http://dx.doi.org/10.17950/ijer/v3s2/219
Zhang, T. (2013). Application of Fusioncharts in Web System. Applied Mechanics And
Materials, 347-350, 3069-3073. http://dx.doi.org/10.4028/www.scientific.net/amm.347-350.3069
39