-3

I want to design them drawing an ER Diagram. I have already designed an ER Diagram but teacher told me that it has only 5 entities and I need at least 7 or 8 entities. Also told me that I must not add primary key to a relationship(diamond shape). So my question is how can i achieve this?

enter image description here

Here are the entities and properties of my database.

User – (user_id, username, profile_picture, member_date, user_gender, user_email)

Movie – (movie_id, movie_name, movie_year, movie_country, movie_description)

Review – (review_id, user_id, movie_id, review_score, review_date)

Actor – (actor_id, actor_name, actor_birthdate, actor_gender)

Genre – (genre_id, genre)

Director – (director_id, director_name)

Movie_Genre – (genre_id, movie_id)

Movie_Cast – (actor_id, movie_id)

Movie_Director – (director_id, movie_id)

OldProgrammer
  • 12,050
  • 4
  • 24
  • 45
beytullahdanis
  • 71
  • 5

1 Answers1

1

I think the answer to your diagram questions is right there in your entity list. You have an entity named MOVIE_DIRECTOR but in the diagram you have a relationship named DIRECTS. You just need to change all your relationship diamonds to appropriately named entity rectangles and most of your issues will be resolved. For example, the relationship named "HAS" should really be the entity named MOVIE_GENRE.

Kurt
  • 1,708
  • 1
  • 3
  • 11