This group assignment provides an opportunity to develop your database design skills through a…
This group assignment provides an opportunity to develop your database design skills through a hands-on activity. The focus of the assignment is to extend an existing database design at the logical level. Two scenarios are presented below, which discuss functionality that should be added to an existing design. One scenario is for the movies database and the other is for the beer database. Select only one scenario and do the following three tasks.
1. Update the design to fulfill the requirements of the selected scenario. This should include developing an extended ERD.
2. List the critical assumptions you made in your design. Also, discuss how those assumptions may limit current functionality.
3. Assume you implemented your updated design. In plain English, describe two interesting queries that can now be run using your new design. (Including the SQL is also highly encouraged.)
The current movie database design lacks the 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.
1. 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.
2. List of theaters (and at what times) a movie is being shown.
3. User reviews of the theaters. This should include an overall numeric rating of the theater and allow a written description.