Stay Home Online Rentals have decided that they wish to extend the online information offered to their clients. They have identified the following new requirements:
(a) Store data on film directors.
(b) Store a short biography on each actor along with photograph.
(c) Stock video games for the Sony Playstation 3 and PSP, Microsoft Xbox 2, Nintendo Wii, and DS Lite. (
d) Provide an online facility for clients to write a comment and grade each DVD viewed or game played. (e) Store data on client preferences so that when they revisit the web site, the system can provide recommendations on new DVDs/games stock they may be interested in. Provide a revised conceptual, logical, and physical data model to reflect these new requirements. How do these new requirements impact on indexes chosen previously?