Crystal Market E Kart Web Portal Project

Abstract

This concept basically related to a portal which will allow dealers or vendors and customer linking on a common platform. This portal will be a web platform wherein vendor will register and add crystal products. They can also differentiate and highlight special crystals as per horoscope ( as they have a huge market). Once crystals are added they will be available for sale which can be searched and added to kart by customers for buying. Portal will provide an easy to use and responsive website.

Project Description in Brief:

The requirement will be to develop an admin module which will be used to sell products, register vendors, register customers, cart functionality and related crystals functionality. We can also manage coupons from admin panel. This will also involve web service / API which will communicate with Website front end and database and save data securely via admin panel.
We will also have employee management wherein executives delivering the sold products to customers will be registered and in turn, will track the delivery part. The application will involve order management and delivery. This will involve executive, the order created and tracking id.
The application will have an informational part too like About US, Terms & conditions, Privacy policy etc which basically will be static pages.

User Types: Admin, Customer, Employee logins (no vendor login as discussed)

  • Admin will have access to all modules in the web and can monitor everything in the application.
  • Customer / Buyer will have access to crystal products view and can browse through and access offers and then finally add products to the kart and order the same.
  • The employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only
  • Vendor / Seller is basically related to sellers who will register themselves, add their products to the admin panel and the added products will be marketed via the website.

Modules:

Users Modules: Will involve login, registration and log out as the basic functionalities. Users will also have My basket functionality to manage the crystal products added to the kart. My orders will deal with the story of transactions and orders for a logged in and registered customer. My profile will have edit, delivery address manage option, change the password and other details that are necessary.

Admin Panel: Admin being an important module will manage delivery executive employees and their delivery history as it will be linked to order and delivery management. Customers also will be managed by the admin panel. Vendors will register to the application and we can manage vendors via admin panel. Registered vendors will be able to add their products which will be advertised for sale in the crystal market portal. Admin will most importantly manage the categories and subcategories that are involved in adding products and then their sales via the portal. It will also manage the filters that will be provided for searching for various types of crystals.

Kart Module: This Module actually will handle the addition of crystal products which are anticipated to be ordered by a viable customer.  It will be then linked to order management and delivery tracking.

Delivery / Order tracking: It will basically show which order is linked to a particular executive as admin will assign it to a particular executive. Complete delivery status can be tracked in this module. As per order management is concerned once a product is confirmed in kart it will be transferred to order tracking as an order id is assigned to it. And then a delivery executive is assigned an order. This workflow actually provides a flexible tracking system.

Future Enhancements:

  • We can come up with SMS alerts for delivery tracking and registration messages.
  • We can provide reports module with a different type of reports for admin login related to sales, order and delivery reports.
  • We can also introduce a comprehensive invoice module too.
  • Add coupon management system via admin panel

Technology to Use

  • HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior
  • Bootstrap / Angular JS will be used for making the site responsive and as a framework.
  • PHP (CodeIgniter, CakePHP, Phalcon or Laravel) OR .Net with framework
  • MySQL
  • SQL Server

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Java Mini Project on Vehicle Hiring System

ABSTRACT

Vehicle hiring system is a web-based application designed to provide the user with an easy way to hire vehicles like cars, buses, vans, lorries etc on rent.
The customer has to choose the vehicle of his choice, the location where he wants to board the vehicle and pay for the rental online.
This application calculates the fare based on three categories short distance, medium distance, and long distance.

INTRODUCTION

Vehicle hiring system is a web application which includes an end user i.e, a customer in which they can make a reservation and view other related information about their reservation.
The administrator has all authorities to change and manage the system such as adding a new vehicle, removing and updating any related information about the vehicle and keeping track of all vehicle reservations.

Existing System

  • The current system does not have wide ranges of vehicles available.
  • The customers do not have the facility to give feedback.
  • Description of vehicles is less.

Proposed System:

  • A wide range of vehicles including vans, two-wheelers, buses etc., are available.
  • Feedbacks and reviews from the users can be taken.
  • A detailed information about the vehicle is available.
  • Notification on timings and pickups is available.

Modules:

ADMIN MODULE:

Admin can view/edit/delete vehicle and driver details and has authority to view transaction details of the users.

USER MODULE:

This module enables the user to Login/ Register, view vehicle details and hire vehicle and perform the transaction.

Admin Login Details:

  • Step1: Start
  • Step2: Login to the account with a unique username and password
  • Step3: Choose from the options
  • Add vehicle (car/bus/2 wheeler etc.,)
  • Add/Delete/update vehicle details
  • Step-4: View vehicle reservations of the users
  • Step-5: Confirm vehicle reservation and calculate fare based on distance.
  • Step-6: Stop

Customer Login Details:

  • Step1: Start
  • Step2: Login to the account with username and password.
  • If not registered, register by filling required details.
  • Step3: Hire the vehicle and enter details such as date, duration, and boarding location.
  • Step4: Confirm the reservation.
  • Step5: View bill and make payment.
  • Step6: Stop

Flow Chart:

ER Diagram:

Sequence Diagram:

Collaboration Diagram:

DATA FLOW DIAGRAM:

Database Tables:

Admin Table

  • admin_id number(32),
  • name varchar2(256),
  • email_id varchar2(256),
  • constraint pk_admin primary key(admin_id)

Vehicle Table

  • vehicle_id number(10),license_no varchar(20),model varchar(20),
  • status varchar(20),
  • drate number(10),
  • Status varchar2(20),
  • constraint pk_vehicle123 primary key (vehicle_id),
  • unique (license_no)

Customer Table

  • c_id number(32),
  • name varchar2(256),
  • email varchar2(256)
  • address varchar2(256),constraint pk_customer123 primary key(c_id)

Feedback Table

  • fid number(10) not null ,
  • message varchar(140),
  • email varchar(50),customer_id number(10),
  • constraint pk_feedback primary key (fid),constraint fk_feedback foreign key(c_id) references
  • customer(c_id)

HIRE Table

  • hid number(10) not null ,
  • hdate date,
  • amount number(10),
  • vehicle_id number(10),
  • constraint fk_hire primary key (hid),
  • constraint fk_hire foreign key (vehicle_id) references vehicle123(vehicle_id)

BILL Table

  • bno number(10) not null,
  • bdate date,
  • Famount number(10),
  • hid number(10),
  • Constraint pk_bill primary key (bno),
  • constraint fk_bill foreign key (hid) references hire(hid)

Real Estate Website Academic Project

Abstract

Project Understanding:

As per our discussion, we need to design a website for a real estate company which deals with plots for sale and luxury apartments. We also had a discussion in regard to few clarifications and inputs from your side specifically to understand the project flow. In this document, we present our understanding of what needs to be accomplished in the project along with the budget and time estimation.

Project Description & Statement:

To design a website which will have the option to view the upcoming project, completed projects and related info for the purchase of plots. It will have the option to book site visit and download brochure as needed. We also provide an option to upload pictures related to completed projects and upcoming projects which can be viewed on the website by anyone who visits the site. For managing pictures, visits and maintain customer information we will provide admin panel.  It will be connected to DB via a customized, eye catchy and responsive front-end website and thereby save the data in a secure way.

User Types:

Admin: To manage information that we will show on the homepage and manage images that need to be used for promotions and advertisements. Will also have access to upload pictures in gallery page of the website.

Modules Description:

  • Home Page Design/splash screen
  • Home Page with Menu Features
  • Gallery
  • Contact US
  • Projects
  • Logo / About US
  • Admin Panel/pages
  • Web Service API

Workflow:

Contact Us page will provide an address, phone and email id information related to the customer. Will also have the option to submit any queries. We will need SMTP configuration related details to configure the same.

Homepage with menu features will have scrolling banner and option to get access to projects (upcoming, completed, ongoing), gallery, the board of directors, blogs (if needed) etc. All features in the home page will be responsive and we will use the framework to achieve the same.

Admin panel will have the option to add pictures to the gallery page.  Will initially add two service types as Luxury apartments and Plots for sale. Depending upon service selected pictures that will be scrolled on the home page will change dynamically. All those settings will be configured in the admin panel.

About US page will be showing details related to partners of the organization like their images and a brief description.

Admin panel details:

Sl No Task / Module
1. Admin
Admin Login, Forgot Password, change the password
2. Customer registration
Registration details info in admin panel with options: Name, Phone, Email, City, State, Comments
3. Category Create category types depending upon the activities carried out by the organization
4. Images module Will have image name, category type id, description etc

Technology:

Design and Markup

– HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior

– Bootstrap / Angular JS will be used for making the site responsive and as a framework.

Server-side language (anyone can be used depending upon your preference)

– PHP (CodeIgniter, CakePHP, Phalcon or Laravel) OR .Net with framework

Database Software (anyone can be used depending upon your preference and server setup)

– MySQL

– SQL Server

Hardware Requirements:

Intel Core processor

RAM 4GB and Above

HDD 100 GB Hard Disk Space and Above

64 or 32 bit OS Windows 8 and above

E-kart Website WordPress Theme Project

Abstract

In today’s day to day life purchasing of products by visiting stores has become a tough job. As a standing in a queue for making the payment of the product has become difficult for customers. To overcome these difficulties, we are coming up with E-kart.

E-Kart is an e-commerce website which helps to choose a wide range of products through your desktop or smartphone rather than visiting the outlets. It is developed using word press which is an open source blogging platform and content management, the basic e-commerce functionality in word press can be achieved through Magento. It is been developed to handle accurate stock and also to overcome a payment gateway problem. E-Kart ensures that it accepts a review from our genuine buyers.

Word press power stats save the tracking information and analytics data in the backend. E-Kart uses “Machine Learning” analysis to know the exact number of customers visiting our site track user engagement, it also shows us the product with high demand in that particular to understand the seasonal market demands for seasonal product supply.

The Modules used in the project are

1. Admin
2. Customer

Admin:

Admin will login into the application with the default username and password. Admin can add and edit the products and product details. He can also view the orders placed by customers and reviews by customers. Admin can also view the abandoned cart products and featured products. Admin can also view the payments.

Customer:

The customer can view the application by registering or without registering as a guest user. But the guest user has limited functionalities compared to the registered user. Registered customer must log in with the username and password after logging in he can select the products and add them to the cart. After the product is selected customer needs to provide some additional details like shipping address after that the payment will be initiated by the customer, after successful payment the customers will get 3 emails listed as Order copy, Delivery Details Copy and Thanks Copy.

In this application, we used 2 Plugins namely in this application they are

1. Akismet
2. Recomendo

Existing System:

In the Existing system, we are experiencing high crowd in the stores which make for us select the products and making the payments also takes a lot of time in some reputed stores.

Proposed System:

In Proposed System the admin will maintain a wide range of products at affordable prices for customers and it makes easier for those who buy in the application. If a customer leaves the product in the cart without buying and exits the application then the customer will get the mail after particular threshold time.

UML Diagrams:

Use case Diagram for Admin:

Use case Diagram for Customer:

Sequence Diagram for Admin:

Sequence Diagram for Customer:

Activity Diagram:

Class Diagram:

Mini project on Program Outcome Assessment

Abstract

Program outcome assessment application is an online assessment application which enables the faculty to add Course outcomes of their respective subjects and map it with program outcomes of their course.

This application also helps the students to view the course outcomes of their respective subjects.

Assessment is used to identify that how each course is contributing to program outcome.

Existing System

  • Course Outcomes and Program Outcomes mapping are done manually.
  • The head of departments will have to wait for the faculties to submit the outcomes.
  • It is a time-consuming process.

Proposed System

  • The faculties will add the course outcomes of their respective subject and the administrator can view by logging in.
  • Mapping is done by keeping the correlation level in the range of 1-3
  • It segregates the subjects and it is user-friendly.

Modules

Administrator

  • adds branches and courses
  • update courses
  • performs an assessment of course outcomes with program outcomes

Faculty

  • adds their respective course outcomes and perform mapping of course outcomes with program outcomes

Student

  • can only view the courses

Admin Functionality:

  1. Start
  2. Login into the account, if not registered register with required details.
  3. If the user is administrator they can login, add branches, new faculty and courses.
  4. Performs assessment of course outcomes with program outcomes.
  5. Stop

Faculty Functionality:

  1. Start
  2. Login into the account, if not registered register with required details.
  3. If the user is faculty, they add course outcomes of their respective subjects and performs mapping of course outcomes with program outcomes.
  4. Stop

Student Functionality:

  1. Start
  2. Login into the account, if not registered register with required details.
  3. If the user is a student, they can only view the course outcomes.
  4. Stop

UML Diagrams:

ER Diagram:

Level-0 Data Flow Diagram

Level 1 Data Flow Diagram:

Level 2 Data Flow Diagram:

Sequential diagram:

Collaboration diagram:

Database Tables:

Admin Table:

  • admin_id number(10),
  • name varchar2(20),
  • password varchar2(20),
  • email_id varchar2(30),
  • address varchar2(200),
  • constraint pk_admin primary key(admin_id)

Faculty Table:

  • faculty_id number(10),
  • course_id number(05),
  • password varchar2(20),
  • branch varchar(10),
  • constraint pk_faculty primary key(faculty_id)

Student Table:

  • student_id number(10),
  • password varchar(20),
  • student_name varchar(20),
  • constraint pk_student primary key(student_id)

Course Objectives Table:

  • course_id number(10),
  • course_desc varchar(20),
  • course_outcome varchar(20),
  • constraint pk_courseobj primary key(course_id)

Program Outcomes Table:

  • po_id number(10),
  • po_desc varchar(20),
  • po_average varchar(20),
  • constraint pk_programoutcomes primary key(course_id)

Vehicle Detection System Using GPS Project Synopsis

Abstract:

Nowadays there are many accidents occurring at turnings, these occur due to over speed of vehicles across turnings, and the drivers don’t come to know about the vehicles approaching them at turnings. Due to this, many people lost their lives. We can avoid these accidents by developing an application which can detect the exact location of multiple vehicles using Global Positioning System and alerting the user on turning, by providing the information regarding no of vehicles approaching towards the user.

Introduction:

  • This application will detect the current location of the vehicle and notify if there are any vehicles approaching on the other side of the turnings. So this will minimize the accidents at deep curves.
  • We use GPS and microcontroller to know the locations of the vehicles.
  • It sends an alert to the respective driver on detecting the nearby vehicle.

Existing System:

  • The present system for vehicles to check the opposing flow of traffic is to look through concave mirrors which are placed at the side of the road.
  • These concave mirrors are very convenient to use as it can be placed anywhere without any restrictions.
  • But these concave mirrors doesn’t work when the vehicles are overtaking on a single road.
  • And when the vehicles are at high speeds drivers normally can’t take their eyes off the road, so they don’t observe the mirrors. This will lead to accidents.

Proposed System:

  • In order to overcome the risk of accidents, we propose the idea of “Vehicle Detecting System”, which gives an alert to the drivers, about the opposing vehicles within a particular radius of the vehicle, through the phone.
  • This application works on GPS.
  • It takes the location of vehicles and alerts the drivers if there are any vehicles within the radius of their vehicle.
  • The phone acts as a GPS module to know the location of the car and the phone/microcontroller acts as the receiver of the alerts sent to the driver.

Use Case Diagram:

Easy Search Guide Java Project

Abstract:

Are you new to the city? Confused where to go on a weekend or could not find any relevant information on the internet about a destination to spend your quality time. Don’t worry that’s what we are going to provide you. A single place where one can find all the malls in your city, with detailed information about the things one can do like shopping, watching movies, dining, and gaming for kids.

This Easy Search Guide application not only provides details of malls but also provides offers one can avail in the shopping stores or in restaurants and also current movies running, with everything reviewed and rated by the users. We make everything easy for the users with our information so that users can easily find their next shopping destination or a place where the family can spend their day out without any hassle.

Existing System:

Though we have applications to find the restaurants nearby or you can find the malls nearby on maps. We don’t have any single application that provides information on all malls and restaurants along with offers and reviews altogether. We don’t know about the deals or offers provided by a store at the mall until we visit in by a person. We even cannot find such information on the web.

Proposed System:

We are going to build a responsive single page web application using HTML5, CSS3, and React.Js for the front end part and Node.js with a relational database to process the data from the database and provide it to the front end. We choose React and Node. js because of their maintainability, prototype, fast nature, and reusability.

The Easy Search Guide application will list down the malls nearby using geolocation API or the user can manually select from the list of cities provided. When clicked on the mall list of categories will be available like shopping, dining, entertainment depending on the selection, the user will be shown the list of shopping stores or restaurants or movies available and the current offers which user can avail. Users can see the rating or reviews of the shopping store or restaurant and if they want to add a review or rate a store or restaurant they need to log in with their Google or Facebook account.

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

Banking System through Voice Java Project Report

ABSTRACT

Overview:

This application is about the banking system through voice. The main aim of this application is to provide an easy way to fund transactions from one account to another account with the help of telephonic conversation.

Current Scenario: 

  • The present scenario has only two ways for transfer the funds from one account to another account. They are either doing the manual transactions on bank or using internet services.
  • This will become as a drawback for the people those who don’t have the internet service and those people who don’t know how to use internet.
  • We may not have a chance to every time come to bank.

Proposed Scenario: 

  • To overcome this type of problem, we are finding a new way which is used very easy by every common man is “VOICE BANKING”.
  • This will become very use for the people those who don’t have the internet service and those people who don’t know how to use internet. 

Application Features: 

  • Should provide the security for account holder name and credit card number.
  • Provides easy way of transfer the funds from anywhere.
  • Getting account holder information. 

Purpose of the project:

The purpose of this project is to use the services of bank like money transfer, knowing about the loan information, our account balance; our statement and we can also make and activate our cheque book request and internet banking services through voice only and without using any internet service. 

INTRODUCTION

There are a number of applications for speech coding. One of its applications is in “VOICE BANKING”. Speech coding plays an important role in voice banking where the compressed words from a telephone line are to be recognized by the speech recognizer used at the banking end. The speech recognizer at the banking end tries to understand the compressed spoken words in some way or the other and acts thereafter. With voice banking, the user can access the following services.

  • The user can check for balance on all his savings, current and loan accounts.
  • The user can know the history of his account like the debits, recent deposits, interests and check payments.
  • The user can make loan payments and Funds Transfer between two accounts.
  • The user can check for interest rates on various types of loans and on deposits.
  •  The user can stop the payments to be made.
  •  The user can make a report about the stolen or lost card.
  •  The user can have information about the ATM locations, bank branches and working hours.
  •  The user can speak at any time of the day to the bank’s customer service centre.

SOFTWARE REQUIREMENTS:

  1. Prophecy -8.0.98.2
  2. Jdk 1.5 (or) 1.6.
  3. Oracle 10g database.
  4. Tomcat web server.

INPUT AND OUTPUT

Inputs:

  • Users enter his or her account number and password.
  • User should select one from main menu
  • For fund transfer user should enter receiver account number and amount.
  • For any request user should prompt yes or no. 

Outputs:

  • Account information.
    • Balance enquiry
    • Successful creation of cheque book request
    • Successful activation of internet banking.
  • Loan information details.
  • Get the details of education,home,business and car loans
  • Fund transfer.
  • The amount of rupees 5000 is successfully transferred from sender account number. (When it is valid receiver account number).
  • Sorry the mentioned account does not exist. (When it is invalid receiver account number).
  • Call transfer.
  • User may contact with manager/assistant manager. 

Entity Relationship diagrams:

System Work-Flow:

Use Case Diagram for Main Menu:

Use case for fund transfer:

Class Diagram:

The sequence for the main menu:

Sequence for Account Information:

Sequence for Loan Information:

Sequence for Fund Transfer:

Sequence for Statement:

Sequence for Call Transfer:

Collaboration for Loan Information:

Collaboration for Fund Transfer:

Collaboration for Statement:

Collaboration for Call Transfer:

State chart diagram:

Activity diagram for Main menu:

Activity diagram for Account Information:

Conclusion

Voice banking is a very useful banking service in our daily life. Using it the users can access to their account information and other banking services like to know about the loan information and user also transfers their money to other users in 365 days a year, 7 days a week and 24 hours a day just by making a simple phone call.

College Information Management System (CIMS) Application

College Information Management system (CIMS) application that effectively manages the storage and retrieval of information on the internal network of a college. In other words, it is a web application for a college.

How a College Functions?

    There are many activities that take place in a college. They are below

  • Admissions: The traditional process of admission requires a student to collect the admission forms, fill them and submit them to the college.
  • Student Enrollment: The student applications are screened and those found suitable are called for an interview and finally selected. 
  • Planning and recording schedules: It is necessary that every college prepares its own academic timetables for:
    1. Classes for each course.
    2. Sports and games.
    3. Extra curricular activities such as competitions and cultural activities.
    4. Meetings and seminars held to review academic schedules teaching strategies and other requirements of the college. 
  • Staff recruitments: the college periodically recruits Teachers, Professors, and Non-teaching staff members. Records on their salaries leave the position, etc., need to be maintained by the college.

As listed above the CIMS application should allow performing all the activities and if possible additional activities in a more easy and efficient manner. This application should be highly scalable and customizable for different types of colleges depending on their requirements.

The application should have an interface for accessing and retrieving data about students and staff and the college itself.

  1. A database management system in which data can be stored safely, while also being easy to access.
  2. A website for the college where outsiders can obtain information about the college.
  3. A central server that controls all the information of the college and also hosts the website of the college.
  4. An internal communication system for exchanging information, scheduling meetings and conferences. 

The following list gives an overview of what CIMS may contain.

This is abstract information about a college process.

Admissions for staff and students

  • Academic details – attendance, exams, marks.
  • Complete fee details, course wise and student wise.
  • Exams – performance.
  • Library Management.
  • Staff: Teaching, Non-Teaching.
  • Leave: Students, Employee
  • Attendance Students, Employee
  • Courses – currently offering, new courses.

Miscellaneous

  • Timetable
  • Curriculum scheduling
  • Calendar 

Reports

  • Student academic report
  • Student TC details
  • Leave Reports
  • Pay Slip
  • Library Report
  • Department wise report
  • Full Academic report 

Planning intranet for a college Requirements   Data management between departments of a college.

Every college has staff and students and all the data related to students and staff that are maintained in college records in the form of files. Similarly, the college maintains the daily activities such as timetable, year wise curriculum, and examination schedules. Maintaining such huge data for years the college needs

  • Manpower
  • Space in the office to maintain shelves, cabinets, and racks
  • Good administration strategy
  • Perfect organization
  • Ease of use
  • Efficient data retrieval 

That is we need to have an environment that is organized with numbered file cabinets. In such a system every folder has its place.

But maintaining such an extensive file system is not possible manually and it is also not cost effective.

Now the question is what makes it easier to maintain such data?

The solution is computerizing the management system.

  • Online website.
  • Internal file management.
  • Keep track of student and staff files.
  • Library management system.
  • Scheduling conferences, news, and announcements.

In order to develop the intranet, we need to do analysis about the requirements of the college system. After the analysis, we need to design the structure flow and model of our Intranet Project. We then need to write programs in Java and integrate to test and deploy the Intranet for a college.

What are the analysis and design, what does it include? 

Analysis:                   

This deals with an investigation of a whole product part by part. It is the abstract separation of a whole into its constituent parts for study. The analysis of any particular project is the paramount requirement before any other operation

Design:

It is a preliminary or initial sketch indicating the basic plan required to execute the project.

Think of what we need to build.

Identify the data needed to be organized in the INTRANET.

  • Student data
  • Staff data
  • Books data

Student Data:

Students may be categorized into two types. An enrolled student and a new student to enrol. The fields that specify the students are as follows.

Admitted Students

  • Personal information
  • Name
  • Parent
  • Address
  • Contact information
  • Date of birth
  • Gender
  • Academic information
  • Admission number
  • Course joined
  • Date of joining
  • Remarks

 Application form for new students

Personal information

  • Name
  • Parent
  • Address
  • Contact information
  • Date of birth
  • Gender

Academic information

  • Applied date
  • Previous college information
  • Previous degree details
  • Course applied for
  • Percentage of marks
  • Application id
  • Application mode (online/offline)
  • Nationality

Official details

  • Accept/Reject
  • Remarks
  • Application mode 

Staff data:

The staff may be categorized into two types, teaching, and non-teaching staff.

Personal and general details

  • Name
  • Gender
  • Nationality
  • Contact information (permanent/present)
  • Application mode
  • Professional job experience
  • Income details

Book data:

Managing the data concerning books is called Library management.

Student Details

  • Student identification number
  • Student name
  • Student address
  • Date of issue of the book
  • Phone number

Book Details

  • Book code
  • Book name
  • Price
  • Number of copies
  • Author
  • Publication
  • Edition
  • Course
  • Transactions
  • Book code
  • Student identification number
  • Date of issue
  • Due date
  • Date of return

Conferences, meetings, news

  • Date
  • Time
  • Purpose
  • Audience
  • Place

 Others

  • Website data
    1. College history
    2. Curriculum
    3. Courses offered
    4. Achievements
    5. Contact information

  Designing the project

    This includes

  • Finalizing the flow
  • Establishing relations
  • Designing the GUI
  • Organizing the data management

Plan for flow

  • Login
  • Main window
  • Options to view students, staff, library, schedules
  • Student
    1. Admitted
      • Select a classroom from list
      • Next, Previous, Add, Save, Modify, Home, Search.
    2. New Admissions
  • Next, Previous, Home, Update Status, View all.
  • Staff
  1. Select a department
  • Next, Previous, Add, Save, Modify, Home, Search, View all.
  • Library
    1. List of the category of books.
    2. Available books.
    3. Check whether the book is available or with the student.
    4. Ability to issue books and note down the details.
  • Schedules
    1. Calendar
  1. List of schedules.
  • Web
  1. Homepage
  2. Links to admission form, course details, contact information, etc. 

WORKING MODEL OF CIMS

  • Login dialogue for CIMS
  • Main page
    1. Student details
    2. Employee details
    3. Library details
    4. Payroll
    5. Attendance
    6. College information
    7. Course information
    8. Latest happenings
  • If we click on Student link
    1. Admission details
    2. Course information
    3. Academic details
  • If we click on Employee Link
  1. Personal information
  2. Course responsibilities
  3. Academic details
  • If we click on Attendance link
    1. A screen with two options, student lists or employee lists with present or absent status appears.
  • If we click on the library link
  1. Books Available for Issue
  2. New books to add
  3. Status of books
  4. Return books with fine (if any)
  • If we click on college link
    1. Just shows the college details
  • If we click on course information
  1. Course details
  2. Subject details
  • Latest happenings
    1. Calendar
    2. Timetable
    3. Holidays
    4. Notice
    5. News and announcements
  • Other pages

Web page: A home page with the following links

  1. About us
  2. Courses
  3. Admissions
  4. List of students
  5. Staff
  6. Contact us
  7. Library
  8. Administrator

Food Ordering Management System PHP & MySQL Project

Summary of the System: 

There is a lot of scope online food ordering business and we can tap it to the max extent possible as everyone has access to an online ordering facility via the internet. Food business usually will have high demand and hence online business prospect for food ordering should be profitable.  We will provide an easily accessible interface wherein the customer can view and place the order easily.

The customer can register initially with minimum details and will be allowed to check the menu items before ordering them, adding them to cart and submit the order. The system records the details in MySQL database so that it will be easy to retrieve later. The users of the system also include employee/admin who will handle info related to product addition and assigning vehicle for placed orders.

Problem Statement:

The food business in restaurants is being carried out in the same fashion for so many decades. In the restaurants, when the customers visit, they will read the large menu cards which just has the name of the item and price. They have to decide in moments time and place the order just to wait in the queue for getting the ordered items on their table. Sometimes, the waiting time is so huge that the customers will actually lose interest in the item. Moreover, some customers will be in their office or busy to come physically to the restaurant and eat.

To ease the process of ordering the items, giving a description of each item and getting the item on the table the online food ordering system is designed. Some of the common problems are listed below.

The general problems faced while ordering food physically in a restaurant are listed below.

  1. Viewing the complete description of the menu item before ordering.
  2. Placing the order standing in a queue.
  3. Waiting for the customer’s turn to get the food.

These hurdles will be avoided by placing the order online

Users of the System:

The users of the system include the customers and the employees. The employees of the system are responsible for updating the menu items as well as the delivery of the item to a particular address. The customers will visit the website, check for the items available in the menu, order for one or more items in the menu. All the activities such as ordering items online, delivery of the items by employees, the vehicle used to deliver the items etc. will be recorded in the database for all the events.

Users of the database:

The top-level management who owns the food business will be using the database. They can try to infer details like

  1. what is the most demanded item?
  2. Which item is not ordered at all?
  3. What amount of business is made on daily basis?
  4. How the delivery of items is being carried out? etc.

Use Cases:

Use case diagram for Customers

Use case Diagram for Employees

The architecture of the Application 

Entities and its Attributes:

The main entities identified in the system are listed below.

  1. Customer [Attributes -> cid, name, email, pwd, phno, address]
  2. Employee [Attributes -> eid, name, phno, email, password]
  3. Orders [Attributes -> oid, pid, cid, odate, quantity, delivery status, vehicle]
  4. Products [Attributes -> pid, name, description, price, file]
  5. Vehicle [Attributes -> vid, status,vehicle_number]
  6. Cart [Attributes -> id, cid, pid, qty, status] 

Logical Design: 

The identified entities along with the attributes in the system are listed in Section 1. The tables that are designed are given below.

Customer Module:

The customer table consists of below details

  1. cid {primary key} [type : int auto_increment] assigned for each unique customer.
  2. name [type : varchar(30)] represents name of the customer
  3. Email [type : varchar(30)] represents email of the customer
  4. Pwd [type: varchar(30)] used for saving password of the customer
  5. Phnno [type : int(11)] is used for saving phone number of customer
  6. Address [type : text] used for saving the address of the customer

This table is used to get the details of customers

Employee Module:

Employee table is used to save

  1. eid {primary key} [type : int auto_increment] assigned for each unique employee.
  2. name [type : varchar(30)] represents the name of the employee.
  3. Phno [type : int(15)] is for saving phone number of employee
  4. Email [type : varchar(32)] saves the email info of an employee
  5. Password [type : varchar(32)] will save password of employee

Orders Module:

Order table used to save

  1. oid { primary key } [type : int auto_increment] assigned for each order.
  2. pid { foreign key references products: pid } .
  3. Cid [foreign key references customer: cid]
  4. Quantity [type : int (25) ] represents the quantity of the ordered product.
  5. Odate [type : datetime] represents a timeframe of the products ordered by the customer
  6. Quantity [type : int (11)] provides the quantity ordered by the customer
  7. Delivery status [type : tinyint(1)] saves the delivery status whether delivered or pending
  8. Vehicle [type : int(11)] helps in assigning vehicles. foreign key references: vehicles vid

Products Module:

Products tables used to save

  1. pid {primary key} [type : int auto_ioncrement ] assigned for each product.
  2. name [type : varchar(20)] represents the name of the product.
  3. description [type :text] represents the description of the product.
  4. Price [type : double(10,5)] saves the price of the product ordered
  5. File [type : text] saves the image of product ordered

Vehicle Module:

Vehicle table used to save

Vehicle [Attributes -> vid, vehicle number]

  1. vid {primary key} [type : int auto_increment] assigned for each vehicle.
  2. Status [type : int(11)]
  3. Vehicle number [type: varchar(30)] saves the registration number of the vehicle assigned for delivery

Cart Module:

Cart table used to save

Cart [Attributes -> id, cid, pid, qty, status]

  1. Id {primary key} [type : int auto_increment] assigned for each cart
  2. Cid foreign key references customer id from the customer table
  3. Pid foreign key references products table
  4. Qty saves all quantities related to products added in cart
  5. The status will save delivery status

Entity-Relational diagram:

Download Food Ordering Management System PHP & MySQL Project Source Code.