• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

The Sample Database

We have made an effort to illustrate all examples with a manageable database example that asks simple as well as complicated questions. The advantage for you is that you do not have to familiarize yourself with a new data model every time a new example is presented. The sample database and installation instructions are included on the book’s companion CD

We have selected Contoso, Ltd, which shows current movies on multiple screens. The sample database administers show schedules. Contoso wants to administer its movies, schedules, and theaters. For each calendar week, there is a list of movies playing during that week. Other information on the database includes how long each movie has been out, the movie’s length, and the Motion Picture Association of America (MPAA) rating. Show schedules, admission prices, the theater where the movie is playing, the number of seats in that theater, and the turnaround time (the time needed to clear the theater and fill it up with the audience attending the next show) are also provided.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint