Content:
In order to facilitate users to rent a car as and when required we would like to design a car rental
system. It is more feasible than owning a car and maintaining it. Car rental system serves people
who don't own a car, who are out of town or owners of damaged cars who are awaiting repair or
insurance compensation.
Scope:
- Providing car catalog to the Users so that they can choose the best option based on their concern.
- Admin can manage the catalog by adding or removing the cars based on their availability and allows only authorized Users (Driver License) to rent a vehicle
- Admin must make sure that the rented cars must have valid insurance.
- Admin must allow user to provide feedback at the end of every ride.
Objective: - To reduce the effort of booking a car in a conventional procedure.
- To ease the search process of a customer who is in need of a car.
- To provide services to the customers in order to achieve the best customer satisfaction.
Project Environment
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of
MySQL over the Web. Frequently used operations of phpMyAdmin include managing databases,
tables, columns, relations, indexes, users, permissions etc. which can be performed via the user
interface, while having the ability to directly execute any SQL statement.
phpMyAdmin Version information: 4.0.10deb1. Database Server details are as follows:
● Server: 127.0.0.1 via TCP/IP
● Server type: MySQL
● Server version: 5.5.57-0ubuntu0.14.04.1 - (Ubuntu)
● Protocol version: 10
● Database client version: libmysql - mysqlnd 5.0.11-dev
Involved project environment setup and gathering high level requirements such as initial user roles, user stories and high level conceptual design, deciding the entities and their relationship.
Refining stories created in sprint 0 and adding new stories to be considered for the sprint. Based on it creating conceptual design and logical design and writing SQL queries relevant to sprint 1.
Apart from adding new stories relevant to sprint 2, creating views, stored programs - stored procedures and stored functions, triggers and events for Car Rental System.
Adding new user stories relevant to sprint 3, normalization and indexes creation.