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.
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
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
- Mobile
- Status
Table Enrollment_Form Details:
- First_Name
- Last_Name
- Address
- City
- State
- ZipCode
- Country
- Tax_Id
- Home_Phone
- Mobile
- Fax_N0
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
- 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
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.
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
- Customer Module:- Includes all details of the customer/consigner
- Consignee Module:- Includes all details of the consignee.
- Agent Module:- Includes all details of the Agent who is dealing with the order.
- Shipping Line Module:- Includes all details of the shipping lines.
- Booking Module:- In this module booking of a order is done.
- Stuffing Module:- In this module container stuffing information is provided.
- Customs Clearance:- In this module custom clearance process is provided
- Railment Module:- In this module railment process is provided.
- Ship-on Board Module:- Finally the container goes to the destination(to the consignee).
- Delivery Module:- Goods to be handed over to the consignee.
Reports
- Master Daily Activity report
- Booking Report.
- Pending container allotments vs Bkgs and Containers Allotted Vs Bkgs
- Pending Stuffing on containers vs stuffed
- Pending Railouts Vs Railed out
- Railed Out Vs Shipped on Boards / Planned vessels
- Pending Shipped on Boards Vs Planned Vessel
- Outstanding Reports ( Clients ) Vs Receipts
- Outstanding Reports ( Agents ) Vs Receipts and Payables
- Pending Invoices / B/Ls and Invoices and B/Ls released vs Docs or SI Received
- Pending SI From Clients vs Cut off Dates/ Rail outs / Planned Vsl
- MSI Submitted Vs Cut offs and Pending MSI submissions vs Cut off Dates / Rail outs/ Planned Vsl
- Pending Prealerts / Manifests to agents Vs Shipped of Board
- Shipping on Board Vs ETA
- Arrivals Vs ETA
- Transshipments Vs Planned Transhipments
- 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.
Source: https://1000projects.org/projects/sql-projects
Posted by: cerulloshawnnanoes.blogspot.com
