Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Smile Database design - Entity Relationship

    I have 4 Entities that are related - Student, Course, Teacher, and Classroom. My question is "Is it a Quaternary situation where all these entities are related in only one table containing their respective Primary Keys as foreign keys in a fifth table?".

    I would appreciate ur response

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Database design - Entity Relationship

    Seems unlikely: if Teacher T1 teaches Student S1 for Course C1 in Classroom R1, isn't it likely that he teaches all his C1 students in R1?
    In other words, Course, Teacher -> Classroom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •