Rapidity is a scooter rental company who offers rental scooters to its customers in Toronto. They...

  

Transcribed Image Text:

• Rapidity is a scooter rental company who offers rental scooters to its customers in Toronto. They have several scooters rental offices where scooters can be parked and found in these stations. ● ● ● ● ● ● ● Each scooter is identifiable with their brand, registry number, 5digit-ID (format: AA111), date of purchase, and date of production. Each rental office is described by its geographical location (i.e., the street name, longitude, and latitude), and a unique 4-digit ID (format: 1111). To handle the operations, different departments are involved in this process, such as accounting, operation and scooter management. In each department there could be no employees (automated) to 10 employees. If there are not any scooters in the rental office, or there are damaged scooters in the rental office, the scooter management department will replace scooters and repair the damaged ones. There are two types of users/customers (unregistered, and registered users) and only registered users can request a scooter. Registered users should provide their personal information and their payment information. There are two types of rental requests: registered users' rental requests and one-time rental (i.e., unregistered users) requests. Registered users can take a scooter for free, limited to 40 minutes, and for more than 40 minutes, they should pay an extra fee of 2$ per hour. For one-time rental requests (i.e., unregistered users), initially, they should pay 80$ as a deposit and their hourly rate begins from the moment of usage which is 2$ per hour. After returning the scooter, the deposit will be returned to them. O For membership request, users must buy a monthly membership for 38 dollars. . They can also buy a family membership (membership for up to 4 people) for 90 dollars. No customer can use a scooter for more than 90 hours in one rental request. For each usage, the rental office keeps track of the date of request, the date the scooter is returned, scooter information, customer information (e.g., name, address, telephone number), and the rental total charged amount. a. Draw the ERD of the database that could be used to support the operations of the business described in the case (20 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 above case does not provide the information necessary to know which design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions. HINT: Many-to-many relationships must be split into two one-to-many relationships • Rapidity is a scooter rental company who offers rental scooters to its customers in Toronto. They have several scooters rental offices where scooters can be parked and found in these stations. ● ● ● ● ● ● ● Each scooter is identifiable with their brand, registry number, 5digit-ID (format: AA111), date of purchase, and date of production. Each rental office is described by its geographical location (i.e., the street name, longitude, and latitude), and a unique 4-digit ID (format: 1111). To handle the operations, different departments are involved in this process, such as accounting, operation and scooter management. In each department there could be no employees (automated) to 10 employees. If there are not any scooters in the rental office, or there are damaged scooters in the rental office, the scooter management department will replace scooters and repair the damaged ones. There are two types of users/customers (unregistered, and registered users) and only registered users can request a scooter. Registered users should provide their personal information and their payment information. There are two types of rental requests: registered users' rental requests and one-time rental (i.e., unregistered users) requests. Registered users can take a scooter for free, limited to 40 minutes, and for more than 40 minutes, they should pay an extra fee of 2$ per hour. For one-time rental requests (i.e., unregistered users), initially, they should pay 80$ as a deposit and their hourly rate begins from the moment of usage which is 2$ per hour. After returning the scooter, the deposit will be returned to them. O For membership request, users must buy a monthly membership for 38 dollars. . They can also buy a family membership (membership for up to 4 people) for 90 dollars. No customer can use a scooter for more than 90 hours in one rental request. For each usage, the rental office keeps track of the date of request, the date the scooter is returned, scooter information, customer information (e.g., name, address, telephone number), and the rental total charged amount. a. Draw the ERD of the database that could be used to support the operations of the business described in the case (20 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 above case does not provide the information necessary to know which design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions. HINT: Many-to-many relationships must be split into two one-to-many relationships