Question

Business Case: Go Bike Go bike is a sharing bike platform with several identified by their longitude, latitude, and a unique 6-digit ID (format: A1A1A). bike parking stations • There are different departments that are responsible for (e.g., maintenance, finance, and operation), and one or more employees are working in each department. An employee must be assigned to only one department. • are to be described by data such as • There are two types of users ( ) request a bike. Registered users Bicycles number, purchase price, purchase date, and insurance details. make, year of production, uses (purpose), size, registry unregistered, and registered users should provide personal and payment information. • There are also two types of : can take a bike for free, limited to 30 minutes, and for more than 30 minutes, they should pay an extra fee of 1$ per hour. For OTPs, initially, they should pay 100$ as a deposit and their hourly rate begins from the moment of usage which is 1$ per hour. After returning the bike, the usage amount will be calculated and deducted from the 100$ deposit, and the rest of the deposit will be returned to them. • No customer can use a bike for more than 100 hours. • For each usage, the office keeps track of the date of request, the date the bike is returned, bike, customer and the rental total charged amount. • Personal details (such as name, address, telephone number) about each customer are kept in the database. HINT: Many-to-many relationships must be split into two one-to-many relationships.

Answer 1

The business case of Go Bike is a sharing bike platform that has several bike parking stations.

Each of the bikes is identified by their unique 6-digit ID in the format: A1A1A. The bike parking stations are described by data such as their longitude and latitude.

There are different departments that are responsible for various tasks, such as maintenance, finance, and operation. At least one employee works in each department, and each employee is assigned to only one department.

There are two types of users: registered and unregistered. Registered users should provide personal and payment information.

They can request a bike at any time, and the bike's purchase date, purchase price, insurance details, and number are recorded.

On the other hand, unregistered users can take a bike for free, but they are limited to 30 minutes. If they use the bike for more than 30 minutes, they must pay an extra fee of 1$ per hour.There are two types of OTPs: registered and unregistered. Initially, they should pay a deposit of 100$. Their hourly rate begins from the moment of usage, which is 1$ per hour. When the bike is returned, the usage amount will be calculated and deducted from the 100$ deposit. The rest of the deposit will be returned to them.No customer can use a bike for more than 100 hours. The office keeps track of the date of request, the date the bike is returned, bike, customer, and the rental total charged amount. Personal details about each customer, such as name, address, and telephone number, are kept in the database. Many-to-many relationships must be split into two one-to-many relationships.