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
Post a Comment