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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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 

Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY