16-10-2012, 10:44 AM
I require SRS on Tollgate Management system.I need it badly.
16-10-2012, 10:44 AM
I require SRS on Tollgate Management system.I need it badly.
07-01-2014, 01:02 PM
TollGate Management System
TollGate Management .docx (Size: 1.7 MB / Downloads: 171) Introduction & Objective This project is developed for complete maintenance of a tollgate. Tollgates are setup by companies who take up the project of construction of road. Through tollgate they collect the amount spent while constructing the road from the vehicle, which pass through the tollgate. Firstly, this package contains the records of the national highways, which are undertaken for construction. This includes the details of the source and destination of the national highway and the number of tollgates. Secondly, this package contains the detail information about tollgate of each national highway the information that are included are roadid, tollgateid, source, destination of gate, in charge of gate, kilometers, amount spent during construction, interest and number of years of its validation. Thirdly, this package contains detail information of the vehicle passing through the gate. It also includes the fair to be colleted for each type of vehicle passing through each gate. The types of vehicle we have classified are car, bus, lgv (light goods vehicle), hgv (heavy goods vehicle). Database Design: A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and effectively. The organization of data in the database helps to treat data as an organizational resource and integrates it as a whole. A Database is designed to meet the overall goal of the project and to store the information into separate database table. The tables are similar to ordinary files. Each record is stored in one row of these tables. Each columns of the table represents one particular field of the record. The database is normalized. Data Integrity: Data integrity means storing all the data in single place and allows each application to access it. This approach results in more consistent when updated, being sufficient to achieve a new record status for all the applications, which access it. This leads to less data redundancy, data items need not be duplicated, reduction in the direct access storage requirements. Data Independence: Data independence is the insulation of application programs from changing aspects of physical data organization. This objective seeks to allow changes in the content and organization of physical data without reprogramming of applications and to allow modifications to application programs without reorganizing the physical data. The tables needed for each module and the specifications are signed. The specification of each and every column is given based on the details collected during record specification of each column was given based on the details collected during record inspection during system study. Normalization Normalization is a series of tests use against the data to eliminate redundancy and make sure the data is associated with the correct table or relationship. For this work force management all tables are in third normal form. When data passes the first test, it is considered to be in first normal form. When it passes the second test, it is in second normal form and so on. The History of SQL Server SQL Server, like many things related to SQL, is a story of diversity. At one time, both Sybase and Microsoft had virtually the same product. Today, the two products are growing increasingly divergent. In fact, Sybase now calls their implementation of the product Sybase Adaptive Server Enterprise. For purposes of simplicity, in this book we refer to both Microsoft and Sybase implementations as SQL Server. Today, major differences in the two implementations are largely a result of their most popular operating system and hardware platforms. Sybase Adaptive Server Enterprise is deployable on many operating systems, including Windows NT and stalwart Unix platforms. Adaptive Server has many features that leverage Very Large Database (VLDB) and multithreading capabilities. Sybase carries the Transact-SQL language uniformly throughout their product line. So, you're just as likely to see Transact-SQL programs on the powerful and mobile Sybase SQL Adaptive Server Anywhere (formerly known as SQL Anywhere) running on Windows 95 and Windows 98 computers. Going to the high end of the spectrum for online analytical processing (OLAP) and data warehouses, Sybase Adaptive Server IQ utilizes Transact-SQL for programmatic needs and, in fact, utilizes the same parser as Sybase Adaptive Server. Conversely, Microsoft has focused on ease of use and administration, as well as tightly integrating the product with other no-cost features like replication and alert forwarding. In any event, all of these database platforms provide their respective user groups with efficient and effective database management tools. Programming Concepts When you write a program in a third-generation language (3GL) and even most other fourth-generation languages (4GLs), you're looking at a whole other animal. While programs in third-generation and fourth-generation languages can be entirely self-contained, Transact-SQL programs in a sense are merely extensions of the database environment. To explain more fully, programming in Transact-SQL is a blend of several distinct, yet integrated, components. Let's say that you're about to begin developing a new application. You'll probably start out with a period of design and analysis in which you'll map out what the database will (probably) look like. You'll build your development database using declarative SQL statements or perhaps a visual data- modeling tool. You might later implement a set of complex business rules on your database tables through triggers coded in Transact-SQL. From there, you might create reports and business processing modules that support the user interface through stored procedures coded in Transact-SQL. The Relational Database Model These days, relational database management systems (RDBMSs) like SQL Server and Sybase are the primary engines of information systems everywhere--particularly distributed client/server computing systems. Though RDBMSs are now common enough to trip over, it wasn't always that way. Not too long ago, you would probably trip over hierarchical database systems or network database systems or COBOL (heck, that still happens). Here's a quick-and-dirty definition for a relational database: a system whose users view data as a collection of tables related to one another through common data values. Perhaps you are interested in more than a quick-and-dirty definition? Here goes. The whole basis for the relational model follows this train of thought: data is stored in tables, which are composed of rows and columns. Tables of independent data can be linked, or related, to one another if all have columns of data that represent the same data value, called keys.
07-04-2016, 09:36 AM
To get information about the topic “tollgate management system” full report ppt and related topic refer the links below https://seminarproject.net/Thread-srs-of...management https://seminarproject.net/Thread-tollga...t-download |
|