Project Front Page 5y6x35
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report l4457
Overview 6h3y3j
& View Project Front Page as PDF for free.
More details h6z72
- Words: 3,646
- Pages: 36
SOFTWARE FOR DTH DISTRIBUTOR Mini Project Report Submitted to AYYA NADAR JANAKI AMMAL COLLEGE, SIVAKASI. (Autonomous, Reaccredited with A+ Grade, College with Potential for Excellence) d to the Madurai Kamaraj University, in partial fulfillment of the requirements for the Degree of MASTER OF COMPUTER APPLICATIONS By V.SHANMUGATHAI (Reg. No. 09PA15)
POST GRADUATE DEPARTMENT OF COMPUTER APPLICATIONS AYYA NADAR JANAKI AMMAL COLLEGE (AUTONOMOUS) SIVAKASI – 626124 NOVEMBER 2011
1
Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D.,
Director, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
CERTIFICATE This is to certify that this mini project entitled “SOFTWARE FOR DTH DISTRIBUTOR” being submitted by V.SHANMUGATHAI, (Reg.No:09PA15), final year student of Post Graduate Department of Computer Applications is a bonafide record of work carried out by him under the guidance of Miss S. SUNATHA, M.C.A., Assistant Professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi. It is further certified that this project is him own work and not part of any other works or means.
Place: Sivakasi, Date:
Signature of the Director, (Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D.,)
2
Miss S.SUNATHA, M.C.A., Assistant Professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
CERTIFICATE This is to certify that we have examined the mini project report entitled “SOFTWARE
FOR
DTH
DISTRIBUTOR”
being
submitted
by
V.SHANMUGATHAI,(Reg No : 09PA15), final year student of Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi is a bonafide record of work carried out by him under my guidance. It is further certified that this project is of him own work and not part of the any other works or means. It is further certified that, to the best of my knowledge, this mini project report or any part thereof has not been submitted in this university or elsewhere for any other degree or diploma.
Place : Sivakasi,
Signature of the Internal Guide
Date :
( Miss S.SUNATHA, M.C.A.,)
3
CERTIFICATE This is to certify that we have examined the mini project report entitled “ SOFTWARE FOR DTH DISTRIBUTOR” being submitted by V.SHANMUGATHAI (Reg.No:09PA15), final year student of Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, is a bonafide
record
of
work
Miss S.SUNATHA, M.C.A.,
carried
out
by
him under
the guidance
of
Assistant Professor, Post Graduate Department of
Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, and have evaluated his performance at viva-voce conducted on
Internal Examiner
/
/ 2011.
External Examiner
4
V.SHANMUGATHAI, Reg.No:09PA15, III MCA, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
DECLARATION I declare that this mini project report entitled “SOFTWARE FOR DTH DISTRIBUTOR” has been submitted by me in the Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, and the contents have been presented in the form of project work. I further declare that this mini project report or any part thereof has not been submitted elsewhere for any other degree or diploma.
Place: Sivakasi,
(Signature of the Student)
Date:
V.SHANMUGATHAI
5
ACKNOWLEDGEMENT First of all, I thank Almighty for his unfailing grace which sustained me during the days of my project work. I express my deep gratitude towards the management for granting permission to do this mini project. I
express
my
sincere
gratitude
to
our
beloved
Principal
Dr. S. BASKARAN, M.Sc., Ph.D., Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi for granting permission to carry out this project work. I extend my heart full thanks to Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D., Director, Post Graduate department of Computer Applications for giving his encouragement and Co-operation during this project work. I am highly indebted to Miss S .SUNATHA, M.C.A., my internal guide and Assistant professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, d to Madurai Kamaraj University, Madurai, who poured over every inch of the script with painstaking attention to detail and made a semi infinite number of helpful suggestion. I convey my sincere thanks to my staff in our Department, for their guidance and encouragement during the entire project work. My gratitude is also extending to my friends for their constant encouragement during the entire project work. I also express my profound gratitude to my parents, who helped me a lot in completing this project work.
6
CONTENTS CHAPTER 1
TITLE
PAGE NO
INTRODUTION 1.1 Synopsis
2
2
SYSTEM ANALYSIS
3
4
5
6
2.1 Feasibility Study
4
2.2 Existing Study
5
2.3 Proposed System
6
SYSTEM DESIGN
8
3.1 Data Flow Diagram
23
3.2 Project Specification
28
3.3 Requirement Specification
29
3.4 About the Software
33
SYSTEM IMPLEMENTATION
34
4.1 Sample Screens
45
4.2 Testing
47
SYSTEM MAINTENANCE
48
5.1 Achievements
49
5.2 Future Enhancement
50
5.3 Maintenance Activities
51
CONCLUSION
52
APPENDIX BIBLIOGRAPHY A
54
7
SYNOPSIS
The science and technology has improved to a very great height. The world is going on a fast track. Time plays a prominent role in our day-to-day life. The project titled “SOFTWARE FOR DTH DISTRIBUTOR” has been exclusively developed for all direct DTH distributors. The main objectives of the system are to maintain all the master tables of Proof types, Box Models, Area Details and Dealer details. The system deals all the information very efficiently and accurately. This system gives the information about the Employee details. The system is useful for the effective utilization and gives related information to the organization people. It gives the report of various details and result for the distributors. The system reduces most of manual work.
8
2. SYSTEM ANALYSIS System study is the process of gathering and interpreting facts, diagnosing problems of the system. System study begins with the determination of the system requirements, which can be done by the study of an existing system. The next step is to determine what the proposed system is suppose to do. The final step is to determine the need for computerization, Hardware and Software configuration should be evaluated to determine the suitable platform for the system. 2.1 Feasibility Study As the feasibility study is very important for software development. The system will be feasible, only if it is feasible in all aspects. The feasibility study tries to find out answer for the following questions. Is the system is really needed? Is the resource management system can do something helpful to the employees and students? Is the system development project is achievable with the available money, time and manpower? The system proposed is tested whether it is feasible, by conducting the following feasibility study.
Operational feasibility
Technical feasibility
Economical feasibility
9
Operational Feasibility Once the system is developed completely, it must be put into use. A reasonable acceptance from the side is necessary for the success of the system. Since welcomes the expert systems, the system is found to be operationally feasible. Technical Feasibility The hardware and software requirements of the proposed system are already made available for use. If new technology is required, what is the likelihood that it can be developed? Thus the system is technically feasible. Financial Feasibility The existing system is enough for implementing the system and also for further software developments in of labour and manpower, it is adequate and no extra personal is required. 2.2 Existing System The existing system is considered as manual system. In manual system all entries, the transactions, calculations, report preparations, etc., are carried manually. Every end must have the knowledge about the transactions. While entering, the may commit some mistakes, which may leads to the drastic errors. Every transaction entered clearly. The manual errors may occur due to wrong calculations, transactions, report preparations, etc. So the reports prepared may contain some errors. Sometimes a rough work is needed. Which is a time consuming process.
10
Disadvantages of existing system Being a clerical procedure the existing system encounters the following problems: The entries are done manually. It may take more time when more entries
are been made.
In calculations, mistakes may occur.
Calculation are correct, but its entry may be wrong.
The cost for maintenance of the record and more over the employment
charges are alos higher.
Less security and less reliable.
2.3 Proposed System Most of the pitfalls are discovered in the existing system and they are thoroughly eliminated in the proposed system. The aim of proposed system is to computerize the activities like data entry, calculations, reports etc. By integrating the above functions into a single system we can maintain the entries, display, calculation, reports and modification of records very effectively and quickly. The main functions which are concentrated in this system are •
No record should be redundant.
•
No manual calculations required.
•
Records are maintained perfectly.
•
Reports are produced in a neat format.
11
•
Better security to the data.
The proposed system is developed using Visual Basic.Net 2005 as front-end, SQL Server 2000 as back-end. It is reliable, easy understandable and a -friendly software. A person with little bit of computer knowledge can operate this software. The software is designed in a similar way we do a manual entry. The major characteristics of the system are:
Capturing data through forms.
Avoiding data redundancy and thereby saving time trough reduction of
friendly and reliable.
errors.
12
SYSTEM DESIGN System design is the process of planning a new system or to replace components of an existing system. System design involves logical design and then physical design of the system. Logical Design It contains the specification for the new system. It describes the features, the outputs, and the inputs. Logical Data Flow Diagram This diagram is completed using only three symbols and notations: Data Flow Data moves in a specific direction from an object to a destination. Source
External source of data, which may be people, programmer, organization or other entities that interact with the system. Process
People, procedure or devices that use or produce data.
Data Store
13
DFD for Member Details
14
DFD for New Connection Booking
15
3.2 Program Specification
PROJECT PROFILE
ABOUT THE PROJECT The project titled “SOFTWARE FOR DTH DISTRIBUTOR” contains three modules. They are analyzed, designed and implemented. They are Master Transaction Report These modules are very easy to use by the . Each module has different types of parameters that are to be selected by the . Each module is developed for specific purpose. MASTER: This master menu contains the following module. •
Proof Types
•
Box Model
•
Area Details
•
Dealer Details
Proof Types: The Proof Types form contains information about Types of Proof. Each type of proof is given a unique proof id. The proof types may be Pan Card, Ration Card, Vote Card, Bank Book and like so on. In this module the system generates a Proof type id uniquely.
16
Box Model: The form maintains the information about the “Box Model” such as boxid, manufacture name and description. Unique BOXID is given for each type of box. Area Details: Here the distributor can maintain the details of the area. The Area Details maintains details about area id, area name and area details. Dealer Details: The Dealer form maintains detail about dealer id, dealer name, address, no, mobile no, area id and status.
TRANSACTION: The transaction module contains the following modules, •
New Booking
•
Employee Details
•
Member Details
New Booking: This module is used for enter the booking of new member in for sun direct DTH service. The form contains the information about new booking such as its id, name, address, city, booking date, booking status and dealer Id.
Employee Details: In this module we can enter the details of employee for sun direct DTH service. The form contains the information about employee details such as its id, name, designation, address, no and status.
17
Member Details: The Member form contains details about member id, name, address, no, Email id, proof type id, DOJ (Date of ing), smart card no, box no and status. Unique member id is given for each member.
REPORT The following reports are to be generated. Area Details Box Model Dealer Details Employee Details New Bookings Member Details Proof Details The report module is used to take neat printout or import that report into another file for future reference. The imported file stored as an html document.
18
3.3. SYSTEM REQUIREMENTS SPECIFICATION Hardware Requirements Processor
:
Intel 28400 2.66 GHz
RAM
:
1 GB DDR RAM
Hard Disk
:
250 GB
Driver
:
LG DVD Writer 22X
Monitor
:
Dell
Display Size
:
17” TFT Monitor
Resolution
:
1024x768
Keyboard
:
Logitech
Mouse
:
Logitech Optical
Operating System
:
Windows XP Professional
Front End
:
ASP.NET
Back End
:
Microsoft SQL Server 2000
Software Requirements
19
3.4 About the Software Introduction to Visual Studio .Net The Microsoft .NET frame work provides platform for the development of applications for both the desktop and the internet. The .NET framework allows us to develop internet applications with an ease that was never provided before. To develop Internet Applications, the .NET framework is equipped with ASP.NET. It is a powerful programming framework for the development of enterprise class Web applications. Visual Studio .NET is the first release of the products based on the .NET framework. It includes Visual Basic; Visual C++ and C#.VS.NET provides a common Integrated development environment for all languages. Therefore, developers always work in a consistent environment irrespective of the language they use. Microsoft introduced the .NET framework with a vision for developers to create globally distributed software with internet functionality and interoperability. The .NET framework includes multiple languages, class libraries, an a common execution platform. In addition, the .NET framework includes protocols that allow developers to integrate software over the internet and the .NET enterprise servers such as SQL Server 2000, Commerce Server 2000 and BizTalk Server. Thus the .NET framework provides the richest built-in functionality for software integration ever provided by any platform. Also with the .NET framework, developing the internet applications is as easy as developing desktop applications. 5.2 Introduction To SQL-Server IBM Invented a computer language back in the 1970’s designed specifically for database Queries called SEQUEL which stood for Structured English Query language. 20
Over time the language has been added to, So that it is not just a language for Queries but can also be used to build databases and manage security of the databases engine. IBM released SEQUEL in to public domain. Where it was known as SQL-SERVER SQL-SERVER is used to communicate with the relational database which is in turn a set of related information stored in the form of table. It is a non-procedural language because it processes set of records rather than just one data at a time and also provides automatic navigation of data.
Here one can
manipulate a set of rows than one at a time. It commands allow a set row as input and set of rows as output. It is also utilized as the communication language with the database among the database s at database . System s, security s and application programmers. It provides commands for a variety of tasks including 1. Querying data 2. Inserting, updating and deleting rows in an object 3. Creating, replacing, altering and dropping objects 4. Controlling access to the database and its objects guaranteeing database consistency and integrity The SQL language is subdivided according to their function as follows. 1. Data Definition Language (DDL). 2. Data Manipulation Language (DML). 3. Transaction Control Language (TCL).
21
SQL SERVER AND THE CLIENT/SERVER MODEL Microsoft’s SQL server is a Client/Server database engine, so it is important for you to understand the Client/Server model. A client/Server application can be defined as one that is split in to two parts: one part runs on a Server, and the other Part runs on Workstations. The server side of the application provides security, fault tolerance, performance, concurrency, and reliable backups. The client side provides the interface and can contain empty reports, Queries, and forms. The ideas is to have the best of both works by taking advantage of both and pairing them together. SQL server is the server part of the education; various clients to choose from can connect to SQL Server, including the Utilities that come with SQL server such as the SQL Server, such as the SQL server Query Analyzer. SQL server provides the following advantages for both clients and servers. Client advantages •
Easy to use
•
s multiple hardware platforms
•
s multiple software applications
•
Familiar to the
Server advantages •
Reliable
•
Concurrent
•
Sophisticated locking
•
Fault tolerant
22
•
High-Performance hardware
•
Centralized control
In Client/Server computing, when a Query is ran, the server searches the database and sends only the rows that are a match to the client. This not only saves bandwidth, but it can be faster than having the workstations perform the query. As the server is a powerful enough machine.
23
SYSTEM IMPLEMENTAION 4.1 Sample Screen Proof Tyoes
24
Box –Model Details
25
Area Details
26
Dealer Details
27
New Booking Details
28
Customer Details
29
Employee Details
30
Complaint Details
31
4.2 Software Testing Testing is an activity that ensures whether a correct system is built or not. It is carried out not only after the development phase is completed, but also is parallel with all stages of development. It is an important stage in System Development Life Cycle. The test case is a set of data that a system will process as normal input. As the philosophy behind testing is to find errors if exists and to check whether the system will process the data correctly. Software testing is an important element of software quality assurance and represents the ultimate review of specification, design and coding. The increasing visibility of software as a system element and the costs associated with a software failure are motivating forces for well planned thorough testing. Testing should not be done as a single phase; it should be integrated with all phases of the software development life cycle. Testing seems to be negative but it is the process, which brings out the creativity of the software professional. Test data or test case is to be designed before testing begins. Testing can be performed at different stages. Based on this testing is classified into various types. Unit Testing. Interface Testing. Black Box Testing. White Box Testing. Integration Testing. System Testing.
32
Unit Testing : Testing should be started as early as possible in the software development process. Unit testing involves testing individual modules or units for errors. As each unit is developed it is tested for errors by the test team which consists of not in the development team. The project leader just explains the requirements and functionality of the module and hands over the module to the testers. They validate the module against the requirements gathered.
Any errors found are reported to the project team for
correction. Interface Testing: After developing the system, it has to be tested by end because he is the person who is going to use the system, is called interface testing. The ultimate aim of the system is to design a completely friendly software so the found it to be easy. Black-Box Testing Black-Box tasting attempts to find error in the following categories. o Incorrect or missing functions o Interface errors o Errors in data structures or external data base access o Performance errors o Initialization and termination errors Using this method, the functional validity is tested, good test cases are found, they are verified.
The system sensitivity is checked for certain input values.
tolerance of data rates and data volume of the system is verified.
33
The
White-Box Testing: This is a test case design method that uses the control structure of the procedural design to derive test cases. Using it, the software engineer can derive test cases that, o All independent paths within a module have been checked. o Exercise all logical decision on their true and false sides o Exercise all loops at their boundaries and within operational bounds o Exercise internal data structures to assure their validity. Integration Testing: The need for the integrated test is to find the overall system performance. Once each module has been tested individually it has to be integrated into a single system. While testing the whole application we can expect many errors because there should be proper interaction between modules. So integrated testing has been performed successfully after uniting all modules. System Testing: System testing is designed to uncover errors that was not found in earlier tests. Here the entire system is validated from performance. This includes forced system failure, providing heavy workload to test the system performance in unexpected conditions. The total system is also tested for recovery and fallback after various major failures.
34
13. CONCLUSION The Project Entitled “SOFTWARE FOR DTH DISTRIBUTOR” used to maintain the customer, manufacture, category, product, sales and product details. There are more number of verification and validations done by this system. The system responds positively to the test done in this system. The System is a friendly one. The end need not have the full computer knowledge. The can handle the system very easily and the changes can be made very easily. The entire system was developed with full documentation within in the stipulated time period with minimum usage of available resources.
35
14. BIBLIOGRAPHY 1. Visual Basic .NET programming black book by Stephen Helzner. 2. Mastering Visual Basic .NET By Evangelos Petroutsos 3. Essential Skills VB.NET by Bop Rsselman. 4. Visual Basic .NET Database How – To Eric Wineemiuer.
Web Reference 1. http://www.functionx.com/vbnet/index.htm 2. http://msdn.microsoft.com/en-us/vbasic/bb466159.aspx
36
POST GRADUATE DEPARTMENT OF COMPUTER APPLICATIONS AYYA NADAR JANAKI AMMAL COLLEGE (AUTONOMOUS) SIVAKASI – 626124 NOVEMBER 2011
1
Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D.,
Director, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
CERTIFICATE This is to certify that this mini project entitled “SOFTWARE FOR DTH DISTRIBUTOR” being submitted by V.SHANMUGATHAI, (Reg.No:09PA15), final year student of Post Graduate Department of Computer Applications is a bonafide record of work carried out by him under the guidance of Miss S. SUNATHA, M.C.A., Assistant Professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi. It is further certified that this project is him own work and not part of any other works or means.
Place: Sivakasi, Date:
Signature of the Director, (Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D.,)
2
Miss S.SUNATHA, M.C.A., Assistant Professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
CERTIFICATE This is to certify that we have examined the mini project report entitled “SOFTWARE
FOR
DTH
DISTRIBUTOR”
being
submitted
by
V.SHANMUGATHAI,(Reg No : 09PA15), final year student of Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi is a bonafide record of work carried out by him under my guidance. It is further certified that this project is of him own work and not part of the any other works or means. It is further certified that, to the best of my knowledge, this mini project report or any part thereof has not been submitted in this university or elsewhere for any other degree or diploma.
Place : Sivakasi,
Signature of the Internal Guide
Date :
( Miss S.SUNATHA, M.C.A.,)
3
CERTIFICATE This is to certify that we have examined the mini project report entitled “ SOFTWARE FOR DTH DISTRIBUTOR” being submitted by V.SHANMUGATHAI (Reg.No:09PA15), final year student of Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, is a bonafide
record
of
work
Miss S.SUNATHA, M.C.A.,
carried
out
by
him under
the guidance
of
Assistant Professor, Post Graduate Department of
Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, and have evaluated his performance at viva-voce conducted on
Internal Examiner
/
/ 2011.
External Examiner
4
V.SHANMUGATHAI, Reg.No:09PA15, III MCA, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi.
DECLARATION I declare that this mini project report entitled “SOFTWARE FOR DTH DISTRIBUTOR” has been submitted by me in the Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, and the contents have been presented in the form of project work. I further declare that this mini project report or any part thereof has not been submitted elsewhere for any other degree or diploma.
Place: Sivakasi,
(Signature of the Student)
Date:
V.SHANMUGATHAI
5
ACKNOWLEDGEMENT First of all, I thank Almighty for his unfailing grace which sustained me during the days of my project work. I express my deep gratitude towards the management for granting permission to do this mini project. I
express
my
sincere
gratitude
to
our
beloved
Principal
Dr. S. BASKARAN, M.Sc., Ph.D., Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi for granting permission to carry out this project work. I extend my heart full thanks to Dr. R. LAWRANCE, M.Sc., M.Phil., Ph.D., Director, Post Graduate department of Computer Applications for giving his encouragement and Co-operation during this project work. I am highly indebted to Miss S .SUNATHA, M.C.A., my internal guide and Assistant professor, Post Graduate Department of Computer Applications, Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi, d to Madurai Kamaraj University, Madurai, who poured over every inch of the script with painstaking attention to detail and made a semi infinite number of helpful suggestion. I convey my sincere thanks to my staff in our Department, for their guidance and encouragement during the entire project work. My gratitude is also extending to my friends for their constant encouragement during the entire project work. I also express my profound gratitude to my parents, who helped me a lot in completing this project work.
6
CONTENTS CHAPTER 1
TITLE
PAGE NO
INTRODUTION 1.1 Synopsis
2
2
SYSTEM ANALYSIS
3
4
5
6
2.1 Feasibility Study
4
2.2 Existing Study
5
2.3 Proposed System
6
SYSTEM DESIGN
8
3.1 Data Flow Diagram
23
3.2 Project Specification
28
3.3 Requirement Specification
29
3.4 About the Software
33
SYSTEM IMPLEMENTATION
34
4.1 Sample Screens
45
4.2 Testing
47
SYSTEM MAINTENANCE
48
5.1 Achievements
49
5.2 Future Enhancement
50
5.3 Maintenance Activities
51
CONCLUSION
52
APPENDIX BIBLIOGRAPHY A
54
7
SYNOPSIS
The science and technology has improved to a very great height. The world is going on a fast track. Time plays a prominent role in our day-to-day life. The project titled “SOFTWARE FOR DTH DISTRIBUTOR” has been exclusively developed for all direct DTH distributors. The main objectives of the system are to maintain all the master tables of Proof types, Box Models, Area Details and Dealer details. The system deals all the information very efficiently and accurately. This system gives the information about the Employee details. The system is useful for the effective utilization and gives related information to the organization people. It gives the report of various details and result for the distributors. The system reduces most of manual work.
8
2. SYSTEM ANALYSIS System study is the process of gathering and interpreting facts, diagnosing problems of the system. System study begins with the determination of the system requirements, which can be done by the study of an existing system. The next step is to determine what the proposed system is suppose to do. The final step is to determine the need for computerization, Hardware and Software configuration should be evaluated to determine the suitable platform for the system. 2.1 Feasibility Study As the feasibility study is very important for software development. The system will be feasible, only if it is feasible in all aspects. The feasibility study tries to find out answer for the following questions. Is the system is really needed? Is the resource management system can do something helpful to the employees and students? Is the system development project is achievable with the available money, time and manpower? The system proposed is tested whether it is feasible, by conducting the following feasibility study.
Operational feasibility
Technical feasibility
Economical feasibility
9
Operational Feasibility Once the system is developed completely, it must be put into use. A reasonable acceptance from the side is necessary for the success of the system. Since welcomes the expert systems, the system is found to be operationally feasible. Technical Feasibility The hardware and software requirements of the proposed system are already made available for use. If new technology is required, what is the likelihood that it can be developed? Thus the system is technically feasible. Financial Feasibility The existing system is enough for implementing the system and also for further software developments in of labour and manpower, it is adequate and no extra personal is required. 2.2 Existing System The existing system is considered as manual system. In manual system all entries, the transactions, calculations, report preparations, etc., are carried manually. Every end must have the knowledge about the transactions. While entering, the may commit some mistakes, which may leads to the drastic errors. Every transaction entered clearly. The manual errors may occur due to wrong calculations, transactions, report preparations, etc. So the reports prepared may contain some errors. Sometimes a rough work is needed. Which is a time consuming process.
10
Disadvantages of existing system Being a clerical procedure the existing system encounters the following problems: The entries are done manually. It may take more time when more entries
are been made.
In calculations, mistakes may occur.
Calculation are correct, but its entry may be wrong.
The cost for maintenance of the record and more over the employment
charges are alos higher.
Less security and less reliable.
2.3 Proposed System Most of the pitfalls are discovered in the existing system and they are thoroughly eliminated in the proposed system. The aim of proposed system is to computerize the activities like data entry, calculations, reports etc. By integrating the above functions into a single system we can maintain the entries, display, calculation, reports and modification of records very effectively and quickly. The main functions which are concentrated in this system are •
No record should be redundant.
•
No manual calculations required.
•
Records are maintained perfectly.
•
Reports are produced in a neat format.
11
•
Better security to the data.
The proposed system is developed using Visual Basic.Net 2005 as front-end, SQL Server 2000 as back-end. It is reliable, easy understandable and a -friendly software. A person with little bit of computer knowledge can operate this software. The software is designed in a similar way we do a manual entry. The major characteristics of the system are:
Capturing data through forms.
Avoiding data redundancy and thereby saving time trough reduction of
friendly and reliable.
errors.
12
SYSTEM DESIGN System design is the process of planning a new system or to replace components of an existing system. System design involves logical design and then physical design of the system. Logical Design It contains the specification for the new system. It describes the features, the outputs, and the inputs. Logical Data Flow Diagram This diagram is completed using only three symbols and notations: Data Flow Data moves in a specific direction from an object to a destination. Source
External source of data, which may be people, programmer, organization or other entities that interact with the system. Process
People, procedure or devices that use or produce data.
Data Store
13
DFD for Member Details
14
DFD for New Connection Booking
15
3.2 Program Specification
PROJECT PROFILE
ABOUT THE PROJECT The project titled “SOFTWARE FOR DTH DISTRIBUTOR” contains three modules. They are analyzed, designed and implemented. They are Master Transaction Report These modules are very easy to use by the . Each module has different types of parameters that are to be selected by the . Each module is developed for specific purpose. MASTER: This master menu contains the following module. •
Proof Types
•
Box Model
•
Area Details
•
Dealer Details
Proof Types: The Proof Types form contains information about Types of Proof. Each type of proof is given a unique proof id. The proof types may be Pan Card, Ration Card, Vote Card, Bank Book and like so on. In this module the system generates a Proof type id uniquely.
16
Box Model: The form maintains the information about the “Box Model” such as boxid, manufacture name and description. Unique BOXID is given for each type of box. Area Details: Here the distributor can maintain the details of the area. The Area Details maintains details about area id, area name and area details. Dealer Details: The Dealer form maintains detail about dealer id, dealer name, address, no, mobile no, area id and status.
TRANSACTION: The transaction module contains the following modules, •
New Booking
•
Employee Details
•
Member Details
New Booking: This module is used for enter the booking of new member in for sun direct DTH service. The form contains the information about new booking such as its id, name, address, city, booking date, booking status and dealer Id.
Employee Details: In this module we can enter the details of employee for sun direct DTH service. The form contains the information about employee details such as its id, name, designation, address, no and status.
17
Member Details: The Member form contains details about member id, name, address, no, Email id, proof type id, DOJ (Date of ing), smart card no, box no and status. Unique member id is given for each member.
REPORT The following reports are to be generated. Area Details Box Model Dealer Details Employee Details New Bookings Member Details Proof Details The report module is used to take neat printout or import that report into another file for future reference. The imported file stored as an html document.
18
3.3. SYSTEM REQUIREMENTS SPECIFICATION Hardware Requirements Processor
:
Intel 28400 2.66 GHz
RAM
:
1 GB DDR RAM
Hard Disk
:
250 GB
Driver
:
LG DVD Writer 22X
Monitor
:
Dell
Display Size
:
17” TFT Monitor
Resolution
:
1024x768
Keyboard
:
Logitech
Mouse
:
Logitech Optical
Operating System
:
Windows XP Professional
Front End
:
ASP.NET
Back End
:
Microsoft SQL Server 2000
Software Requirements
19
3.4 About the Software Introduction to Visual Studio .Net The Microsoft .NET frame work provides platform for the development of applications for both the desktop and the internet. The .NET framework allows us to develop internet applications with an ease that was never provided before. To develop Internet Applications, the .NET framework is equipped with ASP.NET. It is a powerful programming framework for the development of enterprise class Web applications. Visual Studio .NET is the first release of the products based on the .NET framework. It includes Visual Basic; Visual C++ and C#.VS.NET provides a common Integrated development environment for all languages. Therefore, developers always work in a consistent environment irrespective of the language they use. Microsoft introduced the .NET framework with a vision for developers to create globally distributed software with internet functionality and interoperability. The .NET framework includes multiple languages, class libraries, an a common execution platform. In addition, the .NET framework includes protocols that allow developers to integrate software over the internet and the .NET enterprise servers such as SQL Server 2000, Commerce Server 2000 and BizTalk Server. Thus the .NET framework provides the richest built-in functionality for software integration ever provided by any platform. Also with the .NET framework, developing the internet applications is as easy as developing desktop applications. 5.2 Introduction To SQL-Server IBM Invented a computer language back in the 1970’s designed specifically for database Queries called SEQUEL which stood for Structured English Query language. 20
Over time the language has been added to, So that it is not just a language for Queries but can also be used to build databases and manage security of the databases engine. IBM released SEQUEL in to public domain. Where it was known as SQL-SERVER SQL-SERVER is used to communicate with the relational database which is in turn a set of related information stored in the form of table. It is a non-procedural language because it processes set of records rather than just one data at a time and also provides automatic navigation of data.
Here one can
manipulate a set of rows than one at a time. It commands allow a set row as input and set of rows as output. It is also utilized as the communication language with the database among the database s at database . System s, security s and application programmers. It provides commands for a variety of tasks including 1. Querying data 2. Inserting, updating and deleting rows in an object 3. Creating, replacing, altering and dropping objects 4. Controlling access to the database and its objects guaranteeing database consistency and integrity The SQL language is subdivided according to their function as follows. 1. Data Definition Language (DDL). 2. Data Manipulation Language (DML). 3. Transaction Control Language (TCL).
21
SQL SERVER AND THE CLIENT/SERVER MODEL Microsoft’s SQL server is a Client/Server database engine, so it is important for you to understand the Client/Server model. A client/Server application can be defined as one that is split in to two parts: one part runs on a Server, and the other Part runs on Workstations. The server side of the application provides security, fault tolerance, performance, concurrency, and reliable backups. The client side provides the interface and can contain empty reports, Queries, and forms. The ideas is to have the best of both works by taking advantage of both and pairing them together. SQL server is the server part of the education; various clients to choose from can connect to SQL Server, including the Utilities that come with SQL server such as the SQL Server, such as the SQL server Query Analyzer. SQL server provides the following advantages for both clients and servers. Client advantages •
Easy to use
•
s multiple hardware platforms
•
s multiple software applications
•
Familiar to the
Server advantages •
Reliable
•
Concurrent
•
Sophisticated locking
•
Fault tolerant
22
•
High-Performance hardware
•
Centralized control
In Client/Server computing, when a Query is ran, the server searches the database and sends only the rows that are a match to the client. This not only saves bandwidth, but it can be faster than having the workstations perform the query. As the server is a powerful enough machine.
23
SYSTEM IMPLEMENTAION 4.1 Sample Screen Proof Tyoes
24
Box –Model Details
25
Area Details
26
Dealer Details
27
New Booking Details
28
Customer Details
29
Employee Details
30
Complaint Details
31
4.2 Software Testing Testing is an activity that ensures whether a correct system is built or not. It is carried out not only after the development phase is completed, but also is parallel with all stages of development. It is an important stage in System Development Life Cycle. The test case is a set of data that a system will process as normal input. As the philosophy behind testing is to find errors if exists and to check whether the system will process the data correctly. Software testing is an important element of software quality assurance and represents the ultimate review of specification, design and coding. The increasing visibility of software as a system element and the costs associated with a software failure are motivating forces for well planned thorough testing. Testing should not be done as a single phase; it should be integrated with all phases of the software development life cycle. Testing seems to be negative but it is the process, which brings out the creativity of the software professional. Test data or test case is to be designed before testing begins. Testing can be performed at different stages. Based on this testing is classified into various types. Unit Testing. Interface Testing. Black Box Testing. White Box Testing. Integration Testing. System Testing.
32
Unit Testing : Testing should be started as early as possible in the software development process. Unit testing involves testing individual modules or units for errors. As each unit is developed it is tested for errors by the test team which consists of not in the development team. The project leader just explains the requirements and functionality of the module and hands over the module to the testers. They validate the module against the requirements gathered.
Any errors found are reported to the project team for
correction. Interface Testing: After developing the system, it has to be tested by end because he is the person who is going to use the system, is called interface testing. The ultimate aim of the system is to design a completely friendly software so the found it to be easy. Black-Box Testing Black-Box tasting attempts to find error in the following categories. o Incorrect or missing functions o Interface errors o Errors in data structures or external data base access o Performance errors o Initialization and termination errors Using this method, the functional validity is tested, good test cases are found, they are verified.
The system sensitivity is checked for certain input values.
tolerance of data rates and data volume of the system is verified.
33
The
White-Box Testing: This is a test case design method that uses the control structure of the procedural design to derive test cases. Using it, the software engineer can derive test cases that, o All independent paths within a module have been checked. o Exercise all logical decision on their true and false sides o Exercise all loops at their boundaries and within operational bounds o Exercise internal data structures to assure their validity. Integration Testing: The need for the integrated test is to find the overall system performance. Once each module has been tested individually it has to be integrated into a single system. While testing the whole application we can expect many errors because there should be proper interaction between modules. So integrated testing has been performed successfully after uniting all modules. System Testing: System testing is designed to uncover errors that was not found in earlier tests. Here the entire system is validated from performance. This includes forced system failure, providing heavy workload to test the system performance in unexpected conditions. The total system is also tested for recovery and fallback after various major failures.
34
13. CONCLUSION The Project Entitled “SOFTWARE FOR DTH DISTRIBUTOR” used to maintain the customer, manufacture, category, product, sales and product details. There are more number of verification and validations done by this system. The system responds positively to the test done in this system. The System is a friendly one. The end need not have the full computer knowledge. The can handle the system very easily and the changes can be made very easily. The entire system was developed with full documentation within in the stipulated time period with minimum usage of available resources.
35
14. BIBLIOGRAPHY 1. Visual Basic .NET programming black book by Stephen Helzner. 2. Mastering Visual Basic .NET By Evangelos Petroutsos 3. Essential Skills VB.NET by Bop Rsselman. 4. Visual Basic .NET Database How – To Eric Wineemiuer.
Web Reference 1. http://www.functionx.com/vbnet/index.htm 2. http://msdn.microsoft.com/en-us/vbasic/bb466159.aspx
36
Related Documents 543cg
Front Page Maths Project 6t1i3e
December 2019 128
Project Front Page 5y6x35
October 2019 220
Project Report Front Page l6t50
October 2019 187
Project Report-front Page 5w2x3o
November 2019 310
Chemistry Investigatory Project Front Page 6b3by
October 2019 820
November 2019 403