Detailed explanation of the relationships between the tables

Blockbuster Video Rental is thinking about entering the DVD Kiosk business to complete with RedBox. The concierge DVD kiosk service is usually placed near commercial chain stores such as CVS, RiteAid and Walgreens. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie "Remember the Titans". "Remember the Titans" would be one MOVIE and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. Using the model tool in MySQL workbench, construct and adjust the ERD listed below. Once you have constructed the E-R model