Category: Academic Projects

Download Free Academic Projects for CSE, ECE, EEE, Mechanical, MBA Students. Here you can download the full project source codes, reports, ppts, synopsis, DFD, Flow Charts, UML Diagrams, Design Documents, etc.

Posted on

Online Medicine Donation System Portal ASP.Net Project

Objective:

The aim and objective of this medicine donator project are to prepare a portal for the collection of unused medicine for further utilization by a needy person. The website must be like user can donate the unused medicine to NGO.
That NGO can help needy people. The user can donate the medicine.
It’s can be claimed by NGO.  They can collect from a particular place. There must be a login for the user, ngo, admin. Admin can see all details of user donated medicine. There must be a form like registration of the new user.
Medicine donate form. It’s must be tracked in the SQL Server database.

Project Description:

The Project is about the collection of medicine which is unused by the patient who recovers completely and medicine becomes waste that medicine can be collected and used further.

Modules:-

  • Membership and Registration:- To register and get membership donation of medicine.
  • NGO Details:- Different NGO’s can connect with portal and donate Medicine.
  • Donator’s details:- To Keep Donators details.
  • Help Desk:- To solves query of people.
  • Complaint and Suggestion:- Forgiving views and suggestion and also complaints if any.
  • Invoice:-Generate an invoice to give a record of their donated medicine.
  • Record Management:- To maintain the entire record properly about donators and their donation.
  • Collection of medicine:-Collection of medicine through courier.

Features:-

  • Easy to Access
  • User-friendly
  • Reliable and coordinative
  • Easy to handle

Tools and Language:-

  • Frontend: ASP.NET
  • Back End: SQL Management System
Requirements Requirements description
Registration for a new user The user firstly needs to register with the website.
Sign in for an existing user The existing user can sign in directly to the website.
Donation of medicine The user can donate any kind of medicine.
 Selection of  NGO The user can select the NGO.
Advance notification to the user The user will get a prior notification once the collection team will reach at the user end.
Notification through email The user will get a notification once the medicine is delivered.
Feedback form The user can fill up the feedback form.
Posted on

Mobile Canteen Web Application Java Project

We are in an environment where we are trying to reduce our stress and time. In today’s world time plays an important but we are but we are waiting a lot of time near canteens. Our pitch is to develop a web app to cut the lag in developing the meal to the patron. Generally, in all eatries, they follow a q-system, where we wait till our turn comes consuming a lot of time.

This Mobile Canteen web app consists of POS (Point of sale) model comprising of Inventory Management. Supplier request Functionality. Estimated time of Delivery. Users are connected to the web app through our website, where they have the liberty to order through an extensive menu without standing in the long q-lines to make orders. The user is notified with an estimated time for the meal to be ready. The user is required to complete the transaction electronically after which he is given a QR code which he needs to produce at the meal collection area.

The web app uses HTML/CSS for the displaying. At the back end, it uses Php, the database used for the cataloging the information is mysql.

INTRODUCTION

  • It is a web app.
  • It is based on the POS (point of sale) Model.
  • Its main functionalities are ‘Supplier Requests’ and ‘Estimated Time of Delivery’.
  • It comprises the Inventory Management

Process:

Users are connected to the web app through our website, where they have the liberty to order to an extensive menu without standing in long Q-lines to make orders.
The user is requested to register and make the order as he wishes, as we provide the completed data of the menu in that web app and the user is asked to select the time of delivery of the order and requested to complete the billing transaction electronically, and we provide the QR codes by showing it user can collect the preferred meal.

MODULES:

  • User
  • Admin

MODULES DESCRIPTION:

USER:

As he gets login into the account, he can view the list of food items and also can order the food. 

ADMIN: 

After validating the user details, admin generates the menu and he will confirm the list of items selected by the user.

SYSTEM FEASIBILITY

EXISTING SYSTEM:

To give the food order we have many applications like swiggy , foodpanda , spoonly, freshfood ,fasoos etc.

In this we have to choose the nearby hotels and food items then a person will come and deliver the food

PROPOSED SYSTEM:

Here we have to order the food items in the canteen application. Firstly we should register for the canteen application.

Here we don’t have any third party person to delivery the food item

Instead of standing in “Queues” at the canteen we are giving orders in applications

UML Diagrams:

Use case Diagram:

Sequence Diagram:

Activity Diagram:

Collaboration Diagram:

Posted on

Social Integration Computer Science Java Project

PROJECT REQUIREMENT

  1. Gather the information of top five colleges in Pune under Pune University.
  2. Need to study how we can add Facebook like and recommend button to our website.
  3. Need to study Twitter API’s for how we can tweet on user’s Twitter account.
  4. Login using social networking site leads to study login authentication API’s provided by social site’s.
  5. Study of meta-tags which we are going to add to our website. These meta-tags are going to help our website to come into Google search.
  6. Study of Google Analytics to collect analytics of the website. eg. How many users have visited our website & which browser they are mostly using to browse the site?
  7. Social sharing: User can be able to share the information available on the website with their respected social networking sites.
  8. We can retrieve info of the user he’s like’s hobbies and gain his feedback.

FUNCTION’S:-

Supports social login for your web – we can log in to your web application using social sites.

Social sharing – We can share the content of the web into the social sites.

Recommend & Like’s – We can recommend the contents displayed on the particular URL.

Adding required meta tags into the pages as per the social site provider

Due to the popularity of social networking site, to capture web market, posting advertising of the product  & making our product popular it’s very important to have our web supports social integration. Social integration helps for the Search Engine Optimization (SEO), Having social integration with the web it’s easy to get the popularity of the product.  Social Networking has become an integral part of our daily lives. Friends and family are really important to us and keeping in touch with them & knowledge sharing. Social networking is becoming a   way of communication.

S/W  REQUIREMENT:-  JAVA ( J2EE ) version 6.0, MySql , Apache tomcat 6+, Eclipse.

H/W  REQUIREMENT:-

  1. 512 MB main memory. (1 GB Recommended).
  2. At least 80 GB HDD (Secondary Storage Device).
  3. 14′ Monitor (Color or Black & White) for display.

UML Diagrams:

Activity Diagram:

Collaboration Diagram:

DATA FLOW DIAGRAM:

DEPLOYMENT DIAGRAM:

SEQUENCE DIAGRAM:

Social Integration ( USECASE DIAGRAM ):

Use case Diagrams:


Download the below attached Social Integration Computer Science Java Project Code & Database

Posted on

Online Medicine Search Web Application .Net Project

SYNOPSIS

This “GOOGLE A MEDICINE” is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available. This application is a solution. So, this web application is planned to develop based on the requirements of the client.

The client is a small scale pharmaceutical company that is distributing generic medicines to emergency medicines and having a good network of medical (retail) stores. Main need of the client is to prepare an online application to help the needy people in finding the availability of the medicine and a list of medical stores where the medicine is available. The visitor can quickly find the nearest medical store by selecting the area in the search tools.

This application also provides a login account to a registered medical store. Using this account a person from the medical store can update the list of medicines and their stock on daily-wise. This avoids providing outdated data to the visitor.

Emergency medical services for chronic health problems are depending on the availability of medicines. Most of the times, unavailability of medicines affect the lives of deceased persons. Addresses of medical shops that are providing 24 hours service should be made available to all. Some medical shops provide door delivery service for the needy people in an emergency even though the medical shop or distributor is not providing 24 hours service.

PROJECT DESCRIPTION

The application software is titled “ GOOGLE A MEDICINE ”.The tailor-made software which suites the requirements of a medicine searching software is developed using ASP.NET as front end and SQL SERVER as the backend

This project is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available.

This application is a solution. So, this web application is planned to develop based on the requirements of the client.

This project contains the following module:

PUBLIC PAGES MODULE:

These modules are useful in providing information to a visitor (login is not required) about the website and contact address and numbers. The homepage displays the main features of the website.

MEDICAL STORE MODULE:

These modules can do add a new medicine to list, manage existing Medicines List, and edit or Update medicines stock and maintain the application settings

MEDICINE SEARCH MODULES:

This module can do for Search and advanced search for search results and search results filtration

ADMIN MODULE (Operator):

These modules allow an administrator of the website to manage cities and manage master data. And also provide Manage Medical Store User Accounts.

DATA FLOW DIAGRAM:

USER, ADMIN, USERLOGIN, MEDICINE SEARCH, BLOOD SEARCH, SEND QUERIES Dataflow Diagrams:

 

UML DIAGRAMS

Use Case Diagram: Visitor and Facilities

Use Case Diagram: Medical-Member and Facilities

Use Case Diagram: Blood Bank-Member and Facilities


Use Case Diagram: Administrator and Facilities

USE CASE RELATIONSHIP DIAGRAMS


ACTIVITY DIAGRAM FOR ADMINISTRATOR’S ACTIVITIES


ACTIVITY DIAGRAM FOR MEMBER’S ACTIVITIES

HARDWARE SPECIFICATION:

Processor: Pentium IV

Ram: 2 GB RAM

Hard DDisk: 80 G.B Hard Disk 

SOFTWARE REQUIREMENTS

Operating System: Windows Server

RDBMS: SqlServer

Web Browser: Internet Explorer

Web Server: IIS

Technology: ASP.NET

Languages used: C#.NET

DATABASE DESIGN

TABLENAME: USER LOGIN

ColumnName DataType Description
Sno Int Sno
UserID Varchar(10) UserID
LoginTime Datetime LoginTime

TABLENAME: USER QUERIES 

ColumnName  DataType Description
UserID Varchar(10) UserID
UserQuery Varchar(max) UserQuery
Reply Varchar(max) Reply
Status Int Status

 TABLENAME : BLOOD BANKS    

ColumnName  DataType Description
Sno Int Sno
UserID Varchar(10) UserID
BankName Varchar(50) BankName
Bgroup Varchar(10) BGroup
Stock Int Stock

 TABLENAME: MEDICINES

ColumnName  DataType Description
Sno int Sno
UserID Varchar(10) UserID
MedicineName Varchar(100) MedicineName
Dosage Varchar(50) Dosage
Stock int Stock
Pdate DateTime Pdate

 TABLENAME: PASSWORD

ColumnName  DataType Description
UserID Varchar(10) UserID
SQuestion Varchar(100) SQuestion
Answer Varchar(100) Answer

TABLENAME: USER DETAILS

ColumnName  DataType Description
UserID Varchar(10) UserID
OrgName Varchar(100) OrgName
Area Varchar(100) Area
Address Varchar(200) Address
City Varchar(50) City
Contactphones Varchar(50) Contactphones

TABLENAME: USER

ColumnName  DataType Description
UserID Varchar(10) UserID
OrgName Varchar(100) OrgName
Area Varchar(100) Area
Address Varchar(200) Address
City Varchar(50) City
Contactphones Varchar(50) Contactphones

TABLENAME: USER

ColumnName  DataType Description
Sno int Sno
UserID Varchar(10) UserID
Password Varchar(10) Password

Download the below attached Online Medicine Search Web Application .Net Project Source Code & database

Posted on

Web Based Training Management System .Net Project

PRELIMINARY INVESTIGATION

1) Interview:

For making software for a company, we need knowledge of their existing system. For this purpose, we take interview of some persons working in that company.
We gather information from taking interview of that person who is related with this software. As- Training Coordinator, Hostel Warden, Trainee, Guest Faculty.

2) Group Discussion:

It was the discussion among the company people who were involved in the project. At first, many ideas were pooled in and existing themes, concepts which the other web applications were using were chosen. And then all these ideas were brought into action by the programmers.

3) Online observation :

It is the process of getting close details of the existing software or web application from the internet. The major objective is to get as close as possible to the system.The information on the TRAINING MANAGEMENT SYSTEM software was obtained from the existing web applications which are running successfully.

4) INFORMATION DESCRIPTION

Training Management System and web application:-.

1) The purpose of the application is to help the director to get details about the training, hostel, feedback, employee, expenses etc.

2) Training Details, Feedback Report, Bill generate automatically.

3) It helps the Training Coordinator to manage the training details, Trainee Information easily.

4) This application also helps to hostel Warden to manage the hostel and mess details in an easy way.

5) This application is also useful for manage detail of Guest Speaker and their lecture information.

6) It helps to manage all visits during training.

7) It also calculates the total gain and expenses of walmi from a training.

Project Objective

To facilitate the process of management of training.
To provide a software for managing trainee registration and maintaining the records.
To generate feedback information from trainees in different aspects.
To generate feedback report for a particular duration.
To maintain an account for a training easily.

Project Introduction

The application provides a login facility to different uses of the organization.
If the login successfully then they use their form.
The application provides facility to manage trainee record and account for a training to the coordinator.
The application provides facility to hostel warden to maintain the record of a trainee who is staying in a hostel.
With the help of this application, the Director sees the feedback report in a different aspect.
This application is useful for calculating expenses for a training and also calculate profit.

Data Flow Diagrams:

Data Flow Diagram of Trainee:

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Minimum Hardware Requirement

Microprocessor : Pentium or Core-i series.
Primary Memory (RAM) : 512 MB
Secondary Memory (Hard Disk) : 16 GB
Video Display Unit : VGA Monitor.
Compact Disk Drives : 52x CD-ROM.
Keyboard : 101 Key Enhanced Keyboard.
Mouse : Serial Mouse.

Data flow Diagram for Training Coordinator

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Data flow Diagram for Guest Faculty:

Software Requirement

Operating System : Windows XP , Windows Vista , Windows 7

Language : Asp.net (C#.net)

Database : SQL Server 2005

Browser : IE, Mozilla Firefox

ER Diagram:

Use Case Diagram:

LIMITATION

  • After every lecture, we have to maintain the honorarium record.
  • There is no provision for suggestion box in feedback form as it was omitted by concern authority.
  • Only Check-in and check-out record from the hostel is maintained within the software.

FUTURE ENHANCEMENT

  • Online booking facility.
  • We maintain an attendance record of a trainee during training.
  • We Provide male – female reservation in hostel.

Above limitation can be rectified as per authority requirement

Tables Description:

This is table of “CouFac”, In this table we put the information of department of faculty head.

This is table of “Amount”, In this table we put the information of Amount of whole Training..

This is table of “employee”, In this table we put the information of employee.

This is table of “Faculty”, In this table we put the information of UserId and Password.

This is table of “gTraining”, In this table we put the information of lecture of Guest Speaker..

This is table of “Guest”, In this table we put the information of Guest Speaker..

This is table of “hostelCharges”, In this table we put the information of hostel charges..

This is table of “HostelEntry”, In this table we put the information of trainee stay in hostel.

This is table of “Trainee”, In this table we put the information of trainee comes for training.

This is table of “Training”, In this table we put the information of training conduct in organization.

This is table of “Transport”, In this table we put the information of transport used for training.

This is table of “FeedBack”, in this table we put the information of feedback of trainee given for training.

Conclusion:

We made a “Web Based Training Management System” for water and land management institute. This application provide them a automated system, which is very time saving then existing system in walmi.
We test this application by the different testing method and it works properly hence it is useful for the organization.
This application easily manage the training system.

Posted on

Loss Control System for Insurance Producers .Net Project

Introduction

Insurance companies issue various types of policies to protect home and business owners from various types of unforeseen calamities such as fire, floods, theft etc.  However, prior to issuing or renewing a policy, the insurance company conducts a field survey of the property to ensure that the property is adequately secured and is not vulnerable to damage.  Thus the insurance company ensures that the chances of damage or loss are controlled.  For example, if a petrol pump has to be insured, the petrol pump owner should provide for adequate fire safety equipment, signboards prohibiting smoking near the fueling area etc.

In order to conduct these surveys, the insurance company enlists the services of independent surveyors residing near the property.  These surveyors are trained personnel and are pre-approved for certain types of activities.  The aim of the project is to develop a system used by insurance companies and surveyors to record the surveys to be done, assigning a surveyor to conduct the survey, capture, and approval of survey results, recording and approving of the surveyor’s Time and Expenses (T&E) Report. 

Workflow of the proposed system

Detailed Functionality

 1.    Record the Surveys to be done

Prior to issuing or renewing an insurance policy, the underwriting department raises an RFS (Request for Service) in LCS.  The details to be entered include –

Location to be surveyed

Type of insurance coverage (fire, theft, flood etc.)

Date by which the survey should be completed

Surveyor ID  (to be searched based on the location’s pin code)

Type of service requested (eg. Survey.  In future, the same system can be extended to verify insurance claims)

The estimated budget for the survey (This is the amount of money that the insurance company is willing to spend towards surveyor’s T & E)

The underwriter may also attach a copy of insurance policy application to RFS.

  1. Working with an RFS

Once an RFS is assigned to a surveyor, he/she starts working on the RFS.  The surveyor should be able to query the status of various RFS’s assigned to him/her.  Typical activities that are carried out by Surveyor on RFS include –

Scheduling a visit to the location – Enter the scheduled date and time in the system and update the status.

Survey the location and Write a Survey report – Attach the survey report to RFS on completing the site visit.

Writing recommendations and following-up on recommendations – Writes recommendations on the corrective actions to be taken at the location and updating the action taken on the recommendation.

Entering time and expense details – Record the time and expenses incurred to carry out the survey and the follow-up actions.  These details have to be entered by date and activity.

Close RFS – After all the details are entered, the surveyor closes the RFS.

  1. Approving Time and Expenses

The underwriter reviews the T&E reports and either approves or disapproves the expenses based on the budget.

In case it is disapproved, he/she cites the reasons for disapproval.  The surveyor is informed to update the expenses accordingly.

If it is approved, it is sent to the finance section for payment.

  1. Reporting

This module generates various reports for surveyors and underwriters.

For surveyors –  List of RFS by status,  List of RFS received or completed during a given period, Report on T & E for a given period

For underwriters – List of RFS by status (across surveyors or for a specific surveyor), List of RFS raised or completed during a given period,   T&E claimed and paid during a given period.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

REQUIREMENTS

Software Requirements:

Visual Studio .NET

Front-End: C# in ASP.NET

Back-End: SQL Server

Hardware Requirements: 

RAM: 2 GB

Hard disc: 80 GB

Test Cases:

s.no Test case name Test procedure Pre-condition Expected result output Specification
1 Login Enter userid and password Displays pay bills form success Login
2 Login Enter admin and password  

Displays the status

 success Login
3 Login Enter user and password Error message success Login
4 Pay bills Enter details Select billername, date, accountno Displays bill paid successfully success Pay bills
5 Add biller Select the biller Select billername Add biller successfully success Add biller
6 Add biller Select the biller Select name Displays as already exists success Add biller
7 View details As admin Displays list of pending transactions success View status
8 View details As admin Update status Displays status success View status
9 View details As user Edit date, amount Displays all transaction of that user success View report

Download the below-attached Loss Control System for Insurance Producers .Net Project Source Code

Posted on

Motor Vehicle Loss And Damage Claimform .Net Project

MOTOR VEHICLE LOSS AND DAMAGE CLAIM FORM (E-COMMERCE TEAMWORK)

Project Requirements

In the motor vehicle, damage and loss can be claimed online by client and insurance company store those data.

In this client fills his personal information and then the vehicle information and incident information and claim detail.

Then when the client submits the claims details form it generates the flat file and stores the entry in the database of client side. When the server will check the form of server-side and will enter claim bill number if that flat file does not exist then will show file is corrupted and if the file exists then will show all the information and if the server accepts that the information is stored in the server database.

Data dictionary

  • Client Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount
  • Server Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount

Snapshots

CLIENT SIDE FORM

 

Client filled form and by clicking on submit button flat file is generated and will be stored in client database.

ALL THE VALIDATIONS

FLAT FILE GENERATED

Server-side form

Sever side auto-filled from by entering a claim bill number and pressing read button and by pressing the save button will be stored in the database.

Download the below-attached Loss or Damage Claim form for Motor Vehicle project code

Posted on

Pick and Drop Courier Service PHP Project Synopsis

Introduction

The pick and drop item delivery Courier Service system is used to pick a product from one place and drop it to another place within the city in a specific time. This system can be mainly used when you have forgotten your product (Example: File and you’re not able to back and pick it up. This system will do this for you).

In this system, you have to enter your pick up point and delivery point. The main advantage of this Courier Service system over the courier system is you can decide the time limit i.e. within 60 minutes, within 90 minutes and within 3 hours. Based on the time you will be charged the lesser is time more you will be charged.

Existing System:

The existing Courier Service System, If you want to deliver a product from one place to another place in a city. We have to look for a courier system, But the drawback of the courier system is that you cannot decide time limit and major concern is the weight of the product to be delivered. If we need to deliver product immediately then we cannot use courier system nowadays.

If not courier system, then we have to deliver the product by ourselves and invest our time, this becomes a tedious and hectic task.

Proposed System:

Pick and place item delivery system will help you to overcome all the above problems. This System will allow the user to deliver their product within the specific timeslots within 60 mins, 2 hours or within a day. This system is not concerned with the weight of the product. This system is quick and can be used in emergency cases, example if you forget your file at your home and you want to get it to deliver at the office for an emergency meeting one can use this system.

Front End

  • PHP

Back End

  • MySQL / MySQL

Feasibility Study:

1) Technical Feasibility Study:

The System is Technically feasible because here we are using PHP and Postgresql / MySQL database which is free to use even for commercial purposes. From the user’s point of view, it is feasible because it can fulfill users requirements and maintain their records and additional feature like deciding specific timeslots are also available.

2) Operational Feasibility Study:

Operational Feasibility is the measure of how well the proposed system solves the problem and specifies the requirements in system development. Our System is Operational Feasibility as the user will get a single place where She/He can decide the pickup and drop location along with time. One will not wait for days to get deliver their product. The website will be user-friendly

3) Economical Feasibility Study:

The purpose of the Economic Feasibility is to demonstrate the net benefit of the proposed system. Our system is economically feasible as the basic amount will be decided by the system depending on distance and the user will decide the timeslot and according to that, the user will get additional charges. Less is the time more the user will be charged. The expenses will be dependent on the user.

Posted on

APMC Management System Project Synopsis

APMC management system project is for farmers and traders to sell and buy the products and manage them.

  1. Admin
  • Admin should log in and he can manage formers and traders like deleting them.
  • He can able to buy the products from the formers.
  1. Former
  • Former should register first then he can log in to the system.
  • He can sell the products where he should upload the product name product image, quantity, price per quantity.
  1. Trader
  • The trader should register and then he can log in.
  • He can purchase all the products uploaded by the formers.
  • Payment method for the selected quantity.
  1. Feedback system formers and traders. Admin can see the feedbacks.
  2. Separate product uploads option for the farmers who don’t want to register and login.
  3. View all products option at the home page.

Need 5 entities and at least 5 tables in the database and triggers should be added.

Front end: VB .net / Java

Back end: MySql/oracle

Posted on

Online Restaurant Management System Project Synopsis

This Online Restaurant Management System project is for managing the online bookings of customers for the food in a restaurant.

  1. Customer
  • The user should register first then he can log in to the restaurant. After successful login, he can order the food in that particular restaurant.
  • He should be able to see the menu items uploaded by the admin.
  • He should select the food required from the admin and quantity.
  • Then order option, after this he should enter the payment option,

Finally, order food option.

  • After booking he should be able to see the status of the booking like “your order will be received in 30 minutes”
  • Feedback system for the user
  1. Admin of the Restaurant
  • Admin should log in and he can upload the menu items like North, south and Chinese and in that he should upload the name of the food item, image, price.
  • And admin should be able to manage the food orders from the users.
  • Feedback system management.

Need 5 entities and at least 5 tables in the database and triggers should be added.

Front end : vb .net / Java

Back end : MySql/oracle