An Introduction to Class::DBI - First Example 16

Example - And the winner is...

  • For each nominated film in a given year and category:

    • go through the list of voters and tally their votes for each film

          CREATE TABLE nomination (
              id              INTEGER PRIMARY KEY,
              type            VARCHAR(255),
              year            INTEGER,
              film_id         INTEGER,
              credit_id       INTEGER,
              takes_the_oscar INTEGER
          );
      
          CREATE TABLE vote (
              voter_id        INTEGER PRIMARY KEY,
              nomination_id   INTEGER
          );
      

 

YAPC::Canada << Previous | Index | Next >>
Copyright © 2003 Michael Graham