mini project report_20241205_132106_0000
mini project report_20241205_132106_0000
mini project report_20241205_132106_0000
4.2 MODULES
. Vehicle registration comprehensive management of vehicle details including entries ,exits and user
details category management for different types of vehicles parking slots allocation
. Updation of slot availability can manage payments for parking slots allocated to users and can set extra
fees according to the duration of the vehicle parked can make remarks
Input design is the link that ties the information system into the world of its users. The input design
involves determining what the input is, how the data should be performed, how to validate data, how to
minimize data entry and how to provide a multi user facility, inaccurate input data are the most
common cause of errors in data processing. Errors entered by data entry operator can be controlled by
input design. Input design is the process of converting user originated input to a computer-based
format. Input data are collected and organized into groups of similar data. Once identified, appropriate
input media are selected for processing All the input data re validated in the order and if any data
violates any conditions, the user is warned by a message. If the data satisfies all the conditions, then it is
transferred to the appropriate table in the database. A form is designed to enter the details should be
user friendlier so that authorized user with even less knowledge can enter the data. The form is designed
using v b tools like command boxes, text boxes, labels, option buttons, combo boxes etc.
Output design is very important concept in the computerized system, without reliable output the user
may feel the entire system unnecessary and avoids using it. The proper output design is important in
any system and facilitates effective decision making. The output design of this system includes
various reports. output requirements are designed during system analysis. An application is
successful only when it can provide efficient and effective reports.
The goal of the output design is to capture the output and get the data into a format suitable for the
computer. It is very helpful to produce the clear, accurate and speedy information for end users.
A major form of the output is the harder copy from the pointer and screen reports. Printouts are
designed around the output requirements of the user. Allowing the user to view the sample screen is
important because the user is the ultimate judge of the quality of output. Output of this project is
provided in the form of reports created using crystal report tool.
4.5 DATABASE DESIGN
The fundamental purpose of a database is to provide a structured and efficient means of organizing,
storing, and retrieving data. By treating data as a valuable organizational resource, the development of
database technology has evolved to ensure seamless integration and cohesiveness within the information
ecosystem. A Database Management System (DBMS) plays a crucial role in achieving this objective,
allowing for the secure and organized storage of data independently from other resources. The distinction
between logical and physical data is a key aspect of this approach, where logical data represents the
conceptual organization and relationships, while physical data pertains to the actual storage and retrieval
mechanisms.
Moreover, the overarching goal of the database technology is to facilitate easy, quick, cost-effective, and
flexible access to information for users. This is achieved through the implementation of a well-designed
database system that emphasizes integration, data integrity, and independence. The separation of
logical and physical storage further enhances the adaptability and scalability of the system. In practice,
databases are commonly implemented through specialized software packages known as Database
Management Systems (DBMS), which provide a structured environment for creating, managing, and
manipulating databases. This systematic approach ensures that the database aligns with organizational
objectives, optimizes data management, and serves as a reliable foundation for various applications and
information retrieval needs.
Process design represents the structure of data and program components that are required to build a
computer-based system. It considered the architectural style that the system will take, the structure and
properties of the components constitute the system, and the interrelationships that occur among all
architectural components of a system. Although a software engineer can design both and architecture,
the job is often allocated to specialist when large, complex system are to be built. A database or data
warehouse designer creates data architecture for a system. The 'system architect 'select an appropriate
architectural style for the requirements derived during system engineering and software requirement
analysis. Architectural design begins with data design and proceeds to the derivation of one or more
representations of the architectural structure of the system. An architecture model encompassing data
architecture and program structure is created during architectural design. In addition, component
properties and the process by which it is developed. It refers to technical specifications that will be applied
in implementing the system. It includes the construction of program and program testing. The input to
design phase is software requirement specification DFD's, E-R diagrams and structured diagrams
depending on analysis. The output will be design specification. System design involves designing from
layouts for input and reports for output.
Database design is the logical form of design of data storage in the form of records in a particular
structure in the form of tables with fields which is not transparent to the normal user but it actually acts
as the backbone of the system. As we know database is a collection of data, which helps the system to
manage and store data called database management system. Data base management system builds some
form of constraints like integrity constraints, i.e., the primary key/ unique key and referential integrity
which help to keep data structure storage and access of data from tables efficiently and accurately and
take necessary steps to concurrent access of data and avoid redundancy of data in tables by normalization
criterions.
Normalization is the method of breaking down complex table structures into simple table structures
by using certain rules thus reduce redundancy and inconsistency and disk space usage and thus increase
the performance of the system or application which is directly linked to the database design and also
solve the problems of anomalies. The Data Base design of new system's is in second normal form and
the second normal form defines that all non-key fields of the table are fully dependent on the whole key.
Each field of the tables is made to depend only on key attributes and dependency on non-key fields is
eliminated. The organized data into column called fields and rows called reports. There are several
different tables are used in this project. These are,
1. Admin
2. Dealer
3. User
4. Vehicle
5. Vehicle category
6. Slots