5. The following problem describes the data requirements for a video rental company. The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, the telephone number, and the manager. Each branch is given a branch number, which is unique throughout the company. Each branch is allocated staff, which includes a Manager. The Manager is responsible for the day-to-day running of a given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company. There is no special additional information kept about a manager, so you should not define a separate entity for a Manager. The company has a catalog of video titles. The data held on a video title is the catalog number, title, category, daily rental fee, purchase cost, the names of the main actors, and the director. The catalog number uniquely identifies each video title. Each branch may have one or more copies of a video title. Each copy has a rental status, and the individual copies are identified using the video number. A video title is given a category such as Action, Adult, Children, Drama, Horror, or Sci-Fi. The rental status indicates whether or not a specific copy of a video is currently rented. Before renting a video from the company, a customer must first register as a member of a local branch. The data held on a member is the first and last name, address, the date that the member registered at a branch, and the branch at which the member registered. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent videos, up to a maximum of ten at any one time. The data held on each video rented is the rental number, the full name and number of the member, the video number, title, and daily rental, and the dates the video is rented out and date returned. The rental number is unique throughout the company. (a) Draw a single ER diagram to represent the data requirements of the video rental company. State any assumptions necessary to support your design. Identify attributes and associate them with entity types. Do not worry about duplicating data in entities in this assignment. The next assignment will use normalization to eliminate redundant data and unnecessary data dependencies. Identify candidate and primary key attributes for each entity type. Make reasonable assumptions about the uniqueness of attributes and state what those assumptions are if in doubt. For example, do not assume that customer names are unique but it is reasonable to assume that two customers with the same names do not live at the same address. (C) 5. The following problem describes the data requirements for a video rental company. The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, the telephone number, and the manager. Each branch is given a branch number, which is unique throughout the company. Each branch is allocated staff, which includes a Manager. The Manager is responsible for the day-to-day running of a given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company. There is no special additional information kept about a manager, so you should not define a separate entity for a Manager. The company has a catalog of video titles. The data held on a video title is the catalog number, title, category, daily rental fee, purchase cost, the names of the main actors, and the director. The catalog number uniquely identifies each video title. Each branch may have one or more copies of a video title. Each copy has a rental status, and the individual copies are identified using the video number. A video title is given a category such as Action, Adult, Children, Drama, Horror, or Sci-Fi. The rental status indicates whether or not a specific copy of a video is currently rented. Before renting a video from the company, a customer must first register as a member of a local branch. The data held on a member is the first and last name, address, the date that the member registered at a branch, and the branch at which the member registered. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent videos, up to a maximum of ten at any one time. The data held on each video rented is the rental number, the full name and number of the member, the video number, title, and daily rental, and the dates the video is rented out and date returned. The rental number is unique throughout the company. (a) Draw a single ER diagram to represent the data requirements of the video rental company. State any assumptions necessary to support your design. Identify attributes and associate them with entity types. Do not worry about duplicating data in entities in this assignment. The next assignment will use normalization to eliminate redundant data and unnecessary data dependencies. Identify candidate and primary key attributes for each entity type. Make reasonable assumptions about the uniqueness of attributes and state what those assumptions are if in doubt. For example, do not assume that customer names are unique but it is reasonable to assume that two customers with the same names do not live at the same address. (C)