If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Help with homework problem...please!!!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-02-07, 16:13
x_siobhan_x x_siobhan_x is offline
Registered User
 
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
File Type: doc ERD.doc (23.5 KB, 133 views)

Last edited by x_siobhan_x; 11-02-07 at 16:30.
Reply With Quote
  #2 (permalink)  
Old 11-02-07, 17:18
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
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
Twitter | Blog
Reply With Quote
  #3 (permalink)  
Old 11-03-07, 03:48
Frunkie Frunkie is offline
Gives Bad Advice
 
Join Date: Mar 2007
Location: 010101010110100
Posts: 791
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.

Reply With Quote
  #4 (permalink)  
Old 11-03-07, 07:05
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 11-07-07, 15:39
lpremus lpremus is offline
Registered User
 
Join Date: Nov 2007
Posts: 15
Oh, the joy of ERD! Actually I enjoyed Database systems class out of all my CSC classes.
Reply With Quote
  #6 (permalink)  
Old 11-11-07, 07:35
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
Quote:
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On