Read the following scenario and answer the questions given bellow. • A car rental company has its offices in three major cites of the area. A costumer once registered with the company, can avail its services from any nearby office. Every office keeps record of the vehicles, their drivers and renting details. Salaries of administrative staff are controlled at a single site while the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for the company.
Read the following scenario and answer the questions given bellow.
• A car rental company has its offices in three major cites of the area. A
costumer once registered with the company, can avail its services from any
nearby office. Every office keeps record of the vehicles, their drivers and
renting details. Salaries of administrative staff are controlled at a single site
while the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered.
1. Identify the entities involved in the
company.
2. Draw GCS for the system.
3. Give details of any of the relations replicated on more than one sites
Step by step
Solved in 4 steps