The current movie database design lacks functionality to support theaters and show times. It is not possible to see what theaters a movie is currently playing in or what movies are being shown at a particular theater. Therefore, we would like to extend the design to capture the following information.
- Different movie theaters. The design should allow data to be stored such as the name and location of the theater; type of movies typically shown (e.g., first-run (current), second-run (budget), independent); type of theater (e.g., standard, drive-in, IMAX, dine-in); and movie ticket prices by category (e.g., kids, seniors, military, adults, 3D, matinee).
- Listing of theaters (and at what times) a movie is being shown.
- User reviews of the theaters. This should include an overall numeric rating of the theater and allow a written description.
Current Movies Design
Just one question answer.