Download Airport Feedback App and more Summaries Database Management Systems (DBMS) in PDF only on Docsity!
AIRPORT FEEDBACK APP
A
Project Report submitted in partial fulfillment for the award of the Degree of Bachelor of Technology in Department of Computer Science and Engineering SUBMITTED TO: SUBMITTED BY: Dr. Nilam Choudhary Akshat Lakhera (19ESKCS023) Dept. of Computer Science & Engineering Abhishek Goyal (19ESKCS027)
Akshat Singhal (19ESKCS024)
Department Of Computer Science & Engineering Swami Keshvanand Institute Of Technology, M & G, Jaipur Rajasthan Technical Kota, Jaipur Session 2022-
Swami Keshvanand Institute of Technology, Management & Gramothan, Jaipur Department of Computer Science and Engineering CERTIFICATE This is to certify that ……… Mr. Akshat Singhal (19ESKCS024) ………, a student of B.Tech (Computer Science & Engineering) …..VII….. Semester has submitted his Project Report entitled “….. Airport Feedback App …..” under my guidance Mentor: Coordinator: Mahendra Beniwal Mr. Sumit Mathur Dept. of Computer Dept. of Computer Science & Engineering Science & Engineering
Swami Keshvanand Institute of Technology, Management & Gramothan, Jaipur Department of Computer Science and Engineering CERTIFICATE This is to certify that ……… Ms. Abhishek Goyal (19ESKCS027) ………, a student of B.Tech (Computer Science & Engineering) …..VII….. Semester has submitted his Project Report entitled “….. Airport Feedback App …..” under my guidance Mentor: Coordinator: Mahendra Beniwal Mr. Sumit Mathur Dept. of Computer Dept. of Computer Science & Engineering Science & Engineering
Swami Keshvanand Institute of Technology, Management & Gramothan, Jaipur Department of Computer Science and Engineering DECLARATION We hereby declare that the report of the project entitled “AIRPORT FEEDBACK APP” is a record of an original work done by us at Swami Keshvanand Institute of Technology, Management & Gramothan, Jaipur under the mentorship of Dr. Nilam Choudhary (Dept. of Computer Science & Engineering) and coordinator Mr. Sumit Kumar (Dept. of Computer Science & Engineering). This project report has been submitted as the proof of original work for the particular fulfillment of the requirements for the award of the degree Bachelor of Technology (B.Tech) in the Department of Computer Science. It has not been submitted anywhere else, under any other program to the best of our knowledge. Team Members: Signature: Abhishek Goyal (19ESKCS0) Akshat Lakhera (19ESKCS023) Akshat Singhal (19ESKCS024)
Acknowledgement A project of such vast coverage cannot be realized without help from numerous sources and people in the organization. We take this opportunity to express our gratitude to all those who have been helping us in making this project successful. We are highly indebted to our faculty mentor Dr. Nilam Choudhary. She has been a guide, motivator and source of inspiration for us to carry out the necessary proceedings for the project to be completely successful. We would also like to thank Mr. Sumit Mathur for his co-operation, encouragement, valuable suggestions and critical remarks that galvanized our efforts in the right direction. We would also like to convey our sincere thanks to Prof. Dr. Mukesh Kumar Gupta, HOD, Department of Computer Science and Engineering, for facilitating, motivating and supporting us during each phase of development of the project. Also, we pay our sincere gratitude to all the Faculty Members of Swami Keshvanand Institute of Technology, Management & Gramothan, Jaipur and all our Colleagues for their co-operation and support. Last but not least we would like to thank all those who have directly or indirectly helped and cooperated in accomplishing this project. . Team Members: Signature: Akshat Gadodia (19ESKCS021) Akshita Sharma (19ESKCS027)
TABLE OF CONTENTS
INDEX OF FIGURES
- Figure 1.1 Architecture Diagram of the Proposed System Methodology
- Figure 3.1 Use-Case Diagram
- Fig 3.2: Activity Diagram Representing Passenger Registration
- Fig 3.3: Activity Diagram Representing Passenger Feedback
- Fig 3.4: Activity Diagram Representing Admin Login
- Fig 3.5: Activity Diagram Representing Admin View Feedback
- Fig 3.6: Sequence Diagram Representing Passenger
- Fig 3.7: Sequence Diagram Representing Admin View Feedback
- Fig 3.8: Sequence Diagram Representing Admin Login
- Fig 3.9: Database Diagram
- Fig 3.10: Entity Relationship Diagram
- Fig 4.1: Waterfall Model with Feedback
- Fig 7.1: Passenger Login Screen
- Fig 7.2: Passenger Home Displaying Flight Details
- Fig 7.3: Feedback Page (Common for both Passenger & Admin)
- Fig 7.4: Passenger Rating Form
- Fig 7.5: Admin Login Page
- Fig 7.6: Lounge View Feedback Page
- Fig 7.7: Baggage View Feedback Page
- Fig 7.8: About Page
INDEX OF TABLES
- Table 2.1 Minimum Client Side Hardware Interface
- Table 2.2 Minimum Server Side Hardware Interface
- Table 2.3 Recommended Client Side Hardware Interface
- Table 2.4 Recommended Server Side Hardware Interface
- Table 2.5 Minimum Software Interfaces
- Table 2.6 Recommended Software Interfaces
- Table 4.1 Roles and Responsibilities
- Table 6.1 Test Case Summary
ABBREVIATIONS USED
- STLSD Switching Theory & Logic System Design
- MIS Management Information System
- DBMS Database Management System
- OS Operating System
- UML Unified Modeling Language
- XML Extensible Markup Language
- HTTP Hypertext Transfer Protocol
- JSON JavaScript Object Notation
- NPM Node Package Manager
- API Application Program Interface
- JSX JavaScript XML
Passengers Can submit their feedback according their preference. They can provide their experience based feedback after using airport provided services. Can see their flight details Administrative Check the feedbacks provided by the passengers System Analysis System analysis is the process of gathering and interpreting facts, diagnosing problems and using the information to recommend improvements on the system. System analysis is a problem solving activity that requires intensive communication between the system users and system developers. System analysis or study is an important phase of any system development process. The system is studied to the minutest detail and analyzed. The system analyst plays the role of an interrogator and dwells deep into the working of the present system. The system is viewed as a whole and the inputs to the system are identified. The outputs from the organization are traced through the various processing that the inputs phase through in the organization. A detailed study of these processes must be made by various techniques like Interviews, Questionnaires etc. The data collected by these sources must be scrutinized to arrive to a conclusion. The conclusion is an understanding of how the system functions. The designer now functions as a problem solver and tries to sort out the difficulties that the enterprise faces. The solutions are given as a proposal. The proposal is presented to the user for an endorsement by the user. The proposal is reviewed on user request and suitable changes are made. This loop ends as soon as the user is satisfied with the proposal. Analysis gathers the requirements for the system. This stage includes a detailed study of the business needs of the organization. Design focuses on high level design like, what programs are needed and how are they going to interact, low-level design (how the individual programs are going to work), interface design
(what are the interfaces going to look like) and data design (what data will be required). During these phases, the software's overall structure is defined. Analysis and Design are very crucial in the whole development cycle. Any glitch in the design phase could be very expensive to solve in the later stage of the software development. The logical system of the product is developed in this phase. 1.3 Introduction to Project The purpose of this document is to build an online system to take feedback regarding airport facilities which are provided at the airport. The project is based on an android app using which the airport authority can manage the database and passengers can access for their belonging. This project is a prototype for the Inventory management system for taking feedback at the airport and it is restricted within the college premises. This has been implemented under the guidance of college professors. This project is useful for the airport authority and as well as to the passengers. The purpose of the Inventory management system for taking feedback at the airport is to create a convenient and easy-to-use application for passengers. The system is based on a relational database. Above all, we hope to provide a comfortable user experience. This project is a prototype for the Inventory management system for taking feedback at the airport and it is restricted within the college premises. This has been implemented under the guidance of college professors. This project is useful for the airport authority and as well as to the passengers. 1.4 Proposed Solutions Proposed System
- The proposed system is intranet based system so passengers can also participate in viewing their belongings.
- The proposed provides detail general information about the passengers along with their
SYSTEM REQUIREMENTS
SPECIFICATIONS
2.1 Overall Description
This section and its subsections contain the description of the project components such as interfaces, performance requirements, design constraints, assumptions and dependencies etc. 2.1.1 Product Perspective The application will be a web application.
2.1.1.1 System Interfaces
List each system interface and identify the functionality of the system (hardware and software both) to accomplish the system requirement and interface description to match the system.
2.1.1.2 User Interfaces
The application will have a user friendly and menu based interface. Following screens will be provided: An inventory management database system stores the following information. User details: The database consists of the username, password, contact, gender, email id. These details provide valid login to user after getting registered. Admin details: The DB consists of the username, password, contact, gender, email id, address. These details provide valid login to an admin of a particular airport after getting registered.
2.1.1.3 Hardware Interfaces
Screen resolution of at least 800 x 600 pixels is required for proper and complete viewing of screens. Higher resolutions in wide-screen mode will be better for a better view. Support for printer is required. This implies that appropriate drivers should be installed and printer device should be connected for printing of reports and mark sheets. A network connection (internet / intranet) is required to make the web service accessible on other systems connected over the network. Other hardware interface specifications are as follows Minimum Requirements: Client Side Processor RAM Disk Space Google Chrome Intel Pentium III or AMD - 800 MHz
128 MB 100 MB
Table 2.1 Minimum Client Side Hardware Interface Server Side Processor RAM Disk Space Node.js Intel Pentium III or AMD - 800 MHz
1 GB 3.5 GB
MongoDB Intel Pentium III or AMD - 800 MHz
256 MB
500 MB
(Excluding Data Size) Table 2.2 Minimum Server Side Hardware Interface
Minimum Requirements: Software Tool Version Purpose of Use Operating System Windows 7 and higher or Linux with kernel 3.x and higher Installation and operational platform Web Browser Google Chrome, Brave and other higher compatible Access to the web application Web Server Node Server Running the web application over intranet Database MongoDB Running and linking the database over internet/intranet to the online web application Table 2.5 Minimum Software Interface Recommended Requirements: Software Tool Version Purpose of Use Operating System Windows 8 and higher or Linux with kernel 3.x and higher Installation and operational platform Web Browser Google Chrome, Brave and other higher compatible Access to the web application Web Server Node Server Running the web application over intranet Database MongoDB Running and linking the database over internet/intranet to the online web application Table 2.6 Recommended Software Interface
2.1.1.5 Communication Interfaces
Passenger on Internet will be using HTTP/HTTPS protocol. Client (Administrator) on Internet will be using HTTP/HTTPS protocol.
2.1.1.6 Memory Constraints
At least 256 MB of RAM and 2 GB of space on hard disk will be required for running the application on client end. Similarly, a minimum of 2048 MB of RAM and 20 GB of space on hard disk will be required for running the application on server end.
2.1.1.7 Operations
The DBA at the client side will be assumed responsible for manually deleting or archiving obsolete or non-required data from the database as per clients requirements. This will include database backup and recovery options also. The Node webserver will be hosted and maintained on a remote server addressed by a URL based address. The URL address may be intranet or internet based as per clients requirements. The 'SYSTEM RESET' function is provided that after confirmation from the administrator, will delete all the selective or complete data from the system.
2.1.1.8 Site Adaption Requirements
The computing terminals connected to network (internet / intranet) at the client end will be required to support the hardware and software interfaces specified in above sections. 2.1.2 Project Functions The system will allow access only to authorized users with specific roles (Passengers, Administrator etc.). Depending upon the user's role, he / she will be able to access only specific modules of the system. A summary of the major functions that the software will perform: a) A Login facility for enabling only authorized access to the system. b) Passenger can view their flight details and can give feedbacks. c) Admin can view feedbacks summary and feedback messages.
