Verifique todos os fatos que descrevem o armazenamento de dados em um banco de dados relacional.
Marque todas as respostas corretas e clique no botão "Verificar!"
Verifique todos os fatos que descrevem o armazenamento de dados em um banco de dados relacional.
Marque todas as respostas corretas e clique no botão "Verificar!"
Explore mais de 270 tarefas diversas na nossa plataforma.
Faça login para salvar seu progresso.
Diagrama ER do Banco de Dados Sakila
O banco de dados Sakila contém 15 tabelas principais descrevendo vários aspectos de uma empresa de aluguel de DVDs.Abaixo está uma lista dessas tabelas:
actor_id | first_name | last_name | last_update |
---|---|---|---|
1 | John | Doe | 2023-01-01 12:00:00 |
address_id | address | address2 | district | city_id | postal_code | phone | last_update |
---|---|---|---|---|---|---|---|
1 | 123 Rua Principal | Apto 4 | Centro | 1 | 12345 | 123-456-7890 | 2023-01-01 12:00:00 |
category_id | name | last_update |
---|---|---|
1 | Ação | 2023-01-01 12:00:00 |
city_id | city | country_id | last_update |
---|---|---|---|
1 | Metrópole | 1 | 2023-01-01 12:00:00 |
country_id | country | last_update |
---|---|---|
1 | Estados Unidos | 2023-01-01 12:00:00 |
customer_id | store_id | first_name | last_name | address_id | active | create_date | last_update | |
---|---|---|---|---|---|---|---|---|
1 | 1 | João | Silva | joao.silva@exemplo.com | 1 | true | 2023-01-01 12:00:00 | 2023-01-01 12:00:00 |
film_id | title | description | release_year | language_id | original_language_id | rental_duration | rental_rate | length | replacement_cost | rating | special_features | last_update |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Título do Filme | Uma breve descrição do filme. | 2000 | 1 | 2 | 5 | 4.99 | 120 | 19.99 | PG-13 | Trailers, Comentários | 2023-01-01 12:00:00 |
actor_id | film_id | last_update |
---|---|---|
1 | 1 | 2023-01-01 12:00:00 |
film_id | category_id | last_update |
---|---|---|
1 | 1 | 2023-01-01 12:00:00 |
inventory_id | film_id | store_id | last_update |
---|---|---|---|
1 | 23 | 2 | 2023-01-01 12:00:00 |
language_id | name | last_update |
---|---|---|
1 | Inglês | 2023-01-01 12:00:00 |
payment_id | customer_id | staff_id | rental_id | amount | payment_date | last_update |
---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 4.99 | 2023-01-01 12:13:14 | 2023-01-01 12:14:15 |
rental_id | rental_date | inventory_id | customer_id | return_date | staff_id | last_update | ||
---|---|---|---|---|---|---|---|---|
1 | 2023-01-01 16:15:21 | 1 | 1 | 2023-01-10 09:12:36 | 1 | 2023 | 1 | 2023-01-10 09:12:36 |
staff_id | first_name | last_name | address_id | picture | store_id | active | username | password | last_update | |
---|---|---|---|---|---|---|---|---|---|---|
1 | João | Silva | 1 | [null] | joao.silva@exemplo.com | 1 | true | joaosilva | ******** | 2023-01-01 12:00:00 |
store_id | manager_staff_id | address_id | last_update |
---|---|---|---|
1 | 1 | 1 | 2023-01-01 12:00:00 |