Member Avatar for ravi_14

the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships?

  • 2 Contributors
  • 1 Reply
  • 140 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

I would build an intervening table that holds the student ID and the course ID and nothing else (OK, you might have a reason to put in some other columns but you get the idea). It is simply a list of the courses a student is enrolled in.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.