Tag: DBMS

DBMS Project on Wildlife Sanctuary Management System

The project, Wildlife Sanctuary Management System is a web based application which is easy to access and user friendly. The application uses HTML for front-end display, PHP scripting language for interacting with database, MongoDB Database to store data regarding products and users behavior and EasyPHP Server.

The purpose of this application is for smooth administration and to get a brief idea of overall expenses and profit the sanctuary deals with. The application keeps a backup of the tourist data which includes their ticket details, the fare they pay and the donations they make out of good heart for the welfare of wild animals and different initiatives.

The application is fully optimized shopping website where it can  handle images, tourist data, animal data, feed cost, staff salary, expenditure and is in normalized form.

Software Used:

  • EASYPHP DEVSERVER 14.1
  • BROWSER
  • MongoDB Database

Concept Used:

  • MONGODB-(DATABASE BACKEND)
  • HTML & PHP-(FRONT END)
  • EASY PHP-(CONNECTIVITY)

Click the link to download the Project for Free: Wildlife Sanctuary Application

  • Home
  • Tag Archives: DBMS
Filed under: DBMSTagged with: , , ,

DBMS Project on Online Shopping Management System

The project, Online Shopping Management System is a web-based application that sells products to customers in very easy and convenient way. The application uses HTML for front-end display, PHP scripting language for interacting with database, MongoDB Database to store data regarding products and users behavior and EasyPHP Server.

The application can be used by two kinds of people like manager to manage the products, their prices, photos, etc. and customer to buy products. The application gives the managers powers like remove products, add products, update product, change price, stocks, descriptions and much more while the customers get the power of buying the products, getting the total amount of purchase and billing.

The application is fully optimized shopping website where it can  handle images, total amount of purchase, billing, description, title, price, add to cart, order delivery records, stocks remaining and in normalized form.

DBMS Mini Project Online Shopping Management ER-Diagram
ER Diagram

Features: Clean separation of various components to facilitate easy modification and revision. 

All the data is maintained in a separate file to facilitate easy modification. 

All the data required for different operations is kept in a separate file. 

Quick and easy saving and loading of database file.

Database Design Model / Tables and Columns names: 

  1. LOGIN table contains user, pass, fname, lname, address, pincode, phone
  2. ORDER_DETAILS table contains buyer fname,buyer lname,buyer address,buyer pincodebuyer phone,buyer purchase pro_id, buyer purchase pro_name,delivery date,purchase date,buyer purchase pro_price
  3. PAYMENT table contains buyer fname,buyer lname,buyer address,purchase date,buyer phone,buyer purchase pro_id,buyer purchase pro_name,buyer purchase pro_price,buyer pincode
  4. PRODUCT table contains product id,product name,product desc,product price,product stock,product image

Concept Used:

  • MONGODB-(DATABASE BACKEND)
  • HTML & PHP-(FRONT END)
  • EASY PHP-(CONNECTIVITY)

Software Used:

  • EASYPHP DEVSERVER 14.1
  • BROWSER
  • MongoDB Database

Click the link to download the Project for Free: Online Shopping Application

  • Home
  • Tag Archives: DBMS
Filed under: DBMSTagged with: , , ,

DBMS Project on Hardware Store using MySQL and PHP

The Project, Hardware Store is a web based application for selling hardware products online. The application uses HTML for front-end display, PHP scripting language for interacting with database, MySQL Database to store data regarding products and users behavior and Xampp Server.

The application can be used by two kinds of people like manager to manage the products, their prices, photos, etc. and customer to buy products. The application gives the managers powers like remove products, add products, update product, change price, stocks, descriptions and much more while the customers get the power of buying the products, getting the total amount of purchase and billing.

The application is fully optimized shopping website where it can  handle images, total amount of purchase, billing, description, title, price, add to cart, order delivery records, stocks remaining and in normalized form.

DBMS Mini Project Hardware Store Management System

Software Used:

Procedure / Steps to configure project:

  • Download the XAMPP and install and run MySQL and PHPMyAdmin.
  • Download the Source Code(given below) and extract the .rar file.
  • Copy the Source Folder in XAMPP -> htdocs.
  • In browser type -> http://localhost/phpmyadmin and create the following DATABASE in PHPMyAdmin

Create database named hardwarestore

  1. In hardwarestore -> create table as cart -> in cart create column as p_id as primary key.
  2. In hardwarestore -> create table as product-> in product create column as product_id as primary key, product_title, product_img, product_desc, product_stock, product_price.
  3. In hardwarestore -> create table as users -> in users create column as uid as primary key,name, email, password.
  4. Now in your browser type -> http://localhost/hardwarestore where main.php is the homepage where you can edit, add, delete, and update the products.

Note: Remember you can edit your project files in Folder -> XAMPP -> htdocs -> hardwarestore

Click to download free project : Hardware Store Application using PHP and MySQL

  • Home
  • Tag Archives: DBMS
Filed under: DBMSTagged with: , , ,