The ABC company provides rental service of portablepower banks to its registered members. You are a databasedesigner of the ABC company, and you are designing thedatabase to support a system with the following functions:$1.$ Membership System Each member is required to provide theirname, email, and contact number in theregistration form. The system willautomatically generate a unique member IDupon registration$\mathrm{.}2.$ Power Bank Management System There are charging stations, each equipped with a unique station ID andcontains a certain number of charging slots. Each charging slot is assigned a unique slot ID$,$ exclusive to that particularcharging station. The company possesses numerous power banks, each distinguished by aunique pbID. Any power bank can be plugged into any available charging slot within acharging station$\mathrm{.}3.$ Power Bank Rental System A member can initiate multiple rental transactions, eachinvolving the rental of one power bank. Each rental transaction is assigned a unique transactionID, capturing information such as which memberrenting which power bank. The transaction can record which charging slot the userretrieved from and the retrieval datetime, as well aswhich charging slot the user returned to$,$ and the returndatetime. Additionally, the transaction includes details of thepayment amount$\mathrm{.}4.$ Coupon System ABC Company issues coupons to its members, each with aunique coupon ID and an expiration date. There are two typesof coupons: Free Rental Coupons and Discount Coupons. Free Rental Tickets: Each ticket can be used to redeem onefree rental transaction. Merchants Discounts:i$.$ These coupons are not tied to the rental of powerbanks but offer discounts accepted by one or morepartner merchants.ii$.$ ABC Company collaborates with various partnermerchants, each having a unique merchant ID$.$ Someof these merchants also maintain charging stations$\mathrm{.}5.$ Reservation System Members can reserve a power bank at any available charging station with areservation interface that operates as follows: Members can search for a service area using a hierarchical structure,eventually selecting a location $-$ this is the lowest$-$level service area withoutany sub$-$service area. Each location may host zero to many charging stations. Members choose a charging station with an available power bank andproceed to make a reservation. Each reservation is assigned a unique reservation ID and records thedatetime of the reservation.Assignment tasks$[50\%]$ Task $1.$ Please draw an E$-$R diagram to capture all the requirements above. If there is any information about the data model that is not listed in thespecification, please make a reasonable assumption and list your assumption inyour design. Marks will be deducted if unnecessary components are added to the tables.Please follow the problem specification when you decide on the name of thecomponents. You are encouraged to draw the E$-$R diagram using any kind of editor, this canhelp us to read and understand your data model. If you choose to draw the E$-$Rdiagram by pen$/$pencil$,$ please scan your work and submit a PDF file. We mayask you to re$-$submit a clearer version in case we cannot read the handwriting.$[50\%]$ Task $2.$ Please translate your E$-$R diagram into relational table schemas. For each relation, underline the primary key and specify all the foreign keys ifany. You only need to give the table schema in text form. You do not need to draw theschema and do not need to provide the data type$/$SQL to create the tables. Enjoy this assignment as a practice related to Chapter $2$

$***($Very important$)***$please draw the Task $1$ like the example ER digram in the picture.