ST Alpha - "ST Poll: If you were to build a (not large) database about movies for a school project, what would it be about? Fun/wacky ideas appreciated." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 151

Favourites: 1

ST Poll: If you were to build a (not large) database about movies for a school project, what would it be about? Fun/wacky ideas appreciated.

Posted by con_carne May 20 '11, 14:40

I'm supposed to make up and build an Access database for my class project. I'm thinking I want it to have something to do with movies. But I'm trying to pin down what tables would be involved.

One table would be a list of movies, obv. What would the other tables be? One idea I just had: A list of my favorite actors/actresses? Then, I could rate each movie in the movies table and run reports that could tell me which of my favorite actors star in the best movies. Or, I could run a report on who stars in the most action movies. To make the size manageable, I could limit the movies to the ones in my collection. Or only ones that came out in a given year.

What other kinds of data would you consider? A database for the amount of concessions you buy per movie outing? So then you could run reports and see if any particular genres cause you to spend more money?

I'm boring myself just typing these ideas. STers, make my project more fun by suggesting a wacky, particular think I could keep track of in movies.

Responses:

sountrack artist and numbers -- nm - Danedukenuuk May 20, 16:42
surprise cameo appearances, number of names above the title on the poster. -- nm - Max May 20, 15:15
Film length, so you could sort your DVDs by the amount of time you have to watch one. - TFox May 20, 15:13 5
- Okay. Relating the elapsed time to the actors would allow me to see which actors are responsible for sucking away most of my time. ;-) - con_carne May 20, 15:19 3
  - Right, there's fun ideas, and then there's ideas that are actually doable. - TFox May 20, 15:21 1
    - I need to be able to relate the data in one table (movies) to other tables, hence my need to relate film length to something other than the movie. -- nm - con_carne May 20, 15:47
  - my release date format preference for movies is YYYY.MM which allows quick chronological sorting and wildcard searching of "comedies released in May" -- nm - Max May 20, 15:21
- Oh, and a flag if the movie involves a nutsack placed on a drumset. -- nm - TFox May 20, 15:14
Montage Count -- nm - Max May 20, 14:58
Spit-takes, creative cursing (Mother Pussbucket!), men in drag, animal saves the day -- nm - TWuG May 20, 14:55 1
- creative censorship would be a great one (this is what happens when you find a stranger in the alps!) -- nm - Beryllium May 20, 14:57
Wilhelm Scream. Long tracking shots. Scenes where it's snowing or raining. -- nm - mara May 20, 14:51 5
- "Long tracking shots." I love it! -- nm - con_carne May 20, 15:02 3
  - I could call the table ArtsyFartsyness. - con_carne May 20, 15:05 2
    - Lens flare! -- nm - mara May 20, 15:11 1
      - Scenes after the closing credits. -- nm - Max May 20, 15:12
- Movies where the director appears in the film. -- nm - mara May 20, 14:52
Action scenes per movie? Restroom breaks? Nude scenes? Food scenes? -- nm - the liioulu with tomato plants May 20, 14:46 5
- Okay, things along these lines is what I'm looking for. Interesting... -- nm - con_carne May 20, 14:47 4
  - number of rap songs per movie vs the number of murders in the lobby and/or parking lot? -- nm - zeitgeist May 20, 14:57 2
    - i also hate black people. -- nm - TFox May 20, 14:59 1
      - TPartyFox -- nm - David May 20, 15:03
  - Food scenes per movie compared to concession purchases? -- nm - the liioulu with tomato plants May 20, 14:53
you know what I think would be cool - is correlation between product placement and movie and corporate investment overlaps - see inside - JenBro May 20, 14:46
*puppy head tilt* - Max May 20, 14:45 3
- Or, even a piece of one. 2-3 tables max is probably all I'll be needing for this. - con_carne May 20, 14:57 2
  - basically what I do is - Max May 20, 15:07 1
    - the director thing I like a lot (I could do just auteurs). - con_carne May 20, 15:34

Post a message top

ST Poll: If you were to build a (not large) database about movies for a school project, what would it be about? Fun/wacky ideas appreciated.

Replies are disabled on threads older than 7 days.