Skip to content

Latest commit

 

History

History
49 lines (42 loc) · 1.39 KB

class_02.md

File metadata and controls

49 lines (42 loc) · 1.39 KB

Exercises

  • Create a new database called imdb
  • Create tables: film (film_id, title, description, release_year); actor (actor_id, first_name, last_name) , film_actor (actor_id, film_id)
    • Use autoincrement id
    • Create PKs
  • Alter table add column last_update to film and actor
  • Alter table add foreign keys to film_actor table
  • Insert some actors, films and who acted in each film