Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Help with homework problem...please!!!

    I need help with this homework problem. I think I have it right but am not sure. ERD is included as an attachment. Here is the problem itself:

    The Hudson Engineering Group (HEG) has contacted you to create a database for its training program. The HEG has several instructors, and offers advanced technology courses, each of which may be taught several times a year. Each offering is taught by one instructor, and can have up to 30 students. Instructors are capable of teaching many different courses. Draw an entity-relationship for HEG (in 3NF!).

    Here is what I have so far....

    Code:
    Instructor (InstructorNum, InstructorName, CourseNum)
    Courses (CourseNum, CourseName, QuarterOffered)
    
    CourseNum --> CourseName, QuarterOffered
    InstructorNum --> InstructorName, CourseNum
    	FK CourseNum --> Courses
    Do I have everything I need? Should I have included students?
    Any help would be appreciated.

    thanks,
    Siobhan
    Attached Files Attached Files
    Last edited by x_siobhan_x; 11-02-07 at 17:30.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Quote Originally Posted by x_siobhan_x
    Do I have everything I need?
    Nope
    Quote Originally Posted by x_siobhan_x
    Should I have included students?
    Yep

    George
    Home | Blog

  3. #3
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    I think you have done good so far by your diagram.

    I personally count 4 entities in your assignment. You have 2 of them so far. See if you can guess what the other 2 are.

    We are not allowed to "do the work for you" but we can help you to find the answers. Just continue to put a little effort (as you have done) and I'm sure you will find the people here more than willing to help you.


  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what they said ^^

    here's one problem you might want to think about:

    in the Courses table, each course occurs only once, and each course has a CourseName and QuarterOffered

    however, this design means that each course can be offered in only one quarter, and that's wrong

    similarly in the Instructor table, each instructor can teach only one course
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2007
    Posts
    15
    Oh, the joy of ERD! Actually I enjoyed Database systems class out of all my CSC classes.

  6. #6
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Just continue to put a little effort
    That comment made me laugh violently.

    I agree yes, just push yourself that little bit further. Open the book, read a bit, breathe, rest, read some more, almost there, you've done it.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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