Linc Cars and Rental Services - Rewards for Miles
Autor: Kanika Sharma • November 21, 2015 • Study Guide • 530 Words (3 Pages) • 894 Views
Rewards for Miles
Name: Kanika Sharma
Problem Owner: Linc Cars and Rental Services.
Problem Statement: Linc Cars and Rental Services is a small organization with around 1000 customers. The company uses Microsoft Excel to keep the customers’ data. To increase their sales they are offering their customers a loyalty program and they call it Rewards for Miles. For each miles that customer pays for, he/she will get some points. If a customer has 1000 points he/she gets some reward. The excel sheet for customer details is stored in a shared location so that all the team members can use it.
After adding the functionality the company will have to keep a track of extra data for each customer. Also they will have keep the data secured, meaning not everybody in the team can have access to this data. Keeping a track of versions of excel files will also be a problem if more than one team members are working on maintaining the data.
Solution: The Company can overcome problems of concurrent users, version control and unauthorized access if they start using Database.
Business Need: Rewards for Miles is a software which will help company keep a track of individual customer’s details along with calculating the reward points for each customer. The team member needs to be an authorized user to add, edit or delete for the data security. More than one team member at a time can add new data in the database. PHP will be used to design the user interface and front end activities. SQL server can be used to store the data at the back end.
Business Requirement: User interface helps adding customer detail with ease. The authorization of a team member to use, edit or delete data will preserve the data integrity. Team member can concurrently add new data in the database. With database it becomes easy to retrieve data and analyze it.
...