Category: Visual Studio Code Projects

Posted on

E-Commerce Website for Online Nursery Store Plants & Accessories

Online Nursery Store overcomes lots of challenges when compared to an offline store. A separate website for plants and their accessories helps customers to view various kinds of products. It offers all the required features to the customers that let them buy, rate, and leave comments on all the products that are available in the store. Therefore, the idea of Blooming Delights An E-Commerce Website is to provide features to customers like view descriptions, compare prices, can comment on customization ideas, and can follow planting tips that promote gardening. The website recommends customers with the most purchased products, highest-rated products, and recently added products. A chatbot is developed that answers product or order-related queries to customers. After the order is placed, an order confirmation report can be viewed by the client for review.

Problem statement:

Many people want to buy plants and are directly concerned with the nursery store. But sometimes people do not know specific information about certain plants and the seller does not have technical skills. Build an online nursery store website so that customers can compare prices, view descriptions, and add reviews to a product that helps the customers for a pleasant shopping experience. After the order is placed, an order confirmation report can be viewed by the client for review.

Objective:

The main objective of this E-Commerce Website project is to create an online nursery store website that helps customers compare prices, view descriptions, can comment on customization ideas, and can follow planting tips that promote gardening. Customer service is essential. So, each customer should have a pleasant shopping experience. For this, customer queries are answered with the help of a chatbot.

Proposed system:

Our Online Nursery Store website consists of two different logins customer and admin. The features of our website are as mentioned below:

CUSTOMER

  • Buy Products
  • Rate Products
  • Comment Products
  • View his own profile
  • View his own purchases history
  • Create favorite products list
  • Can change his own avatar

ADMIN

  • Add products to the website
  • Edit products on the website
  • Delete products on the website
  • Edit/Delete inappropriate user comments

Activity Diagram:

Activity diagram

REQUIREMENTS

Software requirements:

Visual Studio Code
Dialogflow (For the integration of Chatbot)
MEAN Stack

1) Mongodb
2) Express JS
3) Angular
4) Node JS

Hardware Requirements:

Intel core i5 processor
RAM 4GB
Hard Disk Drive 1 TB

Functional Requirements:

USER:

R1: Registration
Description: To enter the site user has to register first. Requirements of registration are name, email, password, and, security check details.
Input: User Details.
Output: Filled registration details.
Processing: User details are checked with the database to avoid duplicate login. Password constraint is checked as per validation.

R2: User Login
Description: The system provides the facility to login into the system.
Input: Enter user email and password.
Processing: The system will check the input of the user and if valid then login is done. Otherwise, the user will be asked to re-check his/her credentials.

R3: Forget password
Description: The user can reset the password.
Input: Email ID and security check details.
Output: The user can update the password.
Processing: The data will be updated in the database

R4: Purchase products
Description: Customers can select a product.
Input: Search for an item.
Processing: Any product will be selected and displayed.

R5: Comments
Description: Customers can post and view comments.
Input: Customers have to post his/her comments.
Processing: The system will add data to the database.

R6: Logout
Description: The system provides a facility to log out from the site.
Input: Select the logout option.
Output: Logout from the system.
Processing: The user will be logged out.

ADMIN:

R1: Admin Login
Description: The system provides the facility to login into the system.
Input: Enter user email and password.
Processing: The system will check the admin’s input; if valid, then login is
done. Otherwise, the admin will be asked to re-check his/her credentials.

R2: Add Products
Description: Admin can add a product.
Input: Enter the product details.
Output: Added product is displayed under entered category.
Processing: The system will add the product to the database.

R3: Edit /Delete Products
Description: The admin can edit or delete a product.
Input: Enter the product details.
Processing: The system will make the changes in the database.

R4: Delete Comments
Description: Admin can delete inappropriate comments.
Output: Deleted comments are not displayed.
Processing: The system will make the changes in the database.

R5: Logout
Description: The system provides a facility to log out from the site.
Input: Select the logout option.
Output: Logout from the system.
Processing: The admin will be logged out.

Non-Functional Requirements:

Performance Requirements

The system needs to be reliable.
If unable to process the request, then an appropriate error message will be displayed.
Web pages are loaded within a few seconds.

Safety Requirements

The details need to be maintained properly.
Users must be authenticated.

Security Requirements

After entering the password and user id the user can access his/her profile.
The details of the user must be safe and secure.

CONCLUSION & FUTURE SCOPE

Blooming Delights is an online nursery store website, that provides a platform to buy seeds, plants, tools, and different related products. It offers all the required features to the customers that let them buy, rate, and leave comments on all the products that are available in the store. The description of each product is available to soothe the selection. Hence, Customers can compare prices, can comment on customization ideas, and can follow planting tips that promote gardening. The future work of this project is to improve various categories, add different kinds of payment modes, and send order-related updates by E-mail or SMS.

Posted on

College Sports Management System .Net Project using Asp.net, C#.Net and SQL

PROJECT DESCRIPTION: The College Sports Management System’s objective is to provide a which manages the activity of many sports at a time. It also manages the registration process and announcement of the results.

Modules

Add sports

We can add new sports into the system so that we are able to retrieve them later during the registration process. The sports added would be viewed during the creation of a new intra- college or university tournament.

Add Scoreboard

We add a scoreboard so that the students can view it and the results of each match are announced here so that there will be only one platform for the results. This would reduce the chaos during the score announcement.

Add Tournament

Each tournament from an intra-college or a university can be added here. It later would help in the registration of any sports in that tournament. While adding a new tournament the system would show the set of sports that are entered into the system by the director of the sports so only those sports can be included in the tournament while creation.

Remove Sports

This module will help in the removal of any sports that the sports director thinks are not needed in the system. The removed sports would not be shown anywhere in the system that includes during the addition of a new tournament.

Edit Scoreboard

The added scoreboards would be updated here. This module helps in updating the scores on the scoreboard. Only the scoreboard which is added using the add scoreboard module would be present here and only these scoreboards can be updated. We won’t be able to add a new scoreboard here.

Remove players

This module would remove each player after each round of the tournament. So that only the existing player will be present and the one that is not qualified for the next round would be removed using this module. This would give a clear picture of the qualified players. As well as the player from the college team I can also be removed.

Remove Tournament

After each tournament in the college or a university, we should remove it, so that there won’t be any confusion between different tournaments which are going to be held later on. This module would help in removing all the details of the deleted tournament.

Registration Individual

This module would help in the registration of individual sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the player would add his name and the required details asked in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Registration Group

This module would help in the registration of group sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the set of player’s names would be added and the other required details asked for in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Payment

This module would help with online payment. So that the students wouldn’t have to stand in a queue or have hard cash in hand in order to do any payment to the sports department. By using this module we are reducing a lot of paperwork and we are giving the students the liberty of doing the payment from wherever they are.

  • This College Sports Resource Booking Project is related to the College Sports Management System Project. You can also visit & download the Android Application project on College Sports Resource Booking

SYSTEM STUDY

EXISTING SYSTEM

The existing system is more of a manual work, where the students have to walk up to the sports department and have to register for the events that they desire to participate, it’s not just the registration process but even other activities such as the announcement of the result, the payment, etc. This results in a lot of paperwork and the chance of the data getting mixed up is high. In the existing System, students are not able to get proper information about the games conducted in various venues. The student needs to spend a lot of time to get the information about the game. The student should attend the venue to get information on the game which takes a lot of time. The information such as the qualified player’s list, the timing of the event, the score of the sports happening, etc.

DISADVANTAGE OF THE EXISTING SYSTEM

  • Involves a lot of paperwork
  • Students have to walk a lot for the registration and other sports-related activities
  • Data getting corrupted is high
  • Human error is common during intra-college and university tournaments.
  • The students need to visit the venue to get all the information about the tournament and would have to wait for a long time.
  • Manually recording all information with regard to all data and manually creating the contest schedules, coordinating facility usage, and hand-registering athletes and teams. The dissemination of information would require that documents be typed, photocopied, and put up on the notice board or common place where students can view them.

You can also visit & download the website project on University Leave and Outing Pass Automated System

PROPOSED SYSTEM

In the proposed College Sports Management System student can get all the information about various games and the venue.

OUTPUT SCREENSHOTS

  • Sports team
  • Adding new tournament
  • Adding new sports
  • Removing sports
  • Removing Players
  • Index page for Registration
  • Registration form for intra-sports
  • Registration form for group events
  • Admin Login
  • Index page
  • Admin Home page
  • Adding scoreboard

You can also visit & download the web application project on Student Activity on Sports System

CONCLUSION

Sport is a part of the curriculum in college. Hence it’s time for the sports department and its activities to be automated and go online as it will be beneficiary for everyone who is associated with sports in college. The “College Sports Management System” project will assist the sports department of the college and would help the students in saving a lot of time in searching for games being conducted in the college. Our project provides students to get register from anywhere and anytime. It helps the administration by streamlining the current intra-college sports event administrative practices. Specifically. It will allow the administrators to configure a set of Tournaments into the system and simply record the results of those contests so that administrators and the public can track the teams during the course of the tournament.

.NET Framework makes the application robust, secure, and reliable. This system provides better scalability and is open to more enhancements. More levels of abstraction can be implemented at the front end and back end, thereby making the system easily adaptable to any changes in the environment.

The software developed was implemented and tested with real data and was found to be error-free. Also, it is found that the system works successfully. The user has to provide their personal detail to buy a package. All the necessary validations are carried out in this project so that the company can make use of this software and the necessary messages make them conscious of the error they have made. Henceforth, valuable reports have been generated for this organization.

You can also visit & download the Java and MySQL-based web Application project on Sports Event Management System

Download the Complete College Sports Management System .Net Project with ASP.Net, C#.Net, and SQL Server.

Posted on

Portfolio Management System MCA Project using PHP and MySQL

ABSTRACT

The main objective of the portfolio management system is to design and develop a web service that is useful for job seekers and job providers to meet. Create a portfolio website to show off your projects and achievements to prospective employers.

Here, the database is used to collect all the personal information of the candidate for generating their resume profile on the portal. The system admin will generate a report according to the company’s needs and requirements.

INTRODUCTION

Project Description

  • The Portfolio Management system refers to building a strong resume for the candidate who is seeking jobs online.
  • This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.
  • The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver.

The world is growing digitally, and for job seekers, there are more opportunities to seek employment. This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.

Scope

A Portfolio system is a dynamic and continuous process. The following are the scopes of portfolio management:
1. Monitoring the performance of the portfolio by incorporating the latest conditions.
2. Identifying the objectives, preferences, and constraints.
3. Compare with the latest targets and achievements.
4. There is no need of keeping a physical resume for the candidate.
5. Users have their own login ID and password, with which they can secure their documents.
6. If a wrong password is given three times in succession, that user account will be locked and the user will not be able to use it.
7. Once provided with internet access, users can take part in the system from everywhere.

Purpose

The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver. It is a collection of projects and programs used to structure and manage investments at an organizational or functional level to optimize strategic benefits or operational efficiency.

Product function & User classes

User:-

  • Users have to register into the system first.
  • Users can provide their achievements, resumes, and skills in extra detail.
  • Users have to login into the system.
  • Users can view their portfolios according to their details.
  • Users can change their details in the system.
  • Users can provide feedback to the organizations.

Admin:-

  • Admin has to login into the system.
  • Admin can change their details.
  • Admin can view/block the latest registered details.
  • Admin can filter the details.
  • Admin can search the candidate by their skills, name, achievements, and degree.
  • Admin can select appropriate candidates.
  • Admin can send emails to the selected candidates.

Updating the details

  • As we can clarify the profile photo of the user has been updated with the profile and database as well.
  • As follows the update procedure, all the details would be updated with the same result as shown in the image.

Category

Portfolio management is an online web-based application so the main advantage is that there is no more system compatibility requirement problem.

Advantages

  • It improves the candidate selection process.
  • It is used to make smart decisions in the organization.
  • It provides more accurate user performance data.
  • It helps to achieve better productivity in the organization.
  • It also helps to make projects successful.

Design Phase Diagrams:

User Side Activity Diagram:

Admin Side Activity Diagram:

Database Design:

Functional Requirement

Administrator:- Responsible for managing clients of the system, taking system backup, generating reports, and maintaining the organization’s whole details.
Manage Users:- The administrator can manage the user information and the admin can mail and send the details to the appropriate user.
Maintain Details:- The administrator maintains the entire details of the system including details of the users.
Taking System Backup:- The administrator takes a backup of the database in order to prevent loss of the data on system crashes. He takes backup of the entire database in a particular section.
Generate Reports:- Responsible for checking the logs of different system users for auditing and maintaining the whole system.
Use Registration & Login:- The first thing is to register yourself by giving a proper mail id and password then move forward to login into the system.
Filtering as per need:- The administrator can filter the candidate & can view the information related to the filtering.
Non-Functional Requirements
User Interactive:- The response of the website should be high and the website should behave as per the user’s action. Users should be acknowledged in the form of visual changes or feedback on the site to enhance the interaction. The portal should be maintained across all the web pages.
Security:- Secure login option to the users to avoid unauthorized access to the system and the information. 
Reliability:- Portal should provide the users with valid information at all times.
Business Rules:- This requirement contains all the rules and regulations on behalf of the system.

Software tools:-

Front End:- HTML, CSS, Bootstrap, jQuery.
Back End:- MySQL, PHP.
Front End tool:- VS code, Wamp server.

Hardware Specification:-

Hardware platforms support banking transactions. A Portfolio system is effective when the correct software application and hardware configuration are used.
Processor: Intel Pentium 4 or above
RAM: 256 MB OR above
Hard Disk: 160GB or above

System Advantages

  • Building a resume online may save you time which can be utilized in a better way.
  • Candidates may instantly customize their details with one click or add some new details with the same.
  • The site built confidence to boost since you can make your resume professional and you may able to impress the recruiters with your resume.
  • Since the admin can generate reports the process of selecting candidates will be easy.
  • The system is used to make smart and effective decisions for the organizations while selecting a candidate.
  • The system provides more accurate user performance data.
  • The system is helpful to achieve better productivity in the organization.

Limitations of the system

  • The major limitation of the system is that is they work purely online, and lacks the functionality to enable the user to save a copy of their resume in other word processing software like Microsoft Word.
  • Another limitation of the system is that they mostly offer a limited choice of formats. 

Future Scope of the system

  • The system is having currently a static base design that can be chosen by the user, according to their needs they can choose whatever resume type.
  • To increase the system enhancement and database security for the future.
  • Users can delete their account from the site, as they got hired or for some other reasons.

Conclusion

  • The portal has been successfully completed. The goal of the system is achieved and problems are solved. The package is developed in a manner that is user-friendly and required help is provided at different levels.
  • Different types of reports can be generated which help the management to take the correct decision and reduce the time delay which automatically increases the company’s work standards as well as the economical state of the company.
  • This system never decreases the manpower but helps the development of available manpower and optimizes the manpower by which the company’s standards and capabilities can be scaled to higher dimensions.

Download the complete Source Code of the Portfolio Management System MCA Final Year Project Using PHP, MySQL, HTML, CSS, Bootstrap, jQuery

Posted on

Online E-Commerce System Project Using HTML 5, CSS 3, NodeJS and ExpressJS

Purpose

  1. To develop an online e-commerce system that will provide a platform for customers and sellers to meet and sell and purchase items. The Online e-commerce system shall accomplish the following as of achieving the major goal:
  1. To build a user-friendly business website, where users will be able to search for any product which is available nearby or anywhere in the world. By using an Online e-commerce system, it will be easy for sellers to sell products and save time and money. Doing business through this application will help to reach a maximum of customers and sellers. Creating a panel where a seller is able to upload their product’s full details and a customer can view and make a purchase as per their wish.
  1. To implement the system and check if it actually is able to provide benefit to the people.

Scope

The scope of this application is to build a user-friendly e-commerce website, where users will be able to purchase any product which is available on the website. By using the e-commerce system, it will be easy for sellers to make a sale and save time and money. Doing business through this application will help us reach a maximum of sellers and customers globally.

General Objective

To develop an online e-commerce system that will provide a forum for sellers and customers to interact with each other, and sell and purchase items.

Specific Objectives

  1. Create an online platform where sellers post items for sale through the online system.
  1. Create a panel where a customer can view products from a seller and make purchases and do payments through online payment systems, and later submit reviews about the service.

ER Diagram:

Data Flow Diagram:

UML Diagram:

Modules Description

Sign Up

1. It is used to register or to create a new account for a particular website.
2. It also allows the user to be a part of the website and also provides all the services of the website.

Log in

1. It is used to open a session with an account that is already created.
2. It is successful when your credentials (i.e., username and password) match with what is already stored in a database. This is called authentication.
3. It makes the site personalized for you.

About

1. This module gives an overview of the website.
2. It shows the website’s business, values, and commitments and its management.

Contact

This module allows the users to ask any queries related to their property or anything.

Search

This module is used for searching the posted auctions

Add Product

This module helps in posting Auctions

Product Function

1. Enable the customers to view posted products in their locality and also globally.
2. Enable the creation of accounts and logging in to the accounts
3. Enable users to log out of their accounts
4. Provide an interface for the seller to view the transactions, and add sellers and products to the system.
5. The seller should also have accounts where they will receive customer orders and respond to them.

Modules 

  • Login and new registration
  • Search: The search page will help users to search for the desired items using the search box.
  • Contact: This module will help users to contact the seller in case of any queries or issues that arise.
  • Add Product: This module will help the seller to add new products to the system

Summary

This NodeJS-based website is a reliable web application that saves time and money. This must be implemented in most of the information technology industries. It is user-friendly software, through which users can easily interact and easy to search for and buy products. This turns out to be great usage.

With the rapid growth of the internet and the world wide web, everything is going online. This website is developed by keeping in mind the easiness of interaction by the users so that they get a very user-friendly environment while surfing the website. Such compatibility of this website enables it to attract users to visit the website more frequently

The system is capable of maintaining details of various users, sellers, and products and storing all day-to-day transactions. The central concept of the application is to allow customers to search, compare and purchase products using the internet. The information pertaining to the products is stored on a NoSQL database on the server side. The Server process the customers and the orders and stores them in the database. 

Future involvement with the project

We will keep on improving our project in the future by adding more and more modules in the system as per the needs of the users. 

Limitations

Our project was limited in time and cost which is a limitation. If provided with more time and cost, we would have done better using the better infrastructure.

We developed the project on a local offline server, though we could have used an online one if provided with more cost.

Hardware & Software Used

Hardware

1. HP Notebook
2. i5 10th Gen CPU
3. 8GB RAM
4. 512GB SSD

Software

1. Visual Studio Code
2. Postman
3. NodeJS
4. ExpressJS
5. Google Firebase
6. AWS
7. HTML 5, CSS 3 & Javascript.

Posted on

University Leave and Outing Pass Automated System Application

Purpose of the Project:

This Project is a leave/outing pass automated system designed for Educational Universities. This system is an end-to-end module that enables a user (Student) to raise a request and an admin (Mentor) to approve/decline it. This is a robust system where Parent Verification, In-Out Time recording, and Data Security have been taken care of. This Project is built to be a secure, flexible, unique, transparent, and user-friendly environment that aims to digitize the whole process thus removing fake paper trails.

Feasibility Study:

The project has been undertaken after the feasibility study, which paves the way for deployment, and phase development.

Scope of the Project:

The scope of the Automated System is designed to run on the University server and to allow students to raise requests for their leave, trace the request status, and modify them. On the Mentor Dashboard, the software also allows the Mentor/ Mentor Coordinator to view requests, and approve/decline requests. Whereas on the Hostel Dashboard, the Warden/ Deputy Warden and Hostel Supervisors will be able to view and grant leave passes to the students.

This Automated System will provide ease to all the actors – students, mentors, hostel authorities, and security services in regard to leaving/outpassing sanctions and will ultimately eliminate the paperwork.

Overall Product Description:

Product Perspective:

It will provide a way in which existing paper-based work can be supplemented with the end-to-end robust leave management system. The system can be used independently of the platform and device, be it on a smartphone, tablet, or computer.

Product Functionality:

The server will be responsible for storing each request generated, generating one-time passwords, generating QR Codes E-Pass for authorized requests, receiving and authenticating requests, generating statistics at the needs of each audit, and maintaining and verifying security and user privacy. This server can also potentially contact all authorized students by email to give them username information, passwords, server address, OTP code, updates to the users from the Mentors/ Hostel Services, etc.

Process Flow – Student:

  • depicts how the student raises the request and the activity which is continued after the review from the mentor.
  • depicts how the Mentor/Warden/Supervisor approves/declines the requests.
  • depicts how the Security guard can verify the leave request the student displays.

Upper Classes and Characteristics:

It is anticipated that three types of users will use the Licensed Software defined in this SRS.

  1. IT staff/ Software Development Cells are expected to deploy and configure the System using the defined system interfaces. This will include running the whole system and maintaining software after the handover and deployment of the project.
  2. The second type of user of the Hostel Warden/ Deputy Wardens / Hostel Supervisors and Managers is expected to understand and use correctly the software interfaces defined with the appropriate design documentation.
  3. Finally, it is expected that any student accorded with Hostel Services within the domain of Vellore Institute of Technology may access all of the leave request information such that the request is independently verifiable. This will include a web application presented using Hyper Text Markup Language (HTML) to allow a user to raise their request that has been registered under review including the previous requests history.

Working Environment:

The Automated System software is directly made as a web application, so the computer hosting must be capable of running HTML and should have internet. The system will be uploaded to the University server, in order to make it accessible for all the students, faculty mentors, and wardens.

Design and Implementation Constraints:

The Application provides an end-to-end leave management system that copes with malicious attacks provided certain constraints are met. Principally, all necessary steps should be taken to protect the System from unguarded attacks by using physical, network, storage, and user security protection. These safeguards should be penetration tested by the SDC to ensure viability.

User Documentation:

The users are the students or faculty/staff of the university who are authorized by SDC, they will be able to raise/ view/ approve/ disapprove requests on the server. The application client will be available free of charge, and any purchase of the server software will be authorized to distribute it to their users.

Assumptions and Dependencies:

 This software in its initial phases of development depends on a few third-party commercial applications or any assumption. Student Development Team will take care of all the assumptions and dependencies. It will be the responsibility of SDC to purchase/ develop the dependency as per the University IT norms.

System Features:

Login:

This is used to login and maintain security by authenticating the users

1. Should accept the user name password
2. A case-insensitive comparison is done for a user name and a case-sensitive comparison is done for a password
3. If the correct user id and password are supplied then, Main Menu should be displayed
4. If an invalid user id or password is entered then the system should display the error message “Invalid ID or password” and should quit the application.
5. Username – Students – Registration Id Faculty – Employee Id Staff – Employee Id
6. VTop Login Credentials can be used in the further enhancements

Mentor’s Portal:

This feature allows mentors to work out the leave/vacation requests.

1. Can approve a request.
2. Can decline a request.
3. Can edit the request.
4. Can verify the request.

Warden’s Portal:

This feature allows the warden to authenticate the requests

1. Is able to view all requests for outpass.
2. Can reconsider requests

Hostel Supervisor’s Portal:

This feature allows supervisors to issue outpasses to the students

1. Can issue outpasses to students.
2. Can deny the issue of an outpass.
3. Can send a request for reconsideration to the warden.

Student Portal:

This feature will allow students to raise a request for an outing/extended outing/leave.

1. Can raise requests of respective categories.
2. Would receive a system-generated outpass

External Interface Requirement:

User Interfaces:

Login Interface – The login interface consists of the student username and password fields, Students can log in with the same VTop Credentials.

The login interface for the faculty and staff consists of the faculty/ staff employee id and password. Their credentials will also be the same as those of VTop.

Hardware Interfaces – Hardware requirements include a laptop or a desktop or a smartphone with proper connectivity to access the system. Other than above mentioned, no hardware is required.

Software Interfaces – The software is based on an application interface. The Application will interact with the University Server with regard to user verification and information retrieval.

Operating System

Ubuntu

Programming Language

HTML, PHP, CSS, JavaScript

IDE

Visual Studio Code

Database

InnoDB

Hosting Base

Amazon Web Services

Communication Interfaces – This software would be functional on an ethernet connection or a wireless connection.

Cost Calculation:

SOFTWARE COST ESTIMATION:

For any software project under development, it is indispensable to know how much it will cost to develop and how much development time will it take. The project scope must be established in advance and software metrics are used as a support from which evaluation is made. The project is broken into small PCs which are estimated individually. Several estimation procedures have been developed to monitor the project’s progress, so developers and product managers can assess whether the project is progressing according to the procedure and take corrective actions, if necessary.

STATIC, MULTIVARIABLE MODELS:

Static, multivariable models depend on several variables describing various aspects of the software development environment. In some models, several variables are needed to describe the software development process, and the selected equation combines these variables to give an estimate of time and cost.

WALSTON and FELIX developed the models at IBM to provide equations to give a relationship between lines of source code with effort and duration of development.

For our software project, the lines of code (LOC) sum up to 5223, which becomes 5.223 KLOC.

So, according to the WALSTON-FELIX model, we need to hire 24 engineers per month and require 7 and half months to develop our project.

Posted on

Blood Bank Management System DBMS Mini Project

The main purpose of the PHP & MySQL-based blood bank management web application system DBMS mini project is to provide the blood bank with an easier way to store and retrieve data and keep a record of the availability of blood in the blood bank.

After inserting the data into the database, staff need not register the same person again. They can simply search for recorded data and retrieve them for future blood donation or receiving purposes of that person.

In the nutshell, it can be summarized that the future scope of the project circles around maintaining information regarding:

  • The person can fix their donation schedule using an online reservation for the donation of blood.
  • The person can search for the availability of required blood in the local blood bank in the case of an emergency.
  • The blood bank stores the details of the blood donated by a person, like RBC, WBC, platelet count, etc.

The above-mentioned points are the enhancements that can be done to increase the applicability and usage of this project.

E-R diagram of the blood management system

E-R diagram of blood management system

MODULE DESCRIPTION

the list of modules incorporated with the “blood management system” is:

Login module:

This module is for employees of blood banks to log in so that only they can access the database.

Person module:

This module is used to store all the personal details of the donor or receiver.

Donor module:

This module is used to record the date and time along with the quantity of blood donated by a person. Personal details are accessed using a personal ID.

Receiver module:

In this module date and time, the quantity of blood received along with hospital details is recorded.

Stock module:

Here we can check the availability of each blood group blood.

RESULT AND ANALYSIS

Home Page of blood bank management system
The login page shows the login page, if the user wants to log in, they must enter a valid/registered username and password and click on the login button.

The home page shows information about the blood bank management system.

Add person page shows the Add person page, here details of the donor/receiver are registered.

Add person page shows once the entry of personal details is done.

The search person page shows the result of the search we have done. If we enter the person’s id it will return all the personal records present in the database.

The donation page shows the New donation page, here person id and units of blood donated are recorded, and submit button is clicked. On successful completion of entering it displays “Your donation is successful”.

Receive page shows the New Receive page, here person id, units of blood donated, and hospital details are recorded, and submit button is clicked. On successful completion of entering it displays “Your receiving is successful”.

Check the Stock page shows the stock details i.e units of blood present in the blood bank of each blood group.

The donation History page shows the Donation history page, the user has to give the time interval from when he wants to see the donation history details. Upon clicking submit he shows the donation history. If there is a donation that took place at that time interval it displays “No record found in the specified time interval”.

Receive History page shows the Receiving history page, the user has to give the time interval from when he wants to see the receive history details. Upon clicking submit he shows the received history. If there is receiving of blood that took place at that time interval it displays “No record found in the specified time interval”.

Add user page shows the add user page, where it asks for the super admin password. Next, you have to enter the new username, and password and confirm the password. Click on create user button. If the super admin password is wrong or the password and confirms password don’t match. It will pop an invalid password. On successfully creating a user it will display “New user created successfully”.

Download the complete Blood Bank Management System DBMS PHP & MySQL Project source code, project report, and execution steps here.