Computer and Laptop Service Management System Project

Project Introduction:

  • Computer and laptop service centers are in great trouble with the manual operating systems such as they cannot maintain the data of Vendors, Products, Reports of Laptop Service Customers & Employee details.
  • This (LSM) application is used to maintain the Major Data of both product and customer details.
  • They have maintained the secret (PII) data on their server and the documents and files are stored on a computer. Now the manager will allocate the work to their employees of different branches based on the technician available.

Overview of the Project:

The main users of the LSM application are given below:

  • The administrator: The management staff at his office is the administrator of this system. He will take decisions on different tasks whether to issue them or not.
  • The employee: The employee gets the service job on his home page. The employee checks the problem with the laptop & computer and finally solves the problem and updates the status.

MODULES:

  1. Registration module
  2. Login module
  3. Admin module
  4. Customer module
  5. Employee module

REGISTRATION MODULE

  • In the registration module, the admin will register employee details, and branch details and create individual passwords, and usernames.
  • Both registered employees and customers can log in to the system by entering their login id and password. Admin also has login credentials to manage the whole application.

ADMIN MODULE

  • The administrator has full authority over the website. Only the administrator can add employee, and branch details like adding a new branch, laptop service job allotment, job status view, sales of this month, and editing employee details.

CUSTOMER MODULE

  • The laptop and computer problems will be solved by employees and they will update the status in the job receipt form. Customers can open the status view login by entering the job number and mobile number and clicking submit to display the status of the job.

EMPLOYEE MODULE

  • On the home page employees can register for laptop & computer service forms and they can update the service status. And also, how many jobs are allotted to an individual employee. This is an employee module.

ADVANTAGES OF THE PROJECT:

  • Evaluated their employee effort
  • They are maintaining employee data, and customer data.
  • Meanwhile, the application will forecast the Business of their Budget year.
  • Generate the various reports into Grid View as well as the same report will be generated into an excel sheet
  • Invoices can be printed into their letter paid.

You can also visit & download the .Net Application project on Computer Store Management System Project

Software Requirement:

  • Framework: Framework 4.5
  • Language: Microsoft C# .Net Language.
  • Technologies: Asp.Net, Ado.net
  • IDE: Visual Studio 2012
  • Operating System: Microsoft Windows 7
  • Professional Database: Microsoft SQL Server 2008

Hardware Requirement:

COMPONENTS

MINIMUM

RECOMMENDED

Processor

Pentium inside

Intel

Clock Speed

700 MHZ

1 GHz or above

Cabinet

AT

ATX

RAM

256MB SDRAM

512 SDRAM or above

Primary Device

1.44MB Floppy Drive

1.44MB Floppy Drive

Hard Disk

20GB

80GB

CD-ROM

40X CD-ROM drive

52X CD-ROM drive

Display Unit

14” Color Monitor

15” Color Monitor

Keyboard

104 Key Board

107 Key Board

Mouse

2 Button Mouse

3 Button Scroll Mouse

Modem

33.6 Kbps Modem

56.6 Kbps FAX Modem

Sound System

100 W Sound System

380 W Sound System

Pages:

  • Registration
  • Homepage
  • Employee Entry
  • Employee Details:
  • Branch Details
  • Job Check-In Page

Conclusion:

  • In this system, we are hosting the website so working on this system will be online.
  • The designing of registration and authentication modules and connecting them to the database. So that this system will be useful for all laptop service center branches, employers, and customers in all ways.
  • Using this project, time and money can be saved because we are using an online system for all its work. Thus, this project is made for the welfare of society itself.

Also, Read this Online Computer Store .Net Project

FUTURE SCOPE OF THE PROJECT:

This project “LAPTOP SERVICE & MAINTENANCE” will be implemented in the future after making some enhancements as we make our project at a low level. So, the modifications that can be done in the future to our project is to check how interactive the employee is with the customer in the chat box to clarify. And also, feedback on the service can be recorded for social users to trust our service center. Similarly, various modifications can be done to enhance the usability of the given project as suitable for the user’s requirement.

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.

Professor Online Question Paper Submission to the Examination Cell ASP.Net Project

Introduction

Online Question paper submission is a web portal that is developed or implemented in the ASP.NET domain or platform. This project is helpful for the Professor to submit the question paper to the examination cell or to the Examiner from this site. In the current generation preparing the question paper and handovering in the examination cell is not that much security. This project is developed for a Professor to maintain his details, experience, and preparation of question paper and submit the same to the examiner. The examiner also gives his information, experience and takes approval from the administrator, and then selects the question paper. This project will work on the same line of online examinations; Apart from this, it contains much more additional information such as Course type, Department details, and other details of professors and examiners in this web portal.

For the examination cell, it is very difficult to identify whether the particular question paper is submitted or not. The online Question paper submission portal is implemented in 3 main modules. Professor module, Examiner module, and Admin module. Admin module will add multiple courses and departments under different branches so Professor can easily know the best details of about subjects. The professor module ought to register with the application and choose the course and upload the question paper to the site.

Scope of the Project

The scope of the project is used to manage the details of the professor, Examiner, and Administrator. The Professor and Examiners Sign up by providing the appropriate information and then take approval from the administrator. According to course-wise Professors prepares the question papers and send them to the examiner, then the examiner selects the question paper and submits it to the board. And all these records are stored in Online Question Paper Submission Database. 

Design of the Project:

ER Diagram:

Main Modules of the Project

Administrator

 He administrates by giving approval to Examiner and Professor’s Signup. He also creates Courses, Departments, and Designations in order to fetch the correct and appropriate question paper for that course and department.

Course Details

 It is created by the Admin and it consists of Details of specific courses like BCA, BBA, BCOM, and more. The professor sends the Question paper on the basis of the Course.

Department Details

 It is created by the Admin and it consists of Details about the entire department which is created. The Department section consists of the Department name and Address of that Department.

Designation Details

  It is created by the Admin and it consists of Details about the Designation of a particular professor. This section consists of  Designation names like Ass-professor, HOD, and so on, it also has a description section under the Designation name which helps us to know which particular department the professor’s designation is from. 

Professor’s Signup

 In this section, any professor can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the professor, password and confirms password to confirm, phone number of that particular professor-main ID, and at last the address of that professor.

Examiner’s Signup

 In this section, any Examiner can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the examiner, password, and confirm password to confirm, and here it consists of designation and department where the examiner can select any of the given designations and department. At last, it asks for the Address and a photograph of that particular Examiner.

Approval for both Professor & Examiner

 This action is performed by the Admin. He approves both professor and Examiner. 

Login for professor & Examiner

 A Professor who has been approved by the Admin can now log in to the Login section and the same for the Examiner too.

Details of Question paper

 Every Question Paper must be sent with appropriate details so as to know more about the paper at a single glance.

View and Edit the Question Paper

 It is viewed and Edited by the Examiner and it is submitted to the University.

Final Reports

It creates and shows all the database records of this project.

Screenshots of Online Question Paper Submission System:

  • Home Page
  • Admin Login Page
  • Admin Main Screen Lists Section
  • Admin Main Screen Create Section
  • Admin Main Screen Approval Section
  • Admin Department list
  • Admin Designation List
  • Course Creation Section
  • Department Creation Section
  • Designation Creation Section
  • Home Screen Signup Section
  • Professor Signup
  • Professor Approve Section
  • Professor Main Screen
  • Examiner Signup Section
  • Examiner Approve Screen
  • Examiner Approve Page
  • User Login Page
  • Examiner Main Screen
  • Examiner Document Viewing Screen
  • Professor New Question Paper Screen
  • Examiner Acknowledgment Screen

Conclusion

It is believed that in the future Online Question Paper Submission centralized document system with the concept of cloud technology will recede in importance as a strategic application to become a competitive necessity that must be adopted by most government departments.

India is striding smoothly towards integrated E-Governance.  In the next five years, situation will be entirely different.  Most companies are adopted cloud technology for the maintenance of documents.

Online Question Paper Submission creates a new trend in maintaining and verifying documents online and it reduces the workload. 

Future Enhancements

  • The news feed is essential for our day-to-day purpose; hence we will add a section about the news. There, we are going to display the news about examination dates, deadlines for submitting papers, etc.
  • We are going to add some more security to our system like an OTP number for verification of the Professor’s and Examiner’s Phone numbers.
  • Authentication of Professor and Examiner is also important, thereby uploading the College Approval Letter by Principal (Signed and Sealed), makes it Admin easy to verify them.
  • We will add a few more Image File Formats such as TIFF, GIF, PNG, JPEG, etc. in order to make Professor and Examiner upload photocopies easily.
  • To make a question paper, Professor has to be experienced; therefore we will add a new section while signing up called Years of Experience. In that section, the professor has to enter how many years of experience he/she has in the teaching profession.
  • Live communication between Professor and Examiner makes it easy to fix the problems; therefore we will add live messaging on the portal.

Download the complete asp.net, vb.net project code, and SQL database on the Question Paper Submission project.

Book Reading Event System MVC App Using ASP.Net SQL & Bootstrap

This Book Reading Event App is a combination of tools and processes that manage book-reading events across India. A book reading event where book lovers come together for a community reading of their favorite book. One or more readers read the book loudly and optionally people even play roles from the book.

INTRODUCTION

A book reading event app is an online web application that is a single-point entry for all book lovers across India. Any registered and verified user who wants to keep a book reading event can create an event, invite people they know by specifying their email ids, or can keep the event open for all. The invited people need not be registered users. Due to some problem, if someone is not able to create an event, s/he can ask some other registered user to keep an event on their behalf of her/him. The registered user can check for the public events happening by just browsing into to portal and for private events, one can check the invited list of events by logging into the portal as well as by checking their invitation mail. Admin can see all the events (whether it is public or private) and all the registered users. As per the requirement, the admin can Edit as well as Delete any future public or private event details.

OBJECTIVE

The objective of this Book Reading Event System Project was to manage all the book reading events properties created by one user and send an invitation to the guests by entering their email ids or by keeping an event public. Managing these resources may itself be sufficient enough to give any user a big jump in terms of efficiency. The objective was to build a web application for people that makes use of it to manage their hectic schedule and make the best use of it in a smooth and efficient manner.

FUNCTIONALITY

The project will manage the intellectual property by creating a database of all the users and events, helping users to create an event, edit the event details, delete an event, add comment(s) on the event, invite the guest(s) for the event and to see any book reading event details happening around. Admin simultaneously verifies details of events as well as users. Admin can also edit and delete the event whenever required. Book Reading Event App has two types of users: Registered users, and Admin users.

Registered users are the normal user of the application who has the following rights:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit the events created by him/her
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event

Admin Users have all rights throughout the application as follows:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit any upcoming event’s detail
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event
  • View list of all the users
  • View a list of all the events

METHODOLOGY AND APPROACH

The following technologies were used for building this project:

  • Frontend – Hypertext Markup Language (HTML) CSS (Cascading Style Sheets), JavaScript, Bootstrap
  • Backend – ASP.NET (Active Server Page) Model View Controller (MVC)
  • Database – Structured Query Language (SQL) Server
  • Framework – Entity framework is used to connect to the database which helps in object-relational mapping

This project is built in an MVC pattern where M is the model which determines the classes, V is a view that determines views shown to the user and C stands for the controller which is used to handle the request. This project follows three layered architecture. The first layer is the presentation layer which includes views, and the second layer is the business layer which includes the services which work as a mediator between the presentation and data access layer. And the third layer is the data access layer which directly interacts with the SQL server database using entity framework and code first approach.

OBSERVATIONS

Graphical User Interface (GUI) – The website contains many links and tabs for various requirements like Create Event, Edit Event, View Invitations, etc. The users of the application consist of users from India. It will lay stress on each

page’s layout and the features to be depicted on that page.

HOME PAGE:

This is the first landing page. Any user can see the Public Book Reading Events without logging into the system by using the Past Events and Upcoming Events links. The past Events link redirects to the Past Public Events and the Upcoming Events link redirects to the Upcoming Public Events along with their details.

PAST EVENTS:

This page is landing by clicking on Past Events on the home page. Any user can land on this page without logging into the system. But one cannot add comments without logging into the system. Users can see the list of Past Public Events along with the details of each event. The working of Upcoming Events on the home page is the same.

A registered user or admin can log in using their credentials.
Depending on the type of user, s/he will have access to various functionalities of the application. In case the email id and password typed by the user do not match any record in the database, a login failure message will be displayed. If not registered already, a user can sign up by clicking on “Signup”.

USER SIGN UP

A user can register using their credentials. After successful registration user will be redirected to the login page. In case of failing the validation requirements of email id or password, a failure message will be displayed. If registered already, a user can log in by clicking on “Login”.

HOME PAGE AFTER LOGIN:

This is the landing page after the user logs in to the system. PAST EVENTS redirect to the page containing the list of past events which either the user invited, or was a public event. UPCOMING EVENTS redirects to the page containing the list of upcoming events to which either the user is invited, or it is a public event.

Navigation bar: Contains the button for CREATE EVENT, MY EVENTS, INVITATIONS, HELP, USER DETAIL and
LOGOUT functionalities.

Only user with Administrator rights has some additional button for some additional functionalities available in the navigation bar are ALL USERS and ALL EVENTS button.

CREATE EVENT:

Users can create a new event. The user just needs to enter some necessary details like Title, Date, Location, Time, Type of event, and some other optional details like Description, and Other Details. Users can invite guests to the event by entering their email ids separated by a comma. Users must provide the creator id for whom they are creating the event. If the user wants to create an event for himself/herself only, then he/she can check the creator id by clicking on DEAR – XXXXX. If the user is creating an event for someone else, then the admin will verify the details with whose creator id has been entered. If the BACK TO LIST button is clicked, the user will be redirected to the HOME PAGE.

MY EVENTS:

Users can see the complete list of events created using their own creator id. From here user can Edit/Delete his/her any upcoming event by clicking on the Edit/Delete button. Users can also create events by the button provided just under the tile MY EVENTS.

COMMENT. And can also see the comments posted by others in the COMMENTS section. The comments in the COMMENTS section are shown anonymously sorted by date and time.

EDIT EVENT:

Users can edit the details of any upcoming events from the list of events provided on the MY EVENTS page. Users can edit any of the details provided in create event form except the creator id. The layout of the page is exactly the same as CREATE EVENT page. Users can return to the MY EVENTS page using the BACK button.

INVITATIONS:

Users can see the complete list of events to he/she is invited. The list of events being shown is sorted by the date and time of the event. As this page proved to be much helpful to users in order to plan their future activities. By clicking on the DETAILS button, the user will be redirected to the EVENT DETAILS page. On the EVENT DETAILS page, users will find some additional information regarding the events such as the type of event(public/private), the number of invitees invited, and the creator of the event.

EVENT DETAILS:

Users can see all the available information regarding the event he/she invited to by clicking on the Details button available on the INVITATIONS page. Here one can find some additional information such as the type of event(public/private), the number of invitees invited, and the creator of the event. Users can also add comments for this particular event by clicking on ADD

USER DETAILS:

Users can check his/her own details by clicking on the DEAR – XXXXX button. One needs to check their user id for creating their event, so here they can find it out. Here the button name is extracted from the email id by which the user has login into the system. As it is clearly visible from the image, if someone logged into the system with [email protected] then the name before @ is shown after the Dear – button like “Dear – XXXX”. The name visible in the button is the extracted from user’s email id leaving the part from @ symbol.

ALL USERS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL USERS available in the navigation bar. On this page, the admin user can see the whole list of users who may or may not be an admin. Admin can see each user’s name, id, and email id.

ALL EVENTS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL EVENTS available in the navigation bar. On this page, the admin user can see the complete list of events. The list contains both public as well private events. The list contains both past and upcoming events. The events in the list are sorted by date and time. Admin can use create event functionality here also by clicking on CREATE NEW EVENT button.

Admin can see details like Title, Date, Location, Start Time, Type of Event, Duration, Description, Other Details, No. of Invitees invited, and Creator id of all the events. For some specific requirements, the admin can see the details for a particular event by clicking on the DETAILS button available in that event’s particular row which will be redirected to the EVENT DETAILS PAGE as shown before. Admin can not only edit the events created by him/her but also edit events created by other users/admins. Admin can edit any upcoming event by clicking on the EDIT button for that particular event which will redirect to the EDIT EVENT page. Admin can also edit the creator id for the event.

After being done with the usage of the portal, the user/admin can log out from the system by clicking on the LOGOUT button available in the navigation bar. After clicking on the LOGOUT button, the user will be redirected to the HOME PAGE. Users can again use the system any number of times by logging into the system using the same credentials used for the first time.

CONCLUSION

This Book Reading Event system is a user-friendly software that can be used in any locality for any user to arrange the event and to send an invite to guests just by entering their email ids. Due to some problem, if someone might not be able to create an event and send an invite or somebody might not have email ids available for all the guests, in this case, the book reading event app provides functionality to a user to create an event on behalf of someone else and it will be verified by an admin before sending an invitation to the guests and posting that event on the portal.

Allowing all the users to have access to such web-based application software can help anyone who wants to keep an event busy with the preparation of the event can easily send invitations to the guests and save his/her time. Further, this software can be developed to add more functionalities in the future, like setting a reminder for the events and notifying the user time by time, and setting a flag for the events one is interested in. This project can be further extended to keep any event (i.e., House-Party, Get to Gather) and not just only for book reading. The sheer possibility of scaling this application is immense and will definitely go to be proven the most useful software in the future times.

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: 

  1. Home Page 
  2. Product Search facility 
  3. Product Detail Page 
  4. Add to Cart 
  5. Place Order

Use Case Diagram-Online Shopping Website:

The use case diagram is usually referred to as a behavior diagram used to describe the actions of all users in a system.

All users described in the use case are actors and the functionality is the action of the system.

The use case for an online  shopping website:

Specification of Use Cases:

Use Case                                      Home page

Home Page

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

Various Categories of the items are displayed

Post Conditions

On clicking each category, various sub-items are to be displayed

Normal course

1.      On hovering various categories are displayed

2.      On each Category, the subcategories are displayed

 

Use Case                      Search Product

Search Product

Element

Details

Actor

User

Trigger

On clicking the search bar for the item to be searched.

Pre Conditions

 Users can check the items they needed

Post Conditions

The various items of the searched product are displayed

Normal course

1.      User enters the Product name or product category

2.      The various items of the product are displayed

Use Case                                      GetAllProducts

GetAllProducts

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

The user needs to enter a product name

Post Conditions

The sub-list of all the items should be displayed.

Normal course

1.      The various products should be displayed varying in different perspectives

Use Case                                      GetProductDetails

Get Product Details

Element

Details

Actor

User

Trigger

On clicking a particular item the info about the product is to be displayed.

Pre Conditions

The user needs to enter the product name or category

Post Conditions

The total info regarding the product is to be displayed

Normal course

1.      User enters the Product name and then submits

2.      The fetching records will be displayed

Use Case                                      AddProduct

Add Product

Element

Details

Actor

Admin

Trigger

When the User Quantity is not available

Pre Conditions

 Checks whether the searched item is available in the inventory or not

Post Conditions

The user can search for the prescribed item

Normal course

1.      Admin checks in the inventory stock

2.      During the period of offers or when the inventory is not available to the users, he adds to the database.

Use Case                                      Delete Product

Delete Product

Element

Details

Actor

Admin

Trigger

When the offer period is completed

Pre Conditions

 Refactoring the product as per the daily market price

Post Conditions

The product is not available after the deletion.

Normal course

1.      Admin login using his credentials

2.      Search for the product to be deleted

3.      Deletes the particular products

Use Case                                      Edit Product

Edit Product

Element

Details

Actor

Admin

Trigger

When the product needs to be updated during the season sale

Pre Conditions

 The product may vary in its cost and delivery

Post Conditions

The product has been updated regarding the information

Normal course

1.      Admin logins using his credentials

2.      Updates the selected products in the inventory.

Use Case                                      Add To Cart

Add To Cart

Element

Details

Actor

User

Trigger

When a user needs to buy the item at a later point in time

Pre Conditions

 If the user likes a particular product he can choose to buy it by clicking the Add To Cart

   

Post Conditions

The selected items are available later until the selected product is available

Normal course

1.      User selects the particular product

2.      He then clicks on Add To Cart.

3.      The liked items are available for later usage

 Use Case                                     BuyNow

BuyNow

Element

Details

Actor

User

Trigger

With  authentication

Pre Conditions

The total amount should be displayed.

Post Conditions

On Clicking the order needs to be placed.

Normal course

1.      Click on Buy Now, select the items and then go to payment

2.      The order should be placed after payment.

Shopping cart System ER Diagram:

ER Diagram:

Flow Chart For Online Shopping system:

Database Table Design:

ProductCategory:

Field Name

Type

Remark

CategoryId

Int

PK

CategoryName

Nvarchar(50)

 

Products:

Field Name

Type

Remark

Id

int

PK

CategoryId

int

FK

Price

Float

 

Quantity

Int

 

Description

Nvarchar(Max)

 

Picture

Nchar(100)

 

CartItem: 

FieldName

Type

Remark

Id

Int

FK

Price

Float

 

Quantity

Int

 

 

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) Create a table name student and attribute of s_id, first last and middle name, address, email, city, and state.

2) Display the datatype of all attributes in the student table?

3) Insert values into the table student?

4) Change the datatype of s_id in the student table?

5) Update the city of s_id=001 to bby?

SQL CONSTRAINTS

1) Create a table name student with an attribute s_id that is not null?

2) Create a table name student with an attribute s_id that is unique?

3) Create a table name student with an attribute s_id which is a primary key?

4) Create a table name teacher with an attribute s_id which is a foreign key and team name?

5) Create a table name student and with an attributes city which a default constraints “KOLKATA”?

RETRIEVING DATA USING SELECT

1) Display all the columns of the table name course?

2) Display the columns c_name aliases course name of table name course?

3) Display the columns c_fee and c_name using concatenation and aliases course details of table name course?

4) Display the course fee and increase in course fee by 3000 where the course duration is 45_hr?

5) Remove the duplicate value from course duration with a student ID from the table name course?

RESTRICTIONS AND SORTING

1) Display the student ID and the first name from the table name student whose state is westbengal?

2) Display all the data of the table course whose course ID is ‘11’.

3) Display all the data of the table course whose course fee range is less than 100000?

4) Display the Lastname and city of the table student where the student’s first name starts with ‘a’ and consists of 4 characters?

5) Display the course fee of the table name course which is between 10000 to 50000?

AGGREGATE AND GROUPING

1) Display the average course fee for all the courses in the given table?

2) Display the minimum and maximum course fees in the given table?

3) Display the count number of course names from the table name course?

4) Display the total course fee in the table name course?

5) Display the student ID and minimum course fee from the course table and group by student ID having a course fee less than 102000 and sort the minimum course fee in descending order?

SINGLE ROW FUNCTION

1) Display the student ID and student first name and state from the student table where convert student first name and state into uppercase?

2) Display the student ID and student first name and state from the student table where convert student first name and state into lowercase?

3) Display the student ID and student state from table student and change the first character of all states to uppercase?

4) Display the student ID and student first name middle name last name together from the table student use the character-manipulation function?

5) Display the student ID and the length of the first name and the last name from the table student using the character-manipulation function.

JOINS

1) Display the registration number for the user’s table and the student’s first name on the table student use inner join?

2) Display the registration number for the user’s table and the student’s first name on the table student use left join and order by the first name.

3) Display the registration number for the user’s table and the student’s first name and last name from the table student use the right join and order by registration number.

4) Select all teachers and all courses in the given table using full join and order by teacher ID.

5) Select all students’ first names and last names and city in the given table using self-join and order by the city?

SUBQUERY

1) Display the first middle and last name of the student where the course fee is minimum?

2) Display the teacher ID and first middle and last name of the teacher where the course name is DBMS?

3) Display the phone number of the student of who’s registration number is 20?

4) Display the registration number who live in Jaipur?

5) Display teacher ID first name and phone number whose qualification is b.tech?

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 kits available at each center.

Software to be used to develop this application:

• Python
• SQL for creating a database
• Library to interface between Python and SQL
• Either Django (to create a web app) or a GUI library to create the UI (not decided yet)

Implementation

1. Login page (This has a simple login prompt designed using a GUI library that asks for the user id and password.)
2. Menu:
a. Add a testing center
B. Delete testing center
C. Edit the number of testing kits available
D. Search for the testing center by district/city/state
E. Show all testing centers
3. Separate sections for:
a. Adding a new center
b. Deleting center
c. Updating center information
d. Searching for center
e. Nationwide data

Covid-19 Testing Management System can be developed by using PHP & MySQL Server with different functionalities below.

User Characteristics

The Covid 19 Testing Management system has 2 types of users they are Admin and user(patient)

General Constraints

The tools and technologies that are used to develop this project are:
The language used in this project is PHP5.6 and PHP7.x.
The database used in this project is MySQL 5.x.
The web browsers that are used in this project are Mozilla, Google Chrome, IE8, and OPERA.

Operational Scenarios

Scenario A:
How your application starts
Our application covid19 testing management system starts by login into the application, if the user is a new user, the user needs to register by providing the needed credentials.
New users need to provide testing information. A registered user needs to provide test information.

Scenario B:
Usage Scenarios like Customer Check-out
When a customer visits our application, he/she needs to log in by providing their credentials according to their role i.e., admin and user.
If the user is new, he needs to register if he is an old user, he can directly enter the login details and login directly.

Scenario C:
Database

The data that we are going to store in the database
1) Admin Login
Username
Password

2) New admin login
Admin name
Username
Password

3) User login
Username
Password

4) New user login
Name
Phone number
Username
Password

5) User Registration
Name
Current address
Gender
D.O.B
E-mail id
Phone number
Age
Aadhar card number

Restaurant Database Management System Project using C# & MS Access

Title: Restaurant Database Management System.

Topic Research and Executive Summary:

The Restaurant database Management System is an Enterprise Database project which has a few advantages where restaurants can improve customer relationships; Restaurant owners can know when the customers arrive most of the time which can enhance productivity. By using a Restaurant database Management System owners can have effective use of Human Resources. Due to this database system, we can manage time we can reduce human efficiency and errors, and get accurate information.

Statement of Work

Project Description:

This database system is developed in such a way that restaurant can get accurate details of both offline and online ordering through mobile or web application so customer gets a notification if the order is ready for pickup and customer can track the order if he/she orders online for home delivery.

Due to this database management system, we can reduce the complexity between restaurant management and customers.

Project Challenge:

  1. Collecting the information from the Restaurant owner visa by reading articles or interviewing the store manager of the company.
  2. Learning C# to create an application to connect with Microsoft access. C# is a programming language that is simple, and modern. The language and its implementations provide strong support to software engineering principles. C# is familiar to C and C++
  1. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft jet database engine with a Graphical user interface and software tools.
  1. Must learn to design a logical relational database                                                              
  1. Create ER diagram

Project Description and Milestones:

Stage1: Analysis: The main objective of the database is to manage the details of the staff of the restaurant, the customer who visits the restaurant to order and take away behavior that the customers who order online, and manage the delivery system where the restaurant can assign delivery boys to deliver the food the customer.

Stage2: logical design: The Database consists of 5 data tables which are

Restaurants in different locations.

The store manager who takes care of the restaurant manages the staff and the daily supplies like food items

The staff are of different types such as cashier, waiter, receptionist, cleaner

Customers who order online, who visit the store and have dine-in, and others who take away

Delivery guy who takes the orders and delivers the food to the customer

Stage3: physical design:

The Restaurant is located in different locations so it has a restaurant id and restaurant address.

The manager data table has the manager id, manager name, manager age and management experience, and manager address.

The Staff has staff id, staff age, staff assigned work, staff address, and staff experience.

Data table for a delivery system where it has details of delivery boy, location of the delivery, order details

The customer data table has customer order details and customer names.

The customer ordered online then the data table has the customer’s address, customer name, order details, and delivery boy id.

Stage 4: Implementation: Create the application interface using C# programming language, and create a database using Microsoft access.

Stage5: Modification and Maintenance:

Modification and maintenance of the database are done in the Microsoft database.

Methodology and implementation plan:

This database management system has 4 phases, design, coding, testing, and maintenance. By use of RAD methodology, these stages are implemented.

Step 1: Need to create a design a database with five data tables.

Step 2: By using C# programming we need to create a user application interface, Using Microsoft access we need to create a Database and interlink the application interface and database.

Step 3: Need to test the database system and check for the error the clear the errors.

Step 4: Need to check the database on a regular basis because things to be needed to be upgraded.

Expected results: The Deliverables

By creating a working application for the restaurant so they can access it easily. The Restaurant owners can view the details of the store manager, the number of staff working on a daily basis, and the financial details.

The Store manager can use the database system to view the no of people working in the store and can view the accurate details of the orders

Customers can easily order the food through the online menu

Supporting Facilities:

Database: Designed in Microsoft ACCESS

Application program language: C# programming

Other application: Microsoft Visual Studio (Programming IDE)

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 New
  • And Provide the name and hit the ok button
created a Database Named “BBS” in the server

Create Objects specified in Data Model & Add data to the “Subscription” table

Run the BBS_CreateTables script that will create the below data model in SQL.

Creation of SQL Procedures:

SP#1

Create a procedure that gets the customer’s name, customer mobile number, id proof, type, city, area, and password as inputs and registers the customer for choosing any suitable plan of broadband as per his locality.

Run the BBS_RegisterNewCustomer_prc Script to create Register New Customer

Testing Script:

USE BBS

go

— Register New Customer

Exec BBS_RegisterNewCustomer_prc

  @CustomerName='Suresh Kumar'

, @CustomerMobile ='80043781'

, @CustomerIDProof ='ARC5296P'

, @CustomerType ='Regular'

, @City ='HYDERABAD'

, @Area ='HYDERABAD'

, @Password ='iSuraj'

SP#2

Create a procedure that gets the customer’s name, customer mobile number, id proof, type, city, area, and password as inputs and registers the customer for choosing any suitable plan of broadband as per his locality.

Run the BBS_ShowCurrentSubscriptionPlans_prc script:

Testing Script:

use BBS

 go

 — Check Current Subscription Plans

 Exec BBS_ShowCurrentSubscriptionPlans_prc @USerID=2 , @Password ='iSuraj'

SP#3

Create a procedure that gives the customer all the plans available and the customer can choose anyone plans out of them as per his need and locality by taking subscription id, customer id, and month as input.

Run the BBS_ShowAllPlansToCustomers_prc Script:

Testing Script:

Use BBS

go

 — Show all plans to customers

 Exec [BBS_ShowAllPlansToCustomers_prc] @SubscriptionID =1 , @CustomerID =100001 , @Month ='JUNE'

SP#4

Create a procedure that will generate the bill for the customer’s chosen subscription plan by taking subscription id, month, and customer id as inputs.

Run the BBS_GenerageBillForCustomer_prc script:

Testing Script:

use BBS

 go

 — Generate Bill for Customer

 Exec [BBS_GenerageBillForCustomer_prc] @SubscriptionID =2 , @CustomerID =100001 , @Month ='JUNE'

SP#5

Create a procedure to make a transaction for payment for the chosen transaction and will show the transaction details of the customer’s payment status.

Run the BBS_ShowPendingTranactions_prc script :

Run the script:

use BBS

 GO

 — Show Pending Transactions

 exec BBS_ShowPendingTranactions_prc  @CustomerID =100001

Trigger:

Create a trigger that gets triggered when there is any update on the bill table after the successful transaction of payment and this trigger has to change the status of the bill payment from pending to paid.

Run the below Scripts:

BBS_Transaction_Details_Update_tr Script

BBS_MakeTranactionsForPayment_prc Script

Testing Script:

 use BBS

 GO

 — Show Pending Transactions

 exec BBS_ShowPendingTranactions_prc  @CustomerID =100001

 — Make Transactions for payment

  exec [BBS_MakeTranactionsForPayment_prc] @TransactionID=2 ,   @PaidAmount =700, @PayMethod ='CC'

Run the 1st SP first to get the transaction details and amount

Pass those in 2nd sp and execute it.

Then if you run the query you will see the status updated to Paid

Select * From Bills b where billno=2

 End

Download the Broadband Billing System application Stored Procedure Scripts Here.

School Case Study Database Design Queries and Answers

database design:

  1. 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

Remarks

SID

TinyInt

Primary Key

StudentName

Varchar(40)

NOT NULL

Origin

Char(1)

NOT NULL, Local/Foreign

Type

Char(1)

NOT NULL, Undergraduate/Graduate

 EnrollmentMaster

Column Name

Data Type

Remarks

CID

Integer

NOT NULL Foreign Key

SID

Tinyint

NOT NULL Foreign Key

DOE

DateTime

NOT NULL

FWF (Fee Waiver Flag)

Bit

NOT NULL

Grade

Char(1)

O/A/B/C

 Using the above table layouts as schema, write T-SQL Statements for the following requirements:

  1. List the course-wise total no. of Students enrolled. Provide the information only for students of foreign origin and only if the total exceeds 10.
  2. List the names of the Students who have not enrolled in the Java course.
  3. List the name of the advanced course where the enrollment by foreign students is the highest.
  4. List the names of the students who have enrolled for at least one basic course in the current month.
  5. List the names of the Undergraduate, local students who have got a “C” grade in any basic course.
  6. List the names of the courses for which no student has enrolled in the month of May 2020.
  7. List name, Number of Enrollments, and Popularity for all Courses. Popularity has to be displayed as “High” if the number of enrollments is higher than 50, “Medium” if greater than or equal to 20 and less than 50, and “Low” if the no.  Is less than 20.
  8. List the most recent enrollment details with information on Student Name, Course name, and age of enrollment in days.
  9. List the names of the Local students who have enrolled for exactly 3 basic courses.
  10. List the names of the Courses enrolled by all (every) students.
  11. For those enrollments for which fees have been waived, provide the names of students who have got ‘O’’ grades.
  12. List the names of the foreign, undergraduate students who have got a grade of ‘C’ in any basic course.
  13. List the course name and total no. of enrollments in the current month.

stored procedure

Using the above table layouts as schema, write a stored procedure for the following specifications:

Input Parameters:

Date From (Mandatory), Date To (optional, if not specified, take the current date), &Student ID (Mandatory) 

Requirements:

Course-wise,enrollment-wise in ascending order of course name to be printed. If no enrollment exists for a given course for the period specified, print the course name and the remarks ‘No enrollment for this period’

——————————————————————————————

Enrollment Details of<Student Name > from <FromDate> To <ToDate>

Origin :                                                          Type:

SL.No       Course Name    Date of Enrollment    Fee Waiver? Grade 

                                                                  (Yes/No)

  …             …               ……                              ……      ……

  …             …               ……                              ……      ……

                       Total No. of Courses Enrolled:

The Development of the above-Stored Procedure below using SQL Server:

–Create the database

create database School_DB

go

–To exchange the context

USE School_DB
go

–create CourseMaster table

create table CourseMaster
( CID int Primary Key,
CourseName varchar(40) NOT NULL,
Category char(1) NULL CHECK(Category='B' or Category='M' or Category='A'),
Fee smallmoney NOT NULL CHECK(Fee>0)
)
go

–To see schema of table

sp_help 'CourseMaster'
go

–To view the table

select * from CourseMaster
go

–Insert the values in CourseMaster table

insert into CourseMaster values(1,'SQL Server','M',10000)
insert into CourseMaster values(2,'MSBI','A',20000)
insert into CourseMaster values(3,'Python','B',5000)
insert into CourseMaster values(4,'Data Science using Python','M',90000)
insert into CourseMaster values(5,'C#.NET','B',15000)
insert into CourseMaster values(6,'Java','M',15000)
insert into CourseMaster values(7,'Power BI','A',30000)
insert into CourseMaster values(8,'Oracle','A',30000)
insert into CourseMaster values(9,'MySQL','B',15000)
insert into CourseMaster values(10,'Cobol','B',16000)
insert into CourseMaster values(11,'Cognos','M',40000)
GO

–Create Student table

create table StudentMaster
(
SID TinyInt Primary key,
StudName varchar(40) NOT NULL,
Origin char(1) NOT NULL CHECK(Origin='L' OR Origin='F'),
Type char(1) NOT NULL CHECK(Type='U' OR Type='G')
)
GO

–Insert the values in StudentMaster table

insert into StudentMaster values(100,'Arman','L','U')
insert into StudentMaster values(101,'Jhon','L','G')
insert into StudentMaster values(103,'David','F','G')
insert into StudentMaster values(104,'Rosy','L','U')
insert into StudentMaster values(105,'Mike','F','G')
insert into StudentMaster values(106,'Jessica','L','U')
insert into StudentMaster values(107,'Abhi','L','G')
insert into StudentMaster values(108,'Srinu','L','U')
insert into StudentMaster values(109,'Venkat','F','G')
insert into StudentMaster values(110,'Ram','L','U')
insert into StudentMaster values(111,'Khan','F','G')
insert into StudentMaster values(112,'Laya','F','U')
insert into StudentMaster values(113,'Naresh','F','G')
insert into StudentMaster values(114,'Naveen','F','G')
insert into StudentMaster values(115,'Rahman','F','U')
insert into StudentMaster values(116,'Abosode','F','G')
insert into StudentMaster values(117,'Manikanta','F','G')
insert into StudentMaster values(118,'Lalitha','F','U')
go

–create EnrollMaster

create table EnrollMaster
(
CID INT NOT NULL FOREIGN KEY REFERENCES CourseMaster(CID),
SID TinyInt NOT NULL FOREIGN KEY REFERENCES StudentMaster(SID),
DOE DateTime NOT NULL,
FWF Bit NOT NULL,
Grade char(1) NULL CHECK(Grade='O' OR Grade='A' OR Grade='B' OR Grade='C')
)

–USING THE ABOVE TABLE LAYOUTS AS SCHEMA, WRITE T-SQL STATEMENTS FOR THE FOLLOWING REQUIREMENTS:

1. List the course wise total no. of Students enrolled. Provide the information only for students of foreign origin and only if the total exceeds 10.
2. List the names of the Students who have not enrolled for Java course.
3. List the name of the advanced course where the enrollment by foreign students is the highest.
4. List the names of the students who have enrolled for at least one basic course in the current month.
5. List the names of the Undergraduate, local students who have got a “C” grade in any basic course.
6. List the names of the courses for which no student has enrolled in the month of May 2020.
7. List name, Number of Enrollments and Popularity for all Courses. Popularity has to be displayed as “High” if number of enrollments is higher than 50, “Medium” if greater than or equal to 20 and less than 50, and “Low” if the no. Is less than 20.
8. List the most recent enrollment details with information on Student Name, Course name and age of enrollment in days.
9. List the names of the Local students who have enrolled for exactly 3 basic courses.
10. List the names of the Courses enrolled by all (every) students.

–11. For those enrollments for which fee have been waived, provide the names of students who have got ‘O’ grade.

select StuName,grade
from StudentMaster SM
inner join EnrollMaster EM on SM.sid=EM.sid
where EM.Grade='O' and FWF = 1

–12. List the names of the foreign, undergraduate students who have got grade ‘C’ in any basic course.

select StudName,Origin,Type,Grade,Category
from CourseMaster as CM
inner join EnrollMaster as EM ON CM.CID=EM.CID
inner join StudentMaster as SM ON SM.SID=EM.SID
where SM.Origin='F' and SM.Type='U' and EM.Grade='C' and
CM.Category='B'

–13. List the course name, total no. of enrollments in the current month.

select CourseName,count(*) as Total_No_of_Enroll
from CourseMaster as cm
inner join EnrollMaster as em on cm.cid=em.cid
where datediff(mm,DOE,getdate())=0
group by cm.CourseName