The design adheres to to avoid:
The concept of a movie database dates back to the early days of cinema. In the 1960s and 1970s, film scholars and researchers began compiling lists of films for academic purposes. These early databases were often printed on paper or stored on microfiche, making them cumbersome and difficult to update. database of movies
CREATE TABLE movie_cast ( movie_id INT REFERENCES movie(movie_id), actor_id INT REFERENCES person(person_id), character_name VARCHAR(150), PRIMARY KEY (movie_id, actor_id, character_name) ); The design adheres to to avoid: The concept