A Gentle Introduction to

SQL


Pick an engine:

Movie Database

This database features two entities (movies and actors) in a many-to-many relation. Each entity has its own table. A third table, googleEsta base de datos ofrece dos entidades (las películas y los agentes) en una relación múltiple. Cada entidad tiene su propia tabla. Una tercera tabla, castinggooglebastidor , is used to link them. The relationship is many-to-many because each film features many actors and each actor has appeared in many films.google, se utiliza ligarlos. La relación es múltiple porque cada película ofrece a muchos agentes y cada agente ha aparecido en muchas películas.

moviegooglepelícula

Field name Type Notes
id INTEGER An arbitrary unique identifier
title CHAR(70) The name of the film - usually in the language of the first release.
yr DECIMAL(4) Year of first release.
score FLOAT Average of all the votes cast for the film. (Internet users can vote for films on a scale of 1-10)
votes INTEGER The number of votes cast for this film.

actorgoogleagente

Field name Type Notes
id INTEGER An arbitrary unique identifier
name CHAR(36) The name of the actor (the term actor is used to refer to both male and female thesps.)

castinggooglebastidor

Field name Type Notes
movieid INTEGER A reference to the movie table.
actorid INTEGER A reference to the actor table.
ord INTEGER The ordinal position of the actor in the cast list. The star of the movie will have ord value 1 the co-star will have value 2, ...

Footnotes

This data has been drawn from the googleEstos datos han sido exhaustos de Internet Movie DatabasegoogleBase de datos De la Película Del Internet The cast lists have been truncated to exclude those actors with a single appearance.googleLas listas del molde se han truncado para excluir a esos agentes con un solo aspecto.

New releases and English language films are predominant.googleLos nuevos lanzamientos y las películas de la lengua inglesa son predominantes.

Often the the title is in the original language thus googleEl título está a menudo en la lengua original así My Life as a DoggoogleMi vida como perro is googlees Mitt liv som hundgoogleHund del som del liv de Mitt and The Good the Bad and the UglygoogleEl bueno el malo y el feo is googlees Buono, il brutto, il cattivo, IlgoogleBuono, brutto del il, cattivo del il, Il

Because of the actor culling the ord values may not be consecutive for a given film.googleDebido a el agente el desecho de los valores del ord puede no ser consecutivo para una película dada.