sql - How to link these two tables with the entity relationship model? -


if have 2 entities, "courses" , "course_offerings", , both have key called "course number" , how relate these 2 entities? relationship table not make sense because mapping same course number same course number, redundant. leaving them unlinked seems wrong. correct way er model?

what er diagram like?


Comments