Uncle Guru Cabs Pvt.Ltd.

RIDE AND REQUEST TO BE CREATED!!!!

• mysql-connector-java-8.0.18.jar

1. Abstarct User Class 

• Public Customer Class -> User Class 
  • Wallet Class - For Customer Class 
    • InadequateWalletBalanceException 
  • BankAccount Class - For Customer Class 
    • InadequateBankBalanceException 
    • InvalidPINException 
• Public Driver Class -> User Class 

• Abstarct Location Class 
• Public CustomerLocation Class -> User Class 
• Public DriverLocation Class -> User Class 
• Random Location Generator Class 

• DatabaseConnection Class 
• Required Databases 
  • Places Location - Pk, Place Name, X coordinate, Y coordinate 
    • (100, 380) - BPHC 
    • (154, 323) - Alankritha 
    • (421, 206) - Paradise 
    • (457, 89) - Airport 
    • (266, 141) - Barbeque Nation 
    • (266, 200) - INOX GVK One 
    • (80, 80) - Secunderabad Station 
    • (400, 400) - Hussain Sagar 
  • BankAccount - Pk, Balance, Pin 
  • Cab - Pk, Cab Number, Cab Type, Cab Charge 
  • Customer - Pk, Username, UniqueId EmailID, PhoneNumber, Password, walletBalance, Pk(BankAccount) 
  • Driver - Pk, Username, UniqueId, EmailID, PhoneNumber, Password, walletBalance, Pk(Cab) 
  • Request - Pk, TimeStamp, Customer, Source[Pk(Places Location)], Time(Sorted), Destination[Pk(Places Location)], Satsfied 
    • Synchronized - Driver is Shared Resource 
  • Ride - Pk, Customer, Driver, Source[Pk(Places Location)], Destination[Pk(Places Location)], Duration 

• Utilities Class 
  • Random Wallet and Bank Balance Generators 

• HashMap for the storing locations with the coordinates 
• Random Location allocation for Customer 
• Random Location allocation for Drivers 
• Random Reallocation of Driver Locations 
• Database Tables for Customer, Driver, Location, Wallet, Ride, Bank Acc, Cab 

• pin : BankAccount - 4 digit number 
• rating : Driver - b/w 0 and 5 
• cabNumber : Cab - Vehicle Number Regex, Unique 
• In general - make constructor accept objects 

• Multiple logins

new String[] { "BPHC", "Alankritha Resort", "Barbeque Nation", "Inox GVK One", "Paradise Hotel", "Secunderabad Station", "Rajiv Gandhi International Airport" })