Business Case: Bike with Us Bike with Us is a bicycle rental company which has several...

  

Transcribed Image Text:

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. 3 I 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 a repair has been made; with others the rental office has made arrangements for credit facilities. 1- Using the business case included in this assignment, complete the following requirements: a. Draw the ERD of the database that could be used to support the operations of the business described in the case (10 marks). The ERD should identify: • Primary keys and Foreign keys; • Entities and at least three Attributes for each entity: • Relationships and Cardinalities (e.g., one-to-one, one-to-many). Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions. 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. 3 I 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 a repair has been made; with others the rental office has made arrangements for credit facilities. 1- Using the business case included in this assignment, complete the following requirements: a. Draw the ERD of the database that could be used to support the operations of the business described in the case (10 marks). The ERD should identify: • Primary keys and Foreign keys; • Entities and at least three Attributes for each entity: • Relationships and Cardinalities (e.g., one-to-one, one-to-many). Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions.

Answer rating: 100% (QA)

O Take name and company Product info How can help o... View the full answer