Design an ER diagram for the following requirements of an on…
Design an ER diagram for the following requirements of an online streaming service system. The streaming service is identified by a unique name and provides different subscription plans. Each subscription plan has a unique plan ID, including details such as name and price as well as features such as the number of screens and HD availability. Subscribers, with unique subscriber IDs, include personal information such as name, email, and payment details, and are enrolled in one subscription plan. Movies on the platform have unique movie IDs and details such as title, description, release year, and duration. Each movie is linked to a director with a director ID, including the director’s name and biography. The platform tracks the genres associated with each movie. Movies are categorized into various genres, each with a name and a description, and a movie can be associated with multiple genres. Subscribers have a viewing history, with each record identified by a history ID, including the date and time of viewing. Subscribers can rate and review movies, with each rating identified by a rating ID and including rating value and review. Directors can direct multiple movies, but each movie is directed by only one director. Create your diagram using ERDPlus. Provide additional explanations if necessary. When you are finished, export it as an image, and upload it.
Read Details