The Random City transportation department has launched a city bike sharing program using distinctive yellow bicycles and rental stations. The department needs to design an information system to keep track of all the information related to the program " The bikes lock into special bike racks at the rental stations, and are released by a customer swiping his or her credit card. Customers register for the program online, providing their first name, middle name, last name, credit card number, and address information. For this problem, assume that all addresses consist of a street address, city, state, and zip code. The program encourages use of the bikes by visitors from outside the city, so customers do not have to be city residents (but, for now they must be U.S. residents). Assume the city has access to a national zip code table Customers may rent the bikes at various stations distributed around the city and adjoining municipalities. For each station, the transportation department wants to store a name, address information, and the number of bike rack slots (some stations have more slots than others) Bikes can be rented at any rental station and may be returned to any of the rental stations anywhere in the city, not necessarily the one where the bike was rented. For each bike rental, the transportation department wants the system to remember which customer rented the bike, which bike was rented, which station it was rented from, which station it was returned to, the date/time of rental, and the date/time of return * Each bike has a unique tag number and an acquisition date. The transportation department also wants to keep records about all maintenance performed on the bikes. For each maintenance operation, the system needs to remember which bike the maintenance was performed on, the date/time maintenance started, the date/time maintenance ended, the total labor hours, and all parts used Each type of part has a unique inventory code and a description. Sometimes, multiple parts of the same type may be used in a single maintenance operation: for example, a single maintenance operation might consume two yellow reflectors and five spokes Draw an entity-relationship diagram and write a database design outline. The Random City transportation department has launched a city bike sharing program using distinctive yellow bicycles and rental stations. The department needs to design an information system to keep track of all the information related to the program " The bikes lock into special bike racks at the rental stations, and are released by a customer swiping his or her credit card. Customers register for the program online, providing their first name, middle name, last name, credit card number, and address information. For this problem, assume that all addresses consist of a street address, city, state, and zip code. The program encourages use of the bikes by visitors from outside the city, so customers do not have to be city residents (but, for now they must be U.S. residents). Assume the city has access to a national zip code table Customers may rent the bikes at various stations distributed around the city and adjoining municipalities. For each station, the transportation department wants to store a name, address information, and the number of bike rack slots (some stations have more slots than others) Bikes can be rented at any rental station and may be returned to any of the rental stations anywhere in the city, not necessarily the one where the bike was rented. For each bike rental, the transportation department wants the system to remember which customer rented the bike, which bike was rented, which station it was rented from, which station it was returned to, the date/time of rental, and the date/time of return * Each bike has a unique tag number and an acquisition date. The transportation department also wants to keep records about all maintenance performed on the bikes. For each maintenance operation, the system needs to remember which bike the maintenance was performed on, the date/time maintenance started, the date/time maintenance ended, the total labor hours, and all parts used Each type of part has a unique inventory code and a description. Sometimes, multiple parts of the same type may be used in a single maintenance operation: for example, a single maintenance operation might consume two yellow reflectors and five spokes Draw an entity-relationship diagram and write a database design outline