Category: SQL Server Projects

Engineering computer science students who are looking for SQL Database Server 2005, 2008 projects for beginners and can download sample SQL projects with source code and report for free. Download All Latest SQL Database Projects, SQL Projects Ideas, SQL Presentations & PPT’s Here.

Posted on

Car Showroom Management System JAVA & SQL Project

The Car Showroom Management System consists of four major fields of management i.e. store cars, store Sales Persons, store admins, store customers and store total sales progress. Here the store admin manages all the activities such as viewing and adding car details, salesperson details, and admin details of different stores. Each store has a Manager and the Manager’s task here is to fill in the details of the car, customer, sales, and workers of a particular store.

The main goal of this application is to maintain the records of different stores which are visible only to the admin and can only be updated by him. It helps to achieve ease of access in searching car details of the selected store, salesperson’s details of the selected store, and sales details of the selected store.

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

PROJECT PURPOSE

Provides a simple way of accessing the database. Allows the admin to make a search and find certain bikes, customers, and sales records that are linked through a TIN of different stores located at different locations. Provides centralized control of store database. Holds complete information about the customer.

PROJECT SCOPE

The Car Showroom Management System application is designed and developed so that there will be the elimination of storing the records and other details in a hardcopy thereby supporting its eco-friendly nature. The Bike Showroom Management System application is quite simple and easy to use. This application has not had many Complications. It has a very simple way of maintaining the store records such as storing the bike Details of a certain store, customers visiting a certain store, and the sales details of the store that the admin chooses to gain access to.

PROJECT GOAL

This CAR Showroom Management System project aims to show the shadow implementation of JAVA & SQL which includes a better storage facility, update, and view of data. The application provides a user-friendly interface so that the admin can access it with ease.

Download Car Showroom Management System JAVA & SQL Project Source Code, Project Report.

Posted on

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

An insurance management system is a personal intranet-based web application developed by a group of insurance broker agents to make your insurance policy and claim review process easier and more flexible.

The web application is used to check and monitor the status of customers who have adopted new policies in the context of distributed access in your organization, and to notify them of the terms of the policy’s premium payments and requirements. In fact, the system is designed to accelerate the process in your business process to increase customer satisfaction and keep the overall flow of customers in this domain smooth and stable.

The main problem of manual operation is the registration of holders of existing insurance policies and their regular maintenance of insurance policy payments. Providing regular services also takes a lot of time by searching the registers of the current customer base. If it is possible to automate the data storage process and increase search control, there is always the opportunity to get additional customers in turn, which will increase the profitability of the organization.

The real purpose of choosing this system is to speed up the organizational process. Agents can have the expected information at any time, in any instance. Creating the required reports in accordance with operational requirements will be much easier and information will be available. The system is not only false evidence but also has a high level of customer satisfaction.

The application is also security-oriented and is expected to be fast as a shared access structure because it communicates within the system.

Project Characteristics:

  • The agent can view the required information at any time, whether it is a policy or a customer, with the click of a mouse and the example the second.
  • If planned in an organized manner, customers can be provided with an online terminal where they can receive information with their own hands without major intervention.
  • Customer or policyholder alerts can be generated at lightning speed by asking specific customers.
  • Data can be shared via a single-window link in their respective databases, saving time entering multiple data while they are being collected.
  • The status of the premium payment on the clients’ policies can be systematically discussed by the Agents to check for non-payment.
  • A specific policy can be clearly monitored by the detainee and checked before the claim is resolved.
  • Most importantly, the overall system can provide consistent and reliable authenticated information about your transactions at any time.

Current System:

In general, if a user plans to create an insurance plan manually, they will need to perform a number of activities.

It is a very tedious process for the agent to keep records of what is happening through the system and the required information that may be generally needed at all stages.

In increasing the customer base, the manual search process is very tedious and time-consuming, which repeatedly frustrates the customer with the agent.

Recommended System:

With the new system, the following activities are gaining momentum.

The actual process of the organization can be modulated into three different independent views

  • Agent Appearance
  • Opinion of the policy owner
  • System Administrator View
  • Agent

At any time you can view the required information or policies, or customers with an example of a click of a mouse and a second.
If planned in an organized manner, customers can be provided with an online terminal where they can receive information with their own hands without major intervention.

Modules:

The actual process of an organization can be modulated into three different independent perspectives

  • insurance company information
  • Agency Information
  • customer information
  • Policy Information
  • Policy payments
  • Political demands
  • Security information

Download Insurance Policy Maintenance and Claim Management Process .Net Project Source code, Report, PPT using C# and SQL Server

Posted on

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

To create a new Bug Tracking System, which enables the user to detect the bugs and notify colleagues and administrators to get the rectification from them immediately.

This project “Bug Tracking System” handles the Organization details in the database in an efficient manner. This system is more innovative to use, any user can make up easier and faster transactions between employees. This site can be used under any private concern, for flexibly handling the databases, to get dispatches the data to process them for individual usages. Thus it makes the system more flexible, and more reliable for use.

For all the above this site is the perfect place for users, especially employees who preferred to save time and entered into the current trend.  Thus the entire project of the Bug Tracking System is clearly tested; all the modules are working correctly, as well as the output is verified.

Modules

  • Employee Details
  • Priority Master
  • Project Details
  • Status Fixation
  • Fast Search
  • Add Bugs

Module description

Employee Details:

The employee details module allows the administrator to make the entries for the employee with their proper identities such as name, email-id, mobile number and etc.
 
Priority Master:

The priority master module allows the administrative people to fix up the priority for the occurrences of the fore coming errors, which are assigned or created as high, low, medium, and so on.
 
Project Details:

The Project detail module allows the administrator to create the details about the ongoing projects, their issues, the status of the project, and its responsible person details.
 
Status Fixation:

The status of the project and the position of the bug is fixed by the user with its completion status, affection-causing range, prioritization, and so on.

Fast Search:

The fast search module allows the user to search the current project records in a simpler manner with details such as project name, respective person details, and so on.
 
Add Bugs:

The add bugs module allows the user to create the bugs which they are facing from their projects, and publish that problem to the general users for clarification, which leads other users to carry on the bugs and rectify them with their own ideas.

Download the Complete Bug Tracking System project source code, Report, and PPT.

Posted on

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.

Posted on

Web Based Training Management System .Net Project

PRELIMINARY INVESTIGATION

1) Interview:

For making software for a company, we need knowledge of their existing system. For this purpose, we take interview of some persons working in that company.
We gather information from taking interview of that person who is related with this software. As- Training Coordinator, Hostel Warden, Trainee, Guest Faculty.

2) Group Discussion:

It was the discussion among the company people who were involved in the project. At first, many ideas were pooled in and existing themes, concepts which the other web applications were using were chosen. And then all these ideas were brought into action by the programmers.

3) Online observation :

It is the process of getting close details of the existing software or web application from the internet. The major objective is to get as close as possible to the system.The information on the TRAINING MANAGEMENT SYSTEM software was obtained from the existing web applications which are running successfully.

4) INFORMATION DESCRIPTION

Training Management System and web application:-.

1) The purpose of the application is to help the director to get details about the training, hostel, feedback, employee, expenses etc.

2) Training Details, Feedback Report, Bill generate automatically.

3) It helps the Training Coordinator to manage the training details, Trainee Information easily.

4) This application also helps to hostel Warden to manage the hostel and mess details in an easy way.

5) This application is also useful for manage detail of Guest Speaker and their lecture information.

6) It helps to manage all visits during training.

7) It also calculates the total gain and expenses of walmi from a training.

Project Objective

To facilitate the process of management of training.
To provide a software for managing trainee registration and maintaining the records.
To generate feedback information from trainees in different aspects.
To generate feedback report for a particular duration.
To maintain an account for a training easily.

Project Introduction

The application provides a login facility to different uses of the organization.
If the login successfully then they use their form.
The application provides facility to manage trainee record and account for a training to the coordinator.
The application provides facility to hostel warden to maintain the record of a trainee who is staying in a hostel.
With the help of this application, the Director sees the feedback report in a different aspect.
This application is useful for calculating expenses for a training and also calculate profit.

Data Flow Diagrams:

Data Flow Diagram of Trainee:

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Minimum Hardware Requirement

Microprocessor : Pentium or Core-i series.
Primary Memory (RAM) : 512 MB
Secondary Memory (Hard Disk) : 16 GB
Video Display Unit : VGA Monitor.
Compact Disk Drives : 52x CD-ROM.
Keyboard : 101 Key Enhanced Keyboard.
Mouse : Serial Mouse.

Data flow Diagram for Training Coordinator

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Data flow Diagram for Guest Faculty:

Software Requirement

Operating System : Windows XP , Windows Vista , Windows 7

Language : Asp.net (C#.net)

Database : SQL Server 2005

Browser : IE, Mozilla Firefox

ER Diagram:

Use Case Diagram:

LIMITATION

  • After every lecture, we have to maintain the honorarium record.
  • There is no provision for suggestion box in feedback form as it was omitted by concern authority.
  • Only Check-in and check-out record from the hostel is maintained within the software.

FUTURE ENHANCEMENT

  • Online booking facility.
  • We maintain an attendance record of a trainee during training.
  • We Provide male – female reservation in hostel.

Above limitation can be rectified as per authority requirement

Tables Description:

This is table of “CouFac”, In this table we put the information of department of faculty head.

This is table of “Amount”, In this table we put the information of Amount of whole Training..

This is table of “employee”, In this table we put the information of employee.

This is table of “Faculty”, In this table we put the information of UserId and Password.

This is table of “gTraining”, In this table we put the information of lecture of Guest Speaker..

This is table of “Guest”, In this table we put the information of Guest Speaker..

This is table of “hostelCharges”, In this table we put the information of hostel charges..

This is table of “HostelEntry”, In this table we put the information of trainee stay in hostel.

This is table of “Trainee”, In this table we put the information of trainee comes for training.

This is table of “Training”, In this table we put the information of training conduct in organization.

This is table of “Transport”, In this table we put the information of transport used for training.

This is table of “FeedBack”, in this table we put the information of feedback of trainee given for training.

Conclusion:

We made a “Web Based Training Management System” for water and land management institute. This application provide them a automated system, which is very time saving then existing system in walmi.
We test this application by the different testing method and it works properly hence it is useful for the organization.
This application easily manage the training system.

Posted on

Motor Vehicle Loss And Damage Claimform .Net Project

MOTOR VEHICLE LOSS AND DAMAGE CLAIM FORM (E-COMMERCE TEAMWORK)

Project Requirements

In the motor vehicle, damage and loss can be claimed online by client and insurance company store those data.

In this client fills his personal information and then the vehicle information and incident information and claim detail.

Then when the client submits the claims details form it generates the flat file and stores the entry in the database of client side. When the server will check the form of server-side and will enter claim bill number if that flat file does not exist then will show file is corrupted and if the file exists then will show all the information and if the server accepts that the information is stored in the server database.

Data dictionary

  • Client Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount
  • Server Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount

Snapshots

CLIENT SIDE FORM

 

Client filled form and by clicking on submit button flat file is generated and will be stored in client database.

ALL THE VALIDATIONS

FLAT FILE GENERATED

Server-side form

Sever side auto-filled from by entering a claim bill number and pressing read button and by pressing the save button will be stored in the database.

Download the below-attached Loss or Damage Claim form for Motor Vehicle project code

Posted on

Bank Management System .Net Web Application project

System Analysis

System Summary: The West Bank Management System project involves the creation of a Web application that will enable the customers of West bank to:

View the details of all accounts that they hold with West Bank.

View the accounts statements for all accounts that they hold with West Bank.

  • Apply for loans online.
  • View the status of loan requests.
  • Requests for checkbooks for any of their accounts.
  • View the status of checkbooks requests.
  • Transfer funds from any of their accounts to another account in West Bank.
  • The Web application will also be used by the employees of West bank to process the requests for loans and checkbooks.

In addition, the application will be used by the administrator to:

Create User-IDs for customers, employees, and administrator and assign them the respective roles.

  • Link User-ID created for customers to the respective Customer-IDs.
  • Upload, edit and delete news items that will appear on the homepage.
  • Upload, edit and modify the information related to various types of loans.
  • Upload, edit and modify the information related to various types of accounts.

Each of the three types of users should also be able to change their password and retrieve their password in case they forget the password.

West-Side bank already has a computerized system in place that maintains the details of all the customers and accounts. The proposed Management System Web application will use the existing database to obtain the details of customers and accounts. Some additional tables may have to be created in the database to accommodate the specific requirements of the Web application.

HARDWARE & SOFTWARE REQUIREMENTS

Hardware: CPU, Mouse, Keyboard, CDs, Printer etc.

Operating System: Window 7 Home Basic-E Series, I3 Processor

Software: Microsoft SQL Server 2008, Microsoft Visual Studio 2008, Microsoft Office etc, Microsoft Office Word, Microsoft Office Visio, Google.

UML Diagrams:

Administrator Accounts Diagram

Customer Accounts Diagram

Employee Accounts Diagram

ER Diagram:

Database Coding:

Database Name Westbank

Car_Loan Tables Details:

  • State_Name
  • Current_City_Date
  • Current_City_Month
  • Current_City_Year
  • Residence_Type
  • Current_Residence_Date
  • Current_Residence_Month
  • Current_Residence_Year
  • Date_Of_Birth_Date
  • Date_Of_Birth_Month
  • Date_Of_Birth_Year
  • Model_Of_Car
  • Employement_Type
  • Salary_Deposit_Yes
  • Salary_Deposit_No

Table Create_Account Details:

  • First_Name
  • Last_Name
  • DOB_Date
  • DOB_Month
  • DOB_Year
  • Address
  • City
  • State
  • Pincode
  • Country
  • Phone_No
  • Email
  • Mobile
  • Status

Table Enrollment_Form Details:

  • First_Name
  • Last_Name
  • Address
  • City
  • State
  • ZipCode
  • Country
  • Tax_Id
  • Home_Phone
  • Mobile
  • Fax_N0
  • Email

Table Locate_Your_Branch Details:

  • Branch
  • Address
  • Telephone
  • Fax
  • ATM
  • Lockers
  • IFSE_Code
  • Working_Time

Table Saving_Application_Form Details:

  • Title
  • First_Name
  • Last_Name
  • Address
  • Pin_Zip_Code
  • City
  • Nearest_Branch
  • Email
  • Residential_PhoneNo_STD
  • Residential_PhoneNo_Phone
  • Office_No_STD
  • Office_No_Phone
  • Office_No_Extn
  • Mpbile_No

Table Customer_Acc_Create Details:

  • Account_Type
  • Customer_ID
  • Minimum_Balance
  • Opening_Balance
  • Overdraft
  • Fixed_Deposit

Table Customer_Acc_Update Details:

  • Account_Type
  • Customer_ID
  • Minimum_Balance
  • Current_Balance
  • Status
  • Overdraft
  • Fixed_Duration_Deposit
  • Maturity_Date

Table Emp_Create_Transaction Details:

  • Transfer
  • Withdraw
  • Deposit
  • From_Acc_No
  • To_Acc_No
  • Amount

Table login Details:

  • User_Id
  • Password
  • Users
Posted on

Information Pool System .Net Project

The Information Pool provides a number of services to the users in terms of events management, classifieds, discussion board, news, polls, blogs etc depending on the handling of this Information Pool it is broadly divided into two major modules. They are

  • Administration
  • User

Administration: This section of the Information Pool System has all the features of the user as well as added features of administration such as news hosting, site management, configuration, registrations etc.

User: This section is a restricted one and has all the below-mentioned areas.

Welcome Page

The welcome page is the main Information Pool System navigation area. It consists of several blocks that display partial content of the module or other data. The blocks also serve as access points for navigation into module pages.

Welcome page components are laid out into 3 columns:

left column

  • search block that allows to search Information Pool content by keyword
  • events summary that displays several nearest events
  • discussions overview that displays most recent threads
  • links area that display selected links to external sites

the middle column contains short articles extracted from the database

right column

  • classifieds summary presenting most recent classified ads
  • news section displaying news articles or other content extracted from external news sites
    In the default setup, the news section is utilizing JavaScript component

User Registration And Login

First-time Information Pool System user can register to access restricted Information Pool areas and services using the “Join Us” button located in Info Pool header. The registration form can also be used to modify user information if the user is already logged-in.

The user is logged-in if the welcome message contains username displayed below header buttons.

All new users are automatically assigned Security Level 1, which allows them to participate in Info Pool community activities. The Administrator (Level 3), can upgrade the security level of a user to Level 2 (Editor) or Level 3 (Administrator).

Additionally, the Administrator has options to configure email notifications so that users receive Email Confirmation upon successful registration. They can also retrieve lost password via email.

Info Pool Administration

The Administration Module is accessible only to Editors (Security Level 2) and Administrators (Security Level 3) and can be used to manage Info Pool content and configuration.

Most of the administration pages are organized as two-page editing schema. One page contains a list of available items (optionally with searching capabilities) and by clicking items in this list one can navigate into another page containing a form for modifying item data or entering new item data.

Articles/Content

This section is used for review and maintenance of articles appearing in the middle column of Information Pool System’s welcome page. The articles will be ordered by “order” number assigned to each one.

News

This section is used for review and maintenance of news articles appearing in the right column of Information Pool System’s welcome page. By default, the Info Pool is configured to display news headlines.

Events

This section is used for review and approval and of Events submitted by users, as well as for adding new and maintaining existing Events.

Links

The links section is used for review and approval and of Links submitted by users, as well as for adding new and maintaining existing Links.

Link Categories

This form allows the review and maintenance of link categories.

Forums

This section is used for creating and maintaining Discussion Forums. Forum details contain forum information and allow selection of forum moderator from the list of registered users.

Classifieds

This section is used for review and maintenance of Classified Ads submitted by users. Inappropriate ads may be deleted or marked as inactive.

Ad Categories

This form allows the review and maintenance of available classified ad categories. It contains the current category list and forms for editing the category.

Members

This section is used to search, review and edit the list of registered Information Pool System users. The administrator can modify user information, delete users, as well as assign security access level to each user. The Member List page contains “Export To Excel” link, allowing to export Members to Excel.
Members can also be assigned a membership status for organizational purposes, such as candidate, member, or supporter. This status is not used elsewhere in the Information Pool System, except in the Email module.

Member Statuses

This form allows for review and maintenance of user statuses, for organizational purposes.

Send Emails

This page can be used to send email messages to selected Information Pool System users. It allows selection of Member Status to whom the email should be sent. The administrator also needs to enter email parameters, such as From, Subject and email Body.
Email history is also shown on the screen.
Email functionality may require additional email component to be installed on the server, such as CDONTS for Windows. Please contact your hosting company, if you experience issues with sending emails.

Data Dictionary

Info Pool Security

The Information Pool System is configured with 3 default users and 4 security levels, as shown to the right.

Security Level 0:

All visitors who are not logged in have security level 0 with limited permissions, allowing them to view Information Pool System areas. The administrator may configure the Information Pool to allow or disallow anonymous visitors from submitting new content like Events, Links, and Classified Ads.

Security Level 1:

All users who register and log in to the Information Pool are automatically assigned security level 1, allowing them to fully participate in Information Pool community activities. They can submit new content, although some of such content may require approval by an editor or administrator.

Security Level 2:

This security level can be assigned to users only by the administrator and is usually assigned to editors who may submit, review, approve, change and delete content.

Security Level 3:

This is the highest security level, available only to Information Pool owners/administrators and allows them to modify and delete users, configure Information Pool settings, and send email notifications to users.
Information Pool Configuration screen allows the administrator to specify if users need to login to be able to submit new content.

UML Diagrams:

Context Level Diagram

Administrator Use Case Diagram:

ER Diagram:

First Level DFD:

Second Level DFD:

Info Pool Layout

Every Information Pool page contains 3 areas:

Header: contains navigation buttons, Information Pool logo, and Welcome message or User Login information.

Main Content: welcome page or module content is displayed here

Footer: contains Information Pool navigation hyperlinks

Info Pool Configuration

This form contains Information Pool configuration options that affect Information Pool functionality. They include:

  • Information Pool URL
    URL of Information Pool welcome page used to redirect users back to the Information Pool, when they submit event payments via PayPal.
  • Users must be Logged-In to submit new content
    Global setting determining whether only registered Information Pool users are allowed to submit events, links, discussion messages and classified ads
  • Expanded Discussion Search
    this setting turns on/off alternate Discussion Search Results page. When “On” Discussion Search Results show individual replies instead of discussion topics.
  • Email Sender Address
    Default address for “From” field when sending emails
  • Enable Email Registration Confirmation and Password Retrieval
    If you want to utilize emails on your website, you should turn on this feature. It enables users to retrieve their lost passwords via email. It also confirms new user registrations via email
  • Registration Confirmation and Lost Password Body
    In this area, you can supply the email message that you want to send to users when they register or forget their password. You may also use special tags {login} and {password}, which will be replaced with the actual Login and Password of the user that is being emailed.

Info Pool Registration

This URL connects you to Smart Registration Page where you can register the usage of this application. The registration is free and allows you to be notified about the availability of future upgrades.

Support

This URL connects you directly to the Smart Support System where you can submit technical questions, issues, and requests.

Output Screens:

SOFTWARE REQUIREMENTS:

  • WINDOWS
  • Visual Studio .Net Enterprise Edition
  • Visual Studio .Net Framework (Minimal for Deployment)
  • SQL Server

Download This Information Pool System .Net Project.

Posted on

Freight Forwarding Management System .Net Project Synopsis

This Freight Forwarding Management System software keep track of all activities (booking, container allotment, stuffing, customs clearance, raiment, ship-on-board, delivery, debit note, credit note etc

The containers for Shipping are delivered to Consignee after a relevant process including order booking, stuffing, customs clearance, raiment, delivery etc.

A freight forwarder is an individual or company that exports the goods from one place to another.

The freight forwarder does not actually carry the cargo or conduct business for the ship.

It is an intermediary between carrier and owner of goods being transported.

This software is based on 3Tier Web Architecture powered by the Microsoft’s Dot Net Technology. This software will be implemented in ASP.NET. With this software will handle all the Freight Forwarding Management system software, the user can have access to world-class services any time, any place in the world.

This software keeps track of all activities (booking, container allotment, stuffing, customs clearance, raiment, ship-on-board, delivery, debit note, credit note etc. The Containers for Shipping are delivered to Consignee after a relevant process including order booking, stuffing, customs clearance, raiment, delivery etc. A well Standard reporting will be included in this software which will be very beneficial for the clients and users.

Design Of Solution

Functional Scoping of the Software

  1. Customer Module:- Includes all details of the customer/consigner
  2. Consignee Module:- Includes all details of the consignee.
  3. Agent Module:- Includes all details of the Agent who is dealing with the order.
  4. Shipping Line Module:- Includes all details of the shipping lines.
  5. Booking Module:- In this module booking of a order is done.
  6. Stuffing Module:- In this module container stuffing information is provided.
  7. Customs Clearance:- In this module custom clearance process is provided
  8. Railment Module:- In this module railment process is provided.
  9. Ship-on Board Module:- Finally the container goes to the destination(to the consignee).
  10. Delivery Module:- Goods to be handed over to the consignee.

Reports

  1. Master Daily Activity report
  2. Booking Report.
  3. Pending container allotments vs Bkgs and Containers Allotted Vs Bkgs
  4. Pending Stuffing on containers vs stuffed
  5. Pending Railouts Vs Railed out
  6. Railed Out Vs Shipped on Boards / Planned vessels
  7. Pending Shipped on Boards Vs Planned Vessel
  8. Outstanding Reports ( Clients ) Vs Receipts
  9. Outstanding Reports ( Agents ) Vs Receipts and Payables
  10. Pending Invoices / B/Ls and Invoices and B/Ls released vs Docs or SI Received
  11. Pending SI From Clients vs Cut off Dates/ Rail outs / Planned Vsl
  12. MSI Submitted Vs Cut offs and Pending MSI submissions vs Cut off Dates / Rail outs/ Planned Vsl
  13. Pending Prealerts / Manifests to agents Vs Shipped of Board
  14. Shipping on Board Vs ETA
  15. Arrivals Vs ETA
  16. Transshipments Vs Planned Transhipments
  17. Delivery Vs Arrivals

Facilities Required For Proposed Work

Technologies Used: – ASP.NET with C#.NET

Database Used: – Microsoft SQL Server

Web Services Used: – Advance XML Web Services.

Domain Required: – Any new domain registration is required.

Posted on

Grocery Ekart Management Real Time Project

Project Understanding:

The reference website link provided to the developer and also need few clarifications and inputs from the customer side specifically to understand the project flow. In this document, we present our understanding of what needs to be accomplished in the project along with the budget and time estimation.
Reference site link: https://www.bigbasket.com/  (checked only to have an idea regarding the features that will be there in the app)

Project Statement:

→ To design and develop an ekart marketplace and mobile app for Android platform which will provide an option to browse through various household groceries and related products.

Project Description in Brief:

The requirement is to develop and implement a fully functional ekart module which will allow customers register and browse through all products online. They can add products to kart and order them. It will also involve admin panel to manage the addition of products, editing details related to a product. It will manage payment gateway also. We will also provide an option to manage offers via offer management module in the admin panel.

1. Admin Module
2. Kart Module
3. User Module
4. Payment Gateway Integration (Let us know which all need to be integrated like Paytm, PayPal, VISA MasterCard etc)
5. Coupon / Offers Management
6. Employee and Executive Management
7. Order Management
8. Review and Rating Management
9. About Us
10. Careers
11. Privacy Policy (Client needs to provide us the info related to terms and conditions)
12. Terms and Conditions (Client needs to provide us the info related to terms and conditions)
13. Blogs (Let us know if this is needed)
14. Logo design
15. Notifications (Email and SMS , client need to purchase SMS package and it will be integrated)
16. Delivery management

Quality Control:

At the end of the development cycle, you will have a properly functioning and quality assured site. By ensuring implementation of the following points we maintain quality in the products we deliver.

➔    W3C validated semantic HTML code
➔    Well commented and indented PHP code
➔    Proper escaping of user entered data, the addition of captcha to web forms for preventing XSS, CSRF and other security issues
➔    Properly Optimized and indexed database tables for speed and consistency
➔    Minified CSS, JS and optimized images for faster loading of the site
➔    Implementation of meta tags, descriptions, open graph tags for help in SEO

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

→ Admin will have access to all modules on web and can monitor everything the application.
→ Customer will have access to products view and can browse through and access offers and then finally add products to the kart and order the same.
→ Employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only

Module Details:

Web development: 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)		 10 MD
       2. Common Admin panel:
Admin login features
Manages Employee executive delivery history
Manage Customers
Manage Products addition to applicationManage Reviews and Ratings in applicationManage Coupons and Offers in applicationsManage new offers (to be displayed in splash screen )
About Us submissions
Blogs management (if needed)
Categories / Sub-categories management
Brand management
Filter management
Location Settings		 20 MD
       3. Designing:
Homepage design with splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including smtp configurations), Careers, Privacy Policy, Terms & Conditions , Blogs design , Individual page designs , Menus and Submenus, Location selection design		 15 MD
      4. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option , a grid to view and manage all deliveries for executive login , option to update payment status for orders delivered 5 MD
      5. Testing, bug fixes, changes from client feedback 12 MD
      6. Total 62 MD (approximate)

 

Mobile: (2 Android Apps)

User App: Will follow all modules mentioned above except admin panel as it will be maintained only on the web.

Executive App: Will have screens designed for tracking deliveries, managing the delivery status, update the delivery and payment status 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with the history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)		 15 MD
        2. Designing:
Homepage design with a splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including SMTP configurations), Careers, Privacy Policy, Terms & Conditions, Blogs design, Individual page designs, Menus and Submenus, Location selection design		 15 MD
     3. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option, a grid to view and manage all deliveries for executive login, option to update payment status for orders delivered 10 MD
     4. Total 40 MD (approximate) + 10 MD for testing and feedback changes

 

Technology to Use

Design and Markup

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

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

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

– PHP (codeigniter, CakePHP, Phalcon or Laravel)

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

– MySQL

– SQL Server

Android: Java  (Android v 5.1 and higher)

Time frame for execution of the project ( Total 112 Days  approximate)

Designs & Web Services : 30 Days

Admin Panel :- 20 Days

Android App: 40 Days

Testing: 22 Days