Use the IDEFX notation to draw an ER of the following video rental… Use the IDEFX notation to draw an ER of the following video rental shop.?????ideo: Video#, VideoCopy#, Video Title, Rating, Genre, Number of?vailable????????copies;Customer: Customer Name, Address, Age, Phone#;Rental Transaction: Transaction#, Check-out-Date, Scheduled Return Date,?Video#, VideoCopy#The assumptions are as follows:Every transaction is associated with only one customer and may include several video copies .Customer name and Phone# are the key for Customer;Video# is the key for the video attributes;VideoCopy#?and Video# are the key for a video copy;Rental Transaction is the key for transaction attributes.?lease draw the ER diagram using a tool on paper and upload a copy of your solution.?omputer ScienceEngineering & TechnologyMYSQL CS 4350
