1. Draw the fully labelled and implementable Crow's Foot notation ERD to support the following business operations given below in the case study. 2. Identify all entities with fully defined PKs and FKs. 3. Identify all possible relationships. 4. Identify the connectivity for each relationship. 5. Identify the mandatory/optional dependencies for the relationships. 6. Resolve all M:N relationships. Case Study: Xbox & PS5 Rental System DownTown Xbox & PS5 is a chain of 11 games rental stores scattered throughout a major metropolitan area in the Victoria. The chain started with a single store several years ago and has grown to its present size. Phil Spencer, the owner of the chain, knows that to compete with the national chains will require a state-of-the-art games rental system. You have been asked to develop the system requirements for the new system. Each store has a stock of Xbox and PS5 games for rent. It is important to keep track of each game title to know and to identify its category (action and adventure, horror games, board games, driving, racing, fighting and so on), its rental type (new release, standard), games rating, and other general information such as developer, release date, cost, and so forth. In addition to tracking each title, the business must track each individual copy to note its purchase date, its condition, and its rental status. User functions must be provided to maintain this inventory information. Customers are also tracked. DownTown considers each family to be a customer, so special mailings and promotions are offered to each household. For any given customer, several people may be authorized to rent games. The primary contact for each customer can also establish rental parameters for other members of the household. For example, if a parent wants to limit a childs rental authorization to only PG and PG-13 games, the system will track that. Each time a game is rented, the system must keep track of which copies of which games are rented; the rental date and time and the return date and time; and the household and person renting the game. Each rental is open until all of the games have been returned. Customers pay for rentals when checking out games at the store