assignment2

Tables (4)

Table (Movie)

  • rated
  • genre
  • title
  • releaseDate
  • director(*Director)
  • productionCompany(*ProductionCompany) (productionCompanyId(*ProductionCompany))
  • sequel({*Movie})
  • prequel({*Movie})
  • stars({*Star})

Table (Director)

  • name
  • gender
  • birth
  • movies({*Movie})

Table (Star)

  • name
  • birth
  • gender
  • movieId
  • movies({*Movie})

Table (ProductionCompany)

  • country
  • name
  • movies({*Movie})