Scribd
Upload
92 views3 pages

Car Rental System Overview and Data

The document outlines the details of a car rental system including information about cars, branches, employees, clients, rentals, and bookings. It includes fields like car numbers, models, license plates, branch addresses and phone numbers, employee names and salaries, client names, license details, rental start and end dates, and booking numbers linking clients, branches, employees and cars. The purpose is to store and track information related to managing a car rental business.

Uploaded by

john john faustino
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
92 views3 pages

Car Rental System Overview and Data

The document outlines the details of a car rental system including information about cars, branches, employees, clients, rentals, and bookings. It includes fields like car numbers, models, license plates, branch addresses and phone numbers, employee names and salaries, client names, license details, rental start and end dates, and booking numbers linking clients, branches, employees and cars. The purpose is to store and track information related to managing a car rental business.

Uploaded by

john john faustino
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Andallo, John Maynard

BSIT 2C

CAR RENTAL SYSTEM


CAR BRANCH EMPLOYEE CLIENT RENT
Car number Branch Number SSS number Name Start Date
License Plate Branch Address Name SSS number End Date
License Province Branch Phone Address Address Rate
Model Branch Fax Phone Phone
Mileage Salary Driver’s License
number
Serial Num License Province
Make

CAR:

Car Number Model Make Mileage Serial Number License Plate License
Province
01 Vios Toyota 20345 84JD9W03NN GEL 1234 NCR
02 Civic Type-R Honda 18366 RNWN03452N AA 4567 REGION 1
03 Crosswind Isuzu 10896 50NFK034N22 BAP 7891 CAR

BRANCH:

Branch Number Branch Address Branch Phone Branch Fax


011 Bantay, Ilocos Sur 0955-666-7777 661-241-6005
022 Batac Ilocos Norte 0944-777-8888 772-341-7005
033 San Fernando, La Union 0933-222-1111 883-741-8005
EMPLOYEE:

Employee Name Address Salary Phone SSS number


Elvis Brgy. Amianance Vigan 65000 099-789-4651 132464897
City, Ilocos Sur
Tony Santa Catalina Ilocos 60000 0977-456-7822 009606516
Sur
Sid Mabalacat, Pampanga 50000 0356-321-5689 036810320

CLIENT:

Name Address Phone Driver’s License License Province SSS number


Bong Bong Manila 0911-123-4567 A05-5589 NCR 031677591
Isko Moreno La Union 0922-321-6549 A02-36451 REGION 1 124219765
Lenlen Ilocos Sur 0933-345-7841 A04-98741 CAR 012730491

RENT:

Rent Start Date Rent End Date Rent Rate


03/08/2022 04/11/2022 3%
04/11/2022 05/12/2022 2%
05/12/2022 05/25/2022 2%

BOOKING:
BOOKING CLIENT BRANCH EMPLOYEE CAR NUMBER RENT DATE
NUMBER NAME NAME
001 Bong Bong 011 Elvis 01 03/10/2022
002 Isko Moreno 022 Tony 02 04/29/2022
003 Lenlen 033 Sid 03 05/22/2022

You might also like