Could any one please send solution for the followingquestion.
  1. Read the following case study, which describes the datarequirements for a video rental company. The video rental companyhas several branches throughout the USA. The data held on eachbranch is the branch address made up of street, city, state, andzip code, and the telephone number. Each branch is given a branchnumber, which is unique throughout the company. Each branch isallocated staff, which includes a Manager. The Manager isresponsible for the day-today running of a given branch. The dataheld on a member of staff is his or her name, position, and salary.Each member of staff is given a staff number, which is uniquethroughout the company. Each branch has a stock of videos. The dataheld on a video is the catalog number, video number, title,category, daily rental, cost, status, and the names of the mainactors, and the director. The catalog number uniquely identifieseach video. However, in most cases, there are several copies ofeach video at a branch, and the individual copies are identifiedusing the video number. A video is given a category such as Action,Adult, Children, Drama, Horror, or Sci-Fi. The status indicateswhether a specific copy of a video is available for rent. Beforehiring a video from the company, a customer must first register asa member of a local branch. The data held on a member is the firstand last name, address, and the date that the member registered ata branch. Each member is given a member number, which is uniquethroughout all branches of the company. Once registered, a memberis free to rent videos, up to maximum of ten at any one time. Thedata held on each video rented is the rental number, the full nameand number of the member, the video number, title, and dailyrental, and the date the video is rented out and date returned. Therental number is unique throughout the company.

(a) Identify the main entity types of the video rentalcompany.

(b) Identify the main relationship types between the entitytypes described in (a) and represent each relationship as an ERdiagram.

Please send it as soon as possible