Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Case: Please use the following case to answer 01 and 02 in this assignment: Rapidity is a scooter rental company who offers rental scooters to

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
Case: Please use the following case to answer 01 and 02 in this assignment: 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 userslcustomers (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: members' rental requests and one-time rental (i.e., unregistered users) requests. members 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. 0 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. HINT: Many-to-many relationships must be split into two one-to-many relationships. b. Create the data dictionary for your database (10 marks). To do this, you can use the template given with this assignment (datadictionary Template.xIs)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Real Analysis

Authors: Robert G. Bartle, Donald R. Sherbert

4th edition

471433314, 978-1118135853, 1118135857, 978-1118135860, 1118135865, 978-0471433316

Students also viewed these General Management questions