Draw the ERD of the database that could be used to support the operations of the business described in the case Business Case: Bike with Us • Bike with Us is a bicycle rental company which has several offices in different neighborhoods of Montreal. Each office is identified by a Station_Code and its geographical location (i.e., latitude and longitude). • Each office is assigned one or more employees for different tasks. Attributes of employees include Employee_ID and Employee_Name. An employee must be assigned to only one rental office. • For each office, there is always one employee assigned to check bicycle conditions. • The office rents several classes of bicycles: road, mountain, electric bike, touring, folding, fixed gear. Each bicycle is managed by one office. Customers might rent bicycles from different offices in the city. • Bicycles are to be described by data such as: make, year of production, uses (purpose), size, registry number, purchase price, purchase date, rent price and insurance details. • There are two types of customers: privileged and casual. For the privileged category of customers special credit card facilities are provided. These customers may also book in advance (reservation) a particular bicycle. Information stored for each booking (reservation) includes customer, bike, estimated amount, date and time of rental and date and time on which the bike is to be returned. If a bike is available, the customer's details are recorded (if not stored already) and a new booking is made. These reservations can be made for any period of time up to one month. • Bookings can be cancelled if the office is informed at least 24 hrs before the booking date/time. • Casual customers cannot book in advance and must pay a deposit for an estimated time of rental at the time they rent the bike unless they wish to pay by credit card. All major credit cards are accepted. • For each rental (for either privileged or casual), the office keeps track of the date it was rented, the date the vehicle is returned, bike type, customer and the rental total charged amount. • Personal details (such as name, address, telephone number) about each customer are kept in the database. • A customer (either privileged or casual) cannot rent a bike for longer than four weeks. • Bikes need to be maintained and repaired and the database is required to keep track of this. All major repairs and maintenance are done by subcontractors, with whom the rental office has long-term agreements. Therefore, the data about subcontractors to be kept in the database includes subcontractor names, addresses, range of services, etc. Some subcontractors require payments immediately after
Draw the ERD of the
Business Case: Bike with Us
• Bike with Us is a bicycle rental company which has several offices in different neighborhoods of Montreal. Each office is identified by a Station_Code and its geographical location (i.e., latitude and longitude).
• Each office is assigned one or more employees for different tasks. Attributes of employees include Employee_ID and Employee_Name. An employee must be assigned to only one rental office.
• For each office, there is always one employee assigned to check bicycle conditions.
• The office rents several classes of bicycles: road, mountain, electric bike, touring, folding, fixed gear. Each bicycle is managed by one office. Customers might rent bicycles from different offices in the city.
• Bicycles are to be described by data such as: make, year of production, uses (purpose), size, registry number, purchase price, purchase date, rent price and insurance details.
• There are two types of customers: privileged and casual. For the privileged category of customers special credit card facilities are provided. These customers may also book in advance (reservation) a particular bicycle. Information stored for each booking (reservation) includes customer, bike, estimated amount, date and time of rental and date and time on which the bike is to be returned. If a bike is available, the customer's details are recorded (if not stored already) and a new booking is made. These reservations can be made for any period of time up to one month.
• Bookings can be cancelled if the office is informed at least 24 hrs before the booking date/time.
• Casual customers cannot book in advance and must pay a deposit for an estimated time of rental at the time they rent the bike unless they wish to pay by credit card. All major credit cards are accepted.
• For each rental (for either privileged or casual), the office keeps track of the date it was rented, the date the vehicle is returned, bike type, customer and the rental total charged amount.
• Personal details (such as name, address, telephone number) about each customer are kept in the database.
• A customer (either privileged or casual) cannot rent a bike for longer than four weeks.
• Bikes need to be maintained and repaired and the database is required to keep track of this. All major repairs and maintenance are done by subcontractors, with whom the rental office has long-term agreements. Therefore, the data about subcontractors to be kept in the database includes subcontractor names, addresses, range of services, etc. Some subcontractors require payments immediately after
Step by step
Solved in 4 steps
