Rent A Car Db

1. Department ID Name Location 2. Employee Category ID Category Name Commission Allowed 3. Employee ID Department ID Employee Category ID First Name Last Name NIC Bate Of Birth Cell Phone 4. Address ID Street Address 1 Street Address 2 Address Type ID Phone 1 Phone 2 City State Country Acquire Date Release Date 5. Address Type ID Name 6. x Address Employee ID Address ID Employee ID Is Default 7. x Address Investor ID Address ID Investor ID Is Default

8. x Address Client ID Address ID Investor ID Is Default 9. Investor ID First Name Last Name NIC Bate Of Birth Cell Phone 10. Vehicle ID Vehicle Type ID Investor ID Rent Rates ID Registration Number Make (varchar) Brand Name Model Color Transmission (varchar) Capacity (varchar) Description 11. Vehicle Type ID Name Description 12. Rent Rates ID Rates per Hour Rates per Kilometer Given Discount 13. Client ID First Name Last Name NIC Bate Of Birth Cell Phone (varchar) Given Discount (int, null)

14. Rental ID Serial Number Client ID Vehicle ID Driver ID Check Out Date Time Check In Date Time Check Out Meter Reading (int) Check In meter Reading (int) Places Visited Description Given Special Discount (int) 15. Tool Type ID Name Description 16. Paid Tool ID Rental ID Driver ID Client ID Tool Type ID Amount Description 17. Commission 18. Commission Type 19. Income 20. Revenue 21. Expense 22. Regular Maintenance 23. Accidental Maintenance 24. Receivable