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)

Hospital Management System VB.Net Windows Application Project

The main aim of developing this Hospital Management System VB.Net Windows Application application is to manage the hospital functionalities between doctors, patients, staff, and admin.

Hospital Management System Project is best suited for 1920×1080 resolution and 64bit architecture. This VB.Net Windows Application Uses Microsoft Access MSAccess Database 2016 for back-end database queries. This Project works only in the Microsoft Windows environment. The project is created using Visual Basic (.NET Framework).

Users & functionalities of the Project

  • Login Page
    • Admin Login details
    • Staff Login details
  • Patient
    • Patient Registration
    • Patient Check-up
    • Patient Admit/Discharge
    • Patient Update Details
  • Staff
    • Staff Availability
  • Blood Bank
    • Register Blood Donor
    • Register Blood Receiver
    • Blood Availability Information
  • Personal Information
    • Edit Profile
    • Logout

Hospital Management System Overall Functional map of the project below:

Hospital Management System Project & Platform Details

The Hospital Management System is designed to help in hospital management. With this software, the hospital management can register patients as well as assign them tickets for consultation and admission/discharge. This windows application also allows you to check the availability of staff members. From here, the blood bank department can also be handled with ease. The administrator has the power to access all databases at will.

Database Details:

Here you can download the complete Hospital Management System VB.Net project Source code, Project Report, User Manual.

For more details visit the project developer’s page

E-Students Consultancy .Net Project using C# and SQL Server

The E-Students Consultancy project is a comprehensive web application that is most useful for simplifying the testing process. Its role is more visible in the business environment, as well as in other types of sectors. The system simplifies the testing process by assessing the student’s abilities and fitness. Because the world is a competitive world, it is difficult to examine every individual, and it can also lead to misunderstandings or inaccurate results.

This system is useful for managing the student inspection process; A new user of this system can register his identity to access its features. After successful authentication, this system generates a set of individual questions for users; The user can make their choice to select the correct option from the target test. After filling in the answers to each selection question, the questionnaire ends with an automated process of the system.

This system manipulates the results of the questionnaire, showing the set of skills of each user, creating a survey on the results, and helping the organization or any commercial sector to choose the right person for the ideal job.

existing system

In this modern world the existing online job searching system provides minimum secure authentication for the students that’s why the resulting process takes so much time. Students have to wait for a period to know the result of the attended online tests, even if it may take a month or a while. Each and every student are forced to register their identities on the consultancy site for the job and they have to wait until the respective persons respond to their registration.

So there is a chance to miss the other opportunities from others. Students are required to pay for getting the premium details (like Contact details) of the registered companies. To avoid this type of problem a new method of consultancy portal is required.

Disadvantages

  • Provides minimum security means for individuals
  • The major disadvantages of this system are low efficiency and time consumption. 
  • The maintenance cost of the existing system is high and it should be barred by the students only.
  • Students feel hesitation and there is an opportunity to miss other opportunities.

Proposed System

In this proposed approach individual secured authentication means are provided for each and every student and company, the student can enter into the system with proper identities, so it is easy to find the fraudulent people if any mismatching occurs. The E-Student Consultancy provides a bridge between students and corporate, which leads to attaining job offers and online test scenarios. Free access is provided so the students and companies can attain the details securely without any delay. The online test generation process allows the student to feel free and attend the test to know their individual talent. The result will be delivered immediately once the test is over. This system is used to test the students and their eligibility level.

Advantages

  • Secured login mechanisms are handled.
  • Reducing the workload of the companies and students.
  • Time consumption is comparatively good.
  • Easy access and Online Test Procedures make the students feel free to work.
  • Results will be delivered to students instantly.
  • Implementation and maintenance cost is low.

Modules:

AUTHENTICATION Module

REGISTRATION Module:

The E-Student consultancy provides two types of registration processes on the company side and the student side, in the company side the registration process depends upon the company name, contact details, and vacancy then creates the complete registration process. On the student side, the registration process is based on the personal detail like name, Mail Id, address, etc

COMPANY DETAILS MANIPULATION Module:

The company details manipulation process allows the user to create the company details with proper identities. The following details are required to register the company into the server: company name, contact, and the number of vacancies available in the company. These details are registered into the server, which is useful to the students to find out the company details and the number of vacancies available in the company, and address of the company. This is used to view the job vacancies in the company and reduce the job search time.

ONLINE TEST REGISTRATION Module:

The online test manipulation process is one of the major implementations in this e-student consultancy. That is used to test the student’s ability and fitness for the job. In the online test generation module questions are created by the company individuals and then it will be uploaded into the portal for student access. The students can register and attend the test which is created by the company individuals. The student’s mark will be calculated by the server at the time of completing the test. The student mark denotes whether a particular student is eligible for the job or not.

RESULT ANALYSIS Module:

The result analyzing process is used to generate the result for the test which is attended by the student online and the test generation process creates the result immediately once the student answers their last question. Once the mark is generated then it will immediately be transferred to the respective student mail.

Download E Students Consultancy Project.

Restaurant Management System Database Project using PHP, MySQL/MS Access

The aim of this project is to create a Restaurant Management Database (RMD) is an online application for restaurant management. This system wakes to provide service facilities to restaurants and to the customer. The services which are provided are food ordering, reservation of the table by the customer through the system online, menu information management, and report.

The main goal of this project is to make the customers satisfied to get the food from anywhere

  • To develop the online ordering and reservation system in restaurants.
  • To develop a user interface for an online restaurant management system to provide online menu information for customers to order

Project requirement

The basic requirement is to make the customers log in and order their favorite food online. To do so they need to look at the menu. Thus, there must be a menu with quantity and price options. Thus, these basic requirements are addressed for now.

Mission statement

The objective is to help the customer to order food online and get them delivered through an interactive application.

Objectives

  • The application should support customer registration
  • Registered customers should gain access through username and password
  • There must be an interactive menu with all details
  • Customers should be allowed to browse the menu
  • Customers can place an order by adding the menu item to the cart.

Interview Questions

  • What tables are needed for the system?
  • How will we ensure that there are no duplicate records in the database?
  • How will the customer know whether the item is available or not?
  • What navigational options are good for customers?
  • How do secure customer payment information and personal information?

ER Diagram

Tables

Product ID

Product name

Details

Status

Price

Int

char

char

char

Currency

 

user_id

username

password

address

mobileno

email id

int

char

varchar

varchar

number

varchar

 

cart_id

user_id

product details

product_id

quantity

price

int

int

char

int

int

currency

 

delivery_id

user_id

delviery status

duedate & time

int

int

varchar

date  time

 

Reservation_id

User_id

Name

date

table choice

time

int

int

Varchar

date

int

time

Output Results:

Admin Dashboard:

All Orders Details Page:

Restaurant Management Table booking Admin Page:

Popular Dishes Page:

Here you can freely download the complete Restaurant Management System project Source code with both MySQL and MSAccess database code, User Manual Report.

Library Management System Database Project using PHP & MySQL/MS Access

EXECUTIVE SUMMARY

Libraries are popular places where there are numerous books to keep track of. Not only books but the librarian is also required to keep track of users, books that were taken, due dates, etc. Making manual entries and keeping track of due dates is not easy when the user’s size is more. It becomes complex when there are numerous books and when the members of the library are increasing. Tracking members and books details become time-consuming and are prone to error. Thus, the objective of the project is to come up with easy to use and user-friendly database management application that helps the librarian with all the tasks related to efficient library management.

The application is expected to be a secure, user-friendly, and easy-to-use database application for library management, that is capable of performing library tasks like adding books, searching books, issuing books, returning books, and generating fines and reports. The application is expected to simplify the librarian tasks, reduce errors in bookkeeping, and make the task interactive and interesting.  

The project management and development shall be iterative and shall employ the RAD application development methodology. The rapid Application Development methodology is a fast way of completing a project prototype with more emphasis on the design phase and application development. With RAD in use, the application development shall be broken down into smaller tasks that are easily manageable and monitored.

At the end of the project, there shall be a live web-based application with an easy-to-use and rich navigational front end designed with JavaScript and PHP and a back end with My SQL. Both platforms are open-free and thus making applications cost-effective.

PROJECT PROPOSAL

1.     Statement of Work

1.1  Project Background

Database management systems have become vital for organizations to manage large databases and to perform transactions upon such large data. These database applications not only store data, but also manage them, synchronize them, and help in information retrieval without errors. They reduce manual efforts and enhance the quality of information retrieval services. Due to this reason, they are widely used in almost all sectors. Libraries are popular places where there are numerous books to keep track of. Not only books but the librarian is also required to keep track of users, books that were taken, due dates, etc. Making manual entries and keeping track of due dates is not easy when the user’s size is more. Thus, this work implements a library management system database application that helps the librarian manage all tasks in an efficient and user-friendly manner.

1.2  Vision

The project vision is to come up with a library management system database application that does the jobs of the librarian like maintaining book records, maintaining user records, due dates, fines, etc. efficiently and in a quick time without errors.

1.3  Project Objective

The objective of the project is to come up with easy to use and user-friendly database management application that helps the librarian with all the tasks related to efficient library management.

1.4  Project Scope

The project scope is:

  • To have a user-friendly and easy-to-use database application for library management.
  • To have an application that secures data records.
  • To have an application that generates reports on books, due reports, fine reports, etc. easily.
  • To have an application that can track the user activities and their records easily.
  • To have an application that reduces the errors and efforts of the librarian.
  • The application shall have a login and password for allowing only authorized users to access the application.

1.5  Value proposition

This application shall reduce the manual errors and efforts of the librarian. It shall provide the end-user with the abstraction of all the database details and thus simplify the task as a set of small activities. It shall enhance the quality of the services of the library. It shall keep better track of book availability, dues, fines, etc., and enhance the quality of response to the user by the librarian. 

1.6  Technical details

Existing system:

Currently, the library system in use is a mixture of both file-based and manual-based work. Excel files are used to keep records of books, library users, and library user transactions. With such a system the key challenges are

  • More duplicate records as there is no control on duplicity.
  • inconsistent records are more as there is no referential integrity control
  • Time-consuming tasks as a simple tasks may require extensive search and a lot of entries.
  • such a system is prone to errors due to inconsistencies in data
  • Lack of user-friendly GUI: the system lacks a GUI that facilitates the end-user by providing an abstraction of the back end. This abstraction of the backend makes the end-user efficiently do his or her job without worrying about other details.
  • Data loss risk: if the data is lost it becomes impossible to recover the data from excel files.
  • Generating reports of books or users with fines becomes difficult and time-consuming as it requires multiple worksheets to be navigated and used. Due to the cumbersome job, the accuracy of the reports is low.

Thus, it is proposed to come up with an efficient, user-friendly, library management system that makes end-user tasks easy, error-free, and fast. The system shall follow the norms of a database management system ensuring integrity, consistency, and no duplicates of data.

Thus, the system shall have a simple to use GUI as the front end. Database application shall be developed using My SQL. The front-end JavaScript & PHP. The operating system is Microsoft Windows 7 and above with either 32 or 63 bits configuration.

1.7  Challenges

The Key challenges the project development may face are as follows:

  • The existing data from excel can be imported to MY SQL database. But to ensure referential integrity of the data it is essential that the database follows norms of having the primary key, removing duplicates ensuring consistency, etc. Thus, it may require the excel data to pre-process, convert and then migrate it to MY SQL.
  • The end-user may be new to GUI and API usage. Thus, there may be a need to train the end-user with the application.
  • Issues may arise from front-end and back-end connectivity. This can be managed through proper coding.
  • The system development may face hurdles if its development process is not managed and monitored properly. It is essential to have a Gantt chart with proper milestones to monitor the activities.

1.8  Organization of the proposal

This project proposal is divided into sections. The first section was a background of the project giving details on its vision, value proposition, objectives, and scope.

Sections 2 to 6 details are as follows:

  • Section 2: This section gives in detail the project methodology and the implementation plan. In this section the database design principles and methodology employed is elaborated, the way the application is developed is defined and the key areas of the application along with key features and functionalities are explained through various diagrams. It shall also contain the test plans for the application.
  • Section 3: This section defines the key deliverables from this project. It thus gives details on what the project shall give for a specified set of inputs and how the result is used.
  • Section 4: This section defines how the application project management shall be carried out. It shall give details of the milestones to be achieved and details on project monitoring and evaluation.
  • Section 5:This section gives details on the project team and their roles
  • Section 6: This section is about the tools and the supporting platforms that make the application implementation possible.

2.     Methodology and Implementation Plan

The database design and implementation process shall be done on the MySQL database management platform. The project management and development shall be iterative and shall employ the RAD application development methodology. The rapid Application Development methodology is a fast way of completing a project prototype with more emphasis on the design phase and application development. With RAD in use, the application development shall be broken down into smaller tasks that are easily manageable and monitored. With regular communication and feedback among the team, the application development becomes faster and more efficient with RAD. The key phases of application development thus are as follows:

  1. Requirement analysis
  2. Application Design
  3. Rapid construction & Testing
  4. Going live

2.1  Requirements Analysis

This is the first phase of the application development lifecycle. The objective of this phase is to gather the end-user requirements and the expectations of the stakeholders from the library management system. These are listed in the form of functional and non-functional requirements.

Functional requirements

  1. Login/logout: The application should provide user-based login and logout mechanism. Thus authorized users can login into the system.
  2. Add book: This shall allow the librarian to add the book record into the database.
  3. Manage book: This shall allow the librarian to edit or delete any book record in the database.
  4. Search book: This shall allow the user to search for a book through book name, author name, or both.
  5. View book: This shall allow viewing all the books, new books, old books, damaged books, lost books.
  6. Issue Book: This shall make an entry of the member with the books browed and the due to return.
  7. Accept Return book: This shall enter the return date and ensure that the book is successfully returned.
  8. View issued books: This shall list the books that have been borrowed with their member name and due date.
  9. View returned books: This shall consist of lists of returned books.
  10. Add member: This shall help the librarian to add a new member and categorize them.
  11. Manage members: This shall make changes in the member record like deactivating them, deleting them, and editing their information.
  12. Search member: this shall help in searching the library member record
  13. View fine details: This shall generate a fine for those borrowed books with member details that skipped their due dates.
  14. Generate report: this shall allow the system admin to generate user reports, book reports, borrower reports, fine list reports, etc., and download them.

Non-functional requirements

  1. Security: the application should endure data security and user access security.
  2. Navigational requirement: The navigational options of the system should be user-friendly and easy to use.
  3. Database requirements: The database should be accessed by only secure and authorized users. The database should be available, consistent, have no duplicate entries, and should give error-free output.
  4. Performance requirement: the system should be responding with a proper message thus giving an idea to the user of the interactions.

Use case diagram

Following is the use case diagram of the system

Figure 1: Use case diagram

Activity diagram: Consider the process of adding a book record

The steps of adding the book record to the database are as follows:

Figure 2: Activity diagram

1.1  Conceptual Design

ER diagram for the Library Management System

Figure 4: ER Diagram

1.2  DBMS cost/benefit analysis

The technology that shall be used for the proposed system is the MySQL database management system. It is used because it is simple to use, supports a large database system, and has compatibility with various programming languages that can support the front-end design.

The front-end technology relies on JavaScript and PHP. These are selected as they offer good design options, navigational options, making the user interface interactive and more appealing. Thus, with consideration to having a good and user-friendly interface, these technologies are selected.

The other options were to use the Oracle database management system and MS Access database management system. But MS access system was ruled out due to its failure to support large databases and its difficulty in providing front-end connection to programing and scripting languages like PHP. Oracle was ruled out as it is tough to use and is costly when compared to MY SQL which is free and open source.

Product

Cost

Option 1 Oracle

Standard Edition One – $5,800 per unit (sockets)

Option 2 MS Access

$109.99 per license

Option 3 My SQL

Free

 

Front end option 1 Java and swings

Free but requires programming expertise

Front end option 2 PHP and Javascript

Free requires scripting expertise

Front end option 3 ASP.NET

Free requires scripting expertise

 

Based on the above and the available expertise, the project is built using MY SQL, PHP ad Java Scripts is selected.

1.3  Logical Design

The main tables proposed for the system are as follows:

User table:

User_id

Username

password

firstname

Lastname

Primary key int

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Book table

book_id

Book_title

Author

Book_copies

Book_pub

Publisher_name

Isbn

Copyright_year

status

Category_id

Primary key int

Varchar(100)

Varchar(100)

int

Varchar(100)

Varchar(100)

Varchar(50)

int

Varchar(30)

 

Borrow

borrow_id

Date_borrow

Due_date

Member_id

Primary key int

Date

date

Int

Member

member_id

Firstname

lastname

Gender

contact

address

type

Status

Primary key int

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Varchar(100)

Return

Return_id

Book-id

Borrow_id

Borrow_status

Date_return

Fine

Primary key int

int

Int

Varchar(100)

Date

int

1.4  Physical Design

The proposed system shall have a user interface form designed and developed using JavaScript and PHP scripting languages. The key issue in this design is the special emphasis on navigational options, proper usage of arrows and icons so that the user can operate the system without any hurdles. The user navigation should give control freedom to the user. It should not be complex and should be user-friendly.

The database backend is designed and developed using MySQL. It can be problematic to establish front and back-end connectivity while using the application. Thus, in such a case proper commands for the connection must be established.

1.5  Prototype

A sample prototype is as follows:

Front end admin login screen

Front end admin login screen

Back end book table

Adding books

Adding members

1.6  Performance Evaluation

The Project is successful only if it is capable of giving expected results. Thus, the application is to be tested to ensure that it is executing as per expected objectives. The proposed application shall be using black-box testing wherein test cases shall be built and executed. The test cases shall test the user interfaces and each use case. If the expected results are achieved the application shall be assumed to be error-free and ready for launch. Otherwise, the test result recommendations shall be implemented.

2.     Expected Result

At the end of the project completion following things shall be expected:

  • A back end designed and developed in MySQL with tables for users, members, books, return records, borrowing records, searching capabilities, and report generation.
  • A front end that is user-friendly, rich with icons, and is appealing to use. The front end shall be designed so that the user can perform the actions without any issues.
  • A fully functional application with both front end and back end connectivity capable of doing all the said tasks of use cases.
  • An application manual describing the ways to use the application
  • A cost-benefit analysis describing the feasibility of the product in economic terms.
  • A requirement analysis documents and work breakdown structure.
  • A complete coding and scripting file
  • A test project report giving details of project implementation and test results.
  • Final project document

3.     Project Management Approaches & Milestones

The objective of project management is to ensure that the project development is planned well and executed properly to ensure quality and timely delivery.  For proper management of the application development, the project development process is broken down into small tasks. Each task is grouped as milestones. For each milestone, a deadline is assigned and an expected outcome checklist is prepared.

Once a milestone is reached, the checklist is evaluated and the reviews are done with the team members. The outcome of the checklist evaluations and the review are recommended and implemented to ensure that the project is meeting its quality standards.

To ensure the tasks are executed on time a Gantt chart is used. The Gantt chart for the project is as follows:

Figure 4: Gantt Chart

Here you can download the entire project source code, User Manual Report.

Student School Record Keeping System Application Database Project

Project Background

Efficient management of student-related information becomes challenging for any educational organization when the volume of data and operations over that data increases. Information systems and database systems are the needed tools that help in the efficient management of such large volumes of data. These systems not only manage the data but even help in the easy retrieval and processing of useful information.

Vision

This project work vision is thus to come up with an efficient database management system that is capable of maintaining student records for an educational organization.

Project Objective

The objective of designing and implementing such a database management system is to manage the student records in a proper and organized manner, enable data flow and information flow among various activities related to student information processing, and secure the student data.

The project scope is as follows:

  • To come up with an efficient database management application for student record management.
  • The application shall help to add student records like their personal information, fees-related information, scholarship-related information, course-related information, and marks-related information.
  • the application shall allow to edit or delete any student record based on authorized permission
  • The application shall allow generating reports like marks statistics, feed duellist of students, etc.
  • The application shall have access based on authorization and role-based authorization shall be enabled for read and write processes.
  • The key information like payment, and a password shall be stored in encrypted form for security purposes.

Value proposition

This database application shall help the educational organization to keep track of all the student records and manage them in a more efficient manner. It shall reduce the number of manual errors, do the student record processing task in quick time and thus reduce human effort. It shall enhance the student and teacher experience in generating reports and getting key notifications.

Technical development plan

The existing system makes use of excel based records. These are file-based systems. The biggest challenge in this system is that there are more duplicate records due to the lack of any control mechanisms that control duplicates. Database management system makes use of a primary key that is unique and it is capable of identifying any unique record. Thus, it is a way of eliminating duplicates.

The existing system is not user-friendly to use as they lack user-friendly APIs. With supporting scripting languages like PHP, CSS, and Java Script it is possible to come up with an interactive GUI. Such GUI helps the user to do the tasks in a more efficient manner.

Thus, the proposed system shall make use of the following:

Front end: PHP

Back end: MySQL

Web Server: Wamp server

Operating system: Windows 7 and above.

Development Methodology

The application development shall adopt the Rapid application development methodology and develop the application in a small set of tasks. The objective shall be to come up with a rapid prototype and iterate it as per the testing results. The development process shall begin from starting from system requirements, system design, coding, testing & debugging implementation & maintenance. It shall be an iterative process.

The development tasks shall be small manageable tasks. This shall make project monitoring and management easier.

Requirements Analysis

The first functional requirement of the project is to have an application capable of adding and managing student records.

Thus, the application should allow Admin to do the following

  • Add student: to should allow the admin to add student details like name, enrolment id, contact address, course enrolled, subjects, date of birth, address, gender, and other details.
Activity diagram depicting adding or deleting student
Activity diagram depicting adding or deleting student

Figure 1: Activity diagram depicting adding or deleting student

  • Manage student: to allow the admin to view student records, delete existing student records, and edit or update any existing student records.
  • The application should allow the admin to add marks, manage marks and generate a result
  • The admin can add subject or course details.
  • The application should allow the admin to generate lists of students who have not paid fees and those who have availed of scholarships.
  • Manage user records and change passwords

Students can do the following:

  • The application should allow students to register,
  • view result and download result

Conceptual diagram

Student record system overall architectural diagram

Figure 2: Student record system overall architectural diagram

Tasks of Students and Admin are explained in the figure below:

Figure 3: Task in detail

Interview Questions

With front-end designer:

  • What entries are needed for a student form wherein details can be entered?
  • What entries are needed for the resulting form so that admin can add marks for the students?
  • What entries are needed for the course and subject form?

With back-end designer:

  • What columns should be used for a student table, result-in table, course table, user table, and fees table?
  • Which column should be the primary key to help in unique row identification?
  • How to connect the front end and back end?

Tables

Student table:

Student_id

first name

last name

gender

age

Date of birth

Contact no

address

City

CourseId

email

Password

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

int

date

int

Varchar (100)

Varchar (30)

Varchar (30)

Varchar (30)

Varchar (30)

Course table:

Course_id

Course name

Subjects

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Subject table:

Subject_id

Subject name

Course_id

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

User table:

User_id

username

password

role

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

Result table:

Result_id

Student_id

first name

last name

Course_id

Subject_id

Marks obtained

Total marks

Grade

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

 

Varchar (30)

Varchar (30)

Int

int

Int

Student Record System Application Manual

Software required: Wamp Server, MS Access, ODBC driver, and Windows 7 or above operating system

  1. Extract the Zip file as an SRS folder.
  2. Install Wamp server
  3. In the www folder of the Wamp server Copy and paste SRS complete folder
  4. Open the Wamp server and start all the services
  5. The SRS folder has a database file named srms.mdb file.
  6. Open odbc driver by clicking on data sources.
  7. Click Add and select Microsoft Access Driver .mdb and accdb.
  8. Enter the Data source name as srms and select the folder path where the srms.mdb file is i.e. C:wamp/www/SRA/srms.mdb
  9. Click finish and see that the srms.mdb is listed as the new database.
  10. Now open a web browser and type URL localhost/SRS

This shall open the home page

  1. The admin can enter the application through username and password as admin and admin

  1. From the dashboard the admin can navigate to any sections like course, fees, subjects, students, results, etc.

For example Admin wants to add a student

  1. The student form opens wherein the student details can be entered.

In this way results, courses, subjects, etc can be added and updated.

On the student end, the student can enter the application through the Roll number as a password and select the class from the dropdown list.

  1. On entering details if the results are not ready you get

Otherwise

From where the result file can be downloaded.

ER DIAGRAM

Download Student School Record Keeping System Application Database PHP, MySQL, and MSAccess Project Code and Database.

Online Voting System ASP.Net Project Synopsis

SYNOPSIS

Project Title: Online Voting System

ABSTRACT:

This is a web page in which we create a voting system. We consider that all voters are preregistered by admin when the voter login for voting he/she can give only one vote. This project developed for threat free and user-oriented Online Voting System. Online Voting System is made for the voters who want to vote for their favourite candidate sitting at home or from any location.

INTRODUCTION:

The online voting system is implementing in Asp.net using MsAccess database.  The main aim of the online voting system is to develop communication with candidates. This web page used by the college for mini-election in which voters who have registered by admin can vote for their favourite candidate. The voter will log in and give its vote to its candidate to whom voter wants to vote.

PROJECT OVERVIEW:

Admin will register voters and candidates who are standing in an election or any other activity. Only admin can check the result.

PURPOSE:

To make the communication strong with the candidate and to provide the easy way for voting. To increment the voting percentage. As many people have their physical issue that they cannot go to voting boot so this system gives facility to voters that they can vote from any place or any location.

PROJECT SCOPE:

As this project is online so it is easy for voters to give the vote to their favourite candidate from any place or location

PROBLEM DEFINITION:

The voters must keep their login id and password secrete because the voter can vote from any place. As the project is online so anyone can vote using its login-id and password.

Project Objective:

The casting of the online voting system from virtually from college building and display voting results for the administrator to analyze and provide a most secure and user-friendly online voting system.

CONCLUSION:

By using the online voting system it will become possible to cast vote easily and without partiality. Thus seamless voting using the central database is possible and will cause no repetitions of votes.

Web Designed System for University Project

INTRODUCTION OF THE PROJECT

This project is a web-based application, which will be helpful to the students all over the world. This Web Designed System for University project was developed with the purpose of making students all over the world comfortable in getting different types of information of the University.

This Web-based application will allow user to surf various hierarchies, get its information and also fill in the admission forms.

This Web Designed System Web Site is made very user friendly and even the layman will find it very comfortable in using it. It has several important features like mark sheets, merit list, forms, site map, etc.

This Web Designed System application is easy to use at the same time efficient enough to serve purpose. This project is an attempt to gather the various scattered information about University. So, by doing this, we utilize IT in bringing comfort and cutting an edge for bringing the development of the University.

SYSTEM ANALYSIS

PROBLEM IDENTIFICATION

One of the most difficult tasks of the system is the problem identification of the existing system. Without the clear understanding of the problem in the system, any further work done will lead to wastage of time and energy at a later stage.

This stage involves identifying the root cause of the problem in the existing system and reach to it. This makes it possible to incorporate further modifications in the current system so as to make it more feasible.

ACTUAL PROBLEM:

The existing Web Designed System lacks details about the information about the admission process in any faculty. The mark sheet of any particular student cannot be obtained from the system, so the student has to personally contact his/hers college. The merit list of any particular admission process cannot be obtained online, so the students have to meet personally to the college for the same.

SOLUTION:

Developing a website is a much easier way to reach students all over the world as compared to other media such as advertisements, newspapers, etc.

The students feel quite comfortable by using the site, as much of their time and energy is saved by not meeting the institution personally.

FEASIBILITY STUDY AND COST-BENEFIT ANALYSIS

This report is the output of the Web Designed System analysis, which is carried out at the onset of this system. It tells us that the system requested is feasible. This study involves through analysis of the existing system. After the thorough study of the system, feasibility study is being made.

This report includes the following:

EXISTING SYSTEM

  • It includes brief information of University, courses offered, etc.
  • It includes the brief note from the Chairman about the University and their contact numbers.
  • There is a lack of interactive section for all those who wish to enroll in the University and also lacks in access of the mark sheets of any particular student.
  • There is also a lack of many features like online merit system, online search of the site, etc.
  • The existing system is not capable of letting users send their thoughts, opinions, suggestions, etc. regarding the university.

CURRENT DEFICIENCIES IN THE EXISTING SYSTEM

  • The existing system does not include the detailed information about the admission process in the University. It does not include the fees infrastructure for any course offered.
  • It does not contain the detailed information about the web site, so the layman would find difficult to access it, as there is no search mechanism or any site map.
  • It does not contain the mark sheet system for the current year, and also the merit list for any particular entrance test conducted.
  • The information is a bit scattered and too brief, so the student interested have to meet personally to the university.

NEED FOR THE NEW WEB BASED SYSTEM

The inconvenience of the people and the confusion in accessing the scattered information about the University paved the way for the development of the web-based system.

Main reasons for the development of the new web based system:

  • To help students in easily gathering the scattered information.
  • To facilitate students in getting and filling up the forms.
  • To help students in accessing detailed knowledge about the city and the university their in.
  • By creation of such user-friendly web based system the University would definitely prosper, as more and more people would be able to know about the university and the excellent courses offered with in.
  • To help students in gathering the detailed list of the courses offered and their durations.
  • To use IT for the general purpose.
  • By this application, it is assumed that the students will come closer to the University and much of their grievances will be removed.

GOALS AND OBJECTIVES OF THE NEW WEB BASED SYSTEM

There are certain goals and objectives set for this Web Designed System. They are as follows:

  • It should bring people closer to the University by providing necessary information.
  • Facilitate the students in getting desired admissions forms and merit lists.
  • Use IT for the benefit of the students all around the world.
  • Simplify the working of the whole organization.
  • Students should feel comfortable in getting forms as well as the information related to the University.
  • Provide a smooth touch in the working of the University.
  • Make the University courses and the admission process more transparent to the layman.
  • Speed up the task of accessing necessary information.
  • To help individuals in solving there problems regarding the University and the web site and provide relatively better solutions.

PROJECT PROFILE

PROJECT:  Website development for University.

BACKEND TOOL   :  Microsoft Access,

FRONTEND TOOL : Active Server Pages (ASP)

Output Screens :

User Screen Of Main Page

Welcome page for the User. This is the main university page that displays all the links content in the site. It contains 3 frames and the name of the developers.

User Screen of History Page

This page displays the history of Sardar Patel University by clicking on the links frame on the left hand side of the page.

User Screen of Vallabh Vidyanagar Page

This page displays the history of Vallabh Vidyanagar by clicking on the link present on the previous page. It shows the history of Vallabh Vidyanagar.

User Screen of Courses Page

This page displays the Courses offered by Sardar Patel University by clicking on the links frame on the left hand side of the page.

User Screen Of Department of Computer Science Page

This page displays the List of the Courses offered by the Department of Computer Science of Sardar Patel University by clicking on the links of the previous page.

User Screen Of Courses of MCA and PGDCA

This page displays the Course Details the MCA and PGDCA of Computer Science Department of Sardar Patel University by clicking on the link of the previous page.

User Screen for Online Admission Form

This page displays the Login Page of the Online Admission Form of Sardar Patel University. From here one can sign for new registration as well as edit the existing information by providing the Registration Number and Password.

User Screen Of New Registration Form

This page displays the fields to be filled during the new Registration Form. Use to store the information of the new Student. One can view this page after clicking the New User button on the previous page.

User Screen of Login Page

From here one can sign for new registration as well as edit the existing information by providing the Registration Number and Password.

User Screen of Registration Form Used for Editing

This page displays login page for the online mark sheet of a particular student by providing the appropriate seat number. This page can be viewed by clicking on the link present on the left hand side frame of the welcome page.

User Screen for Reports

This page displays the reports included in the site.

User Screen for Mark Sheet

This page displays the login page for Mark sheet of any semester of the current year.

User Screen for the Online Mark Sheet of MCA

This page displays the Online Mark Sheet of the Student according to the seat number and the semester.

User Screen for the Aggregate Marks of the Student of 6th Semester

This page displays the aggregate marks of the Student of all the semesters.

User Screen of Merit List Of MCA

This page displays the Online Merit list for entrance test of MCA conducted by Computer Science Department of Sardar Patel University.

User Screen for the Online Registered Forms

This page displays the choice for the reports of the registered students.

User Screen for Report of Registered BCA Students

This page displays the report of the students enrolled by the registration form having background as BCA.

User Screen for Reports of B.Sc.CS. Registered Students

This page displays the report of the students enrolled by the registration form having background as B.Sc.CS.

User Screen for Reports of Other Fields Registered Students

This page displays the report of the students enrolled by the registration form having background as Other Fields.

User Screen of Feedback Page

This page displays the feedback screen by clicking on the link present on the left hand side of the Welcome page. On this page one can provide the Feedback of the site.

Library Management System .Net Project

LIBRARY MANAGEMENT SYSTEM

This is the Library Management System software which is used to computerize any Library System so that all the transactions become fast and there should not be any errors in transactions. It replaces all the paperwork. Opening the software requires login with the user name and password. It performs all the features of the modern library book issue, return, and fine calculation. Readers can issue books, return books and find books in the library by a simple search done on the book id. Fine can be updated or changed depending on the requirements of the administrator. It keeps records of all the books, given to the customers, so that administrator could update his daily reports. Reader and book details are also maintained and the administrator holds the main account. Security and authentication are maintained by keeping a record of reader names and passwords; the administrator holds the main account and password. Different reports can be generated like daily reports and user reports, book type reports, and book code reports.

NEED ANALYSIS 

The advancement of Computers and their Technologies brought a revolution in the world, it hit every aspect of life. Nowadays every field and its working are computerized.

It is very beneficial as our paperwork is reduced to a minimum. So it is essential that we have a library that is computerized and equipped to deal with the daily transactions in an efficient way so that maximum work is done and the performance increased. So there is a need to develop software that can cope with all these requirements and that is cost as well as time effective. We have developed such a project that can cope with the daily needs of a library that includes transactions like issuing a book, returning a book, search a book.

Now, with the computerized Library Management System, we aim to present users with a much better and easier interface and search options and side by side provide other options like details of books and readers and options like fine management which includes calculation work. One may encounter difficulties in finding the required product or the same process might be very hectic on many websites.

OBJECTIVES

The goals of this project are: –

  • Security – The user has to provide a password in order to enter. Hence it provides security.
  • Easiness – The user simply has to follow a series of instructions which makes the project very simple to use.
  • Speedup result processing While manually it may take time to search for books but it helps to speed up processing. And also issue and return processes are easy. Also, a database for students and books helps in speeding up the work of management of the library
  • The library management system is software for automating the manual library system of a college.
  • Functionalities of the active library like issuing books, returning books, and query processing.
  • The Books and Students are given a particular unique id no.  So that they can be accessed correctly and without errors. Our main aim of the project is to get the correct information about a particular student and books available in the library
  • The library management system is standalone in nature.
  • Keep a record of updated books & students database.
  • The project is implemented to bring a simpler interface for the users and provide them with easy search and access methods.

SYSTEM REQUIREMENTS

Software Requirement

  1. Microsoft Windows 2000 or above.
  2. .Net platform
  3. Microsoft Access.

Other Requirements

  1. Internet connection for online help

Diagrams:

  • E-R Diagram
  • Data Flow Diagram
  • Activity Diagram
  • Database Tables

Output Screens:

Login Form
Administrator Menu (Parameters)


Administrator Menu (Security)
Security


User Maintenance


Administrators Menu (Utility)


Librarian Menu
Librarian Menu (Book Options)
Add A New Book
Reader’s Options (Find A Book)
Reader’s Options (Edit Book Details)


Librarian Menu (Readers Options)
Librarian Menu (General Options)
Today’s Issue Inquiry
Issue A Book
Return A Book
Find A Book
Reports
User Report
Book Code Report
Book Type Report
About Menu

LIMITATIONS: 

  • The project is designed to run on a single machine, with no option to run on a network of computers

(LAN etc.).

  • The design of the project is not up to the level of the software market, it has a lot of scope to improvement.
  • There is no option for the reader if he/she forgot the password. If he or she forgets his or her password they need to sign up again.
  • The reader or the administrator can use this one at a time, which means only one transaction can be processed at one time that may be issued, return, or any other.
  • The database is not vast.
  • There is no option for the payment receipt of the fine submission.

SUGGESTIONS FOR FUTURE WORK: 

  • Projects can be further enhanced with the facility to run projects on multiple machines (LAN) so that more than one library for the same institution can be connected through the same database and controlled by the same mechanism.
  • In-depth details regarding every, security aspect of the project need to prepare, and then taken steps taken or functionality included to preserve security.
  • Enhancements can be made to provide users with the option that if one forgets his/her password then it can be changed or retrieved.
  • A new option like an option for the payment receipt of the fine submission can be included.

CONCLUSION:

  • Project is fully complete and running with every aspect of coding and connectivity with the database.
  • We have tried our best to present a simple interface to the user and remove the complexity of using a manual library like searching and fine calculation.

Download the complete Library Management System .Net Project Source Code and Database

Insta Bank – Wireless Banking Project Synopsis

Many banks today want to provide the best services to retain their customers. Internet has been a lone solution for quite some time.  Today banks are looking forward to harness the potential of wireless technology to better connect with its customers and offer enhanced retail services.

What the banks require today is a facility to inform clients of events and to facilitate and quickly respond to client inquiries. Many banks are losing lots of their customers just because they cannot cater to their customers want of necessary information anywhere and anytime.

Also customers today are becoming more and more futuristic and would want information on various transactions and also be reminded about them almost as immediate as it happens.

In addition, banks are searching for a solution where customers don’t have to be online every time they make a transaction compared to internet banking. Getting necessary information on your mobile device at your request”.

Reach your customers the most cost effective and trendy way.  A Complete solution to communicate instantly, efficiently and cost effectively with individuals or groups, anytime and anywhere.

Mobile banking through SMS is today becoming not just a value add but a necessity when considering present banking scenarios.

For example, let us take into consideration of a person who is on

the move and requires some  immediate information on his bank account. With his mobile device he can just send a message and within few intervals of time he would receive the necessary information.

As per a recent survey: “In 2002,366 billion messages were exchanged world over, which included 5 billion from India”.

There is a huge list of mobile users, which only adds to the existing list of advantages.

The mobile SMS banking solution is an open frame, doesn’t need any major customization.

Get mobile with InstaBank.

Key Features:

InstaBank can be segregated into 2 categories:

Customer Related Transactions:

  • Cheque Status
  • PIN Change
  • Statements
  • Balance Enquiry

Automatic Alerts: 

  • Withdrawal Above Limit
  • Specific Withdrawal
  • Deposit Above Limit
  • Specific Deposit
  • Balance Below Limit
  • Cheque Book Issued
  • Day End Balance

Some of the added features are: 

Single and Group Text Messaging: Send messages to an individual or a group by selecting the concerned from the member list.

History Log: Administration of sent or received messages. The log of each day is stored in a separate file, thus making it very easy to check the history of messages.

Monitor existing database & Authentication:  Add, update or delete customer list from the already existing database and authentication till 3 levels.

Automated Alerts: Send automated alerts to one or many by setting the timer. A message is sent at the time that has been set. 

Reports: A feature has also been provided where a report carated on the messages sent depending on the date.

Benefits :

Customer retention: Build on existing customer relationships to improve productivity and maximize customer loyalty. Boost customer retention. Make sure your existing customers are satisfied. 

Easy and fast communication medium: The solution is easy to use and since customer communication is through SMS medium the message reaches the customer in a jiffy. 

Focus on core competencies: No more concerns about promoting your brand and in communicating with your customer. Focus on your core business activities and competition. 

Anytime, anywhere banking: Unlike other mediums of banking like emails or snail mail the sms banking media can be used anywhere and at anytime.

Reduced human errors: Since there is very little human interaction required, the Solution being automated even small human errors can be reduced.

Save costs on unnecessary phone calls: There is a huge reduction in the calls made to the bank or to customers since the customer inquiries are answered almost till the last level.

Technologies Used – Good understanding of Basic Java, Java SMS API (third party tool), Networking in Java, MS access, Any operating system.