Library Management System BCA 4th Semester Minor Project using SQL and PHP

ACKNOWLEDGEMENT We truly resolve to acknowledge the opportunity provided to us by the Institution, respected teachers, and family. We intend to show our gratitude for all the support and guidance we got from our teachers, classmates, and all individuals who helped us at any point in this project. This whole process we went through in …

Online Shopping Store Website Project using C# and SQL

MY ONLINE SHOPPING STORE  We have a physical shopping store, which is doing well in terms of revenue and margin. We want to increase the business by extending the availability of our products through online mechanisms. Quick time-to-market is the main criterion; we are adding some features:  Home Page  Product Search facility  Product Detail Page  Add to Cart  …

DBMS Project on Student Management System

Student Management System is purely developed by using DBMS queries. The main functions involved to develop this project is developing ER diagram, DDL/DML, SQL constraints,  Retrieving data using the select function, Restrictions, and sorting functions,  Aggregate, and grouping, Single row function, Joins, and finally Subquery. ER DIAGRAM OF STUDENT MANAGEMENT SYSTEM DDL AND DML 1) …

Covid-19 Testing Management System Python Project

Covid-19 Testing Management System is a small project developed using Python programming. Here are the application features below. Project features: • Adding new testing centers • Search for available testing centers by locality • Update and delete testing centers • Show all testing centers by city, state • Shows the number and type of testing …

Broadband Billing System Database Design SQL Project

Database design of Broadband Billing System application with the help of stored procedures and triggers in SQL Server. ER Diagram for Broadband Billing System: Data Model Diagram for Broadband Billing System: Create Data Base: For this purpose, created a Database Named “BBS” on the server. Right Click on Database in Object Explorer of SSMS Click on …

School Case Study Database Design Queries and Answers

database design: Create a DATABASE: SCHOOL  TABLES Create the following three tables with the same names and data types as provided below: CourseMaster Column Name Data Type Remarks CID Integer Primary Key course name Varchar(40) NOT NULL Category Char(1) NULL, Basic/Medium/Advanced Fee Small money NOT NULL; Fee can’t be negative StudentMaster Column Name Data Type …

Pharmacy Management System DBMS Project

Introduction Pharmacies are an essential component of healthcare and handle the function of selling medicines. Even though the pharmacies do not seem different than any other shop, their functioning is very different due to various laws regarding medicines. For example, most of the medicines available in a pharmacy cannot be purchased without a prescription. Even …

Car Showroom Management System JAVA & SQL Project

CAR Showroom Management System is a software application to maintain day-to-day activities in the store, This JAVA & SQL project helps to maintain the record of the bike, customers, workers, and sales information Admin manages adds, updates and deletes the cars, salespersons, and admin records. Admin also can add new admins. The software is designed to handle, the daily activities of all the stores. Search the details when required.

Insurance Policy Maintenance and Claim Management Process .Net Project using C# and SQL Server

An insurance management system is a personal intranet-based web application developed by a group of insurance broker agents to make your insurance policy and claim review process easier and more flexible. The web application is used to check and monitor the status of customers who have adopted new policies in the context of distributed access …

Bug Tracking System .Net Project with SQL Server & ASP.Net

To create a new Bug Tracking System, which enables the user to detect the bugs and notify colleagues and administrators to get the rectification from them immediately. This project “Bug Tracking System” handles the Organization details in the database in an efficient manner. This system is more innovative to use, any user can make up …