![movie collector spreadsheet movie collector spreadsheet](http://4.bp.blogspot.com/_S0f-AWxKVdM/R9lK8g8CB2I/AAAAAAAAA8Q/WTRZgM7G4sQ/s320/Movie-Organizer.png)
MOVIE COLLECTOR SPREADSHEET MOVIE
Some fields are more obvious than others: revenue (the amount of money the movie made), budget (the amount spent on creating the movie). There are text descriptions such as title and overview. The movie table contains information about each movie. What do all of these tables and columns mean? It contains about 4,800 movies, 104,000 cast and crew, and thousands of metadata records such as languages and keywords. The sample data was obtained from a free online data source. This database stores information about movies, the cast and crew involved, where the movie was produced and by which company, and other information about movies such as the languages, genres, and keywords. The ERD or database design of the sample movie database is here (open in new tab, or save, to see a larger version): Why is this helpful? Firstly, you can understand more about how a movie database might work.Īlso, you can practice SQL against realistic data and write your own queries, both simple (how many movies has Tom Cruise been in?) and complex (which movies have Tom Cruise and Matt Damon both been in?). A download of sample data to create and populate this database.An explanation of the tables and columns.An ERD (entity relationship diagram) for the sample movie database.This post describes a sample database containing data about movies. These can be helpful, but often you’re looking for answers that these databases don’t help with. Many articles online refer to Oracle’s HR database, or SQL Server’s AdventureWorks database.
![movie collector spreadsheet movie collector spreadsheet](http://2.bp.blogspot.com/-5bGmd1HSVWQ/ThOWEBS0E6I/AAAAAAAAAIc/77xEnGLuUj4/s1600/Movie+Collection+List.jpg)
When you’re learning SQL or database design, it’s helpful to use other databases as a reference.