Situational Seattle biking project

Velocity is a Seattle-based bicycle rental business that provides its clients with short-term bicycle rentals. Bicycles can be rented from one of the many rental shops that are located in Seattle. • Each bicycle has a unique brand, registry number, 5-digit-ID (format: AA111), date of purchase, and date of production that can be used to identify it. • Each rental office has a unique 3-digit ID (format: 111) and is identified by its geographic location (i.e., street name, longitude, and latitude). • Several departments, including bookkeeping, operations, and bicycle management, are involved in this procedure to handle the activities of High-Speed. There could be zero (automated) to ten personnel in each department. • The bicycle management department will replace missing bicycles and fix broken ones if there are any in the rental office or if there are damaged bicycles there. • Unregistered and registered users make up the two categories of customers in this business, and only registered users (members) are permitted to make bicycle requests in advance. Those who have registered should give their contact and payment details to velocity. • Members' rental requests and one-time rental requests (i.e., requests from unregistered users) are the two different categories of rental requests. Members may use a bicycle for up to 30 minutes for free; beyond that, they must pay an additional $3 per hour. For one-time rental requests (i.e., unregistered users), a deposit of 90 dollars is required at first, and after that, they are charged an hourly cost of $3 per hour. The deposit will be reimbursed to them after the bicycle has been returned. o Users must purchase a 50-dollar monthly fee in order to become members. o For an additional $40 ($90 dollars in total), users may get a family membership, which is good for up to 4 people. • A bicycle may not be rented out for more than 100 hours at a time. The rental office records the date of request, the date the bicycle is returned, information on the bicycle, user details (such as name, address, and phone number), and the total rental rate for each usage. Questions regarding the project that must be answered clearly; Q1: Data Management: Entity Relationship Diagram & MS Access a. Draw the ERD of the database that could be used to support the operations of the the business described in the case. 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. b. Create the data dictionary for your database. c. Implement the ERD using Microsoft Access 2010/2013/2016/2019 or LibreOffice Using the ERD and data dictionary that you created previously, complete the following steps: 1. Implement the ERD and data dictionary in Microsoft Access 2010/2013/2016/2019 or LibreOffice. The Microsoft Access Database should have all the tables, attributes, and relationships defined in your ERD and data dictionary. You should make sure that all the primary keys and foreign keys are defined. 2. Create 5 records in each table of your Microsoft Access/LibreOffice Database. Make sure to create the records for the parent tables first (the ones with the one side), otherwise, you might run into referential integrity issues. 3. Create 2 queries in Microsoft Access/LibreOffice that a manager could answer using this database. Your queries must each use at least two tables. Make sure to clearly write each question that your query is answering. 4. Create 2 reports by using the queries designed in step 3.