| |
Welcome to the dBforums forums.
You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact contact support.
If you prefer not to see double-underlined words and corresponding ads, place your cursor here for ContentLink opt out.
|
 |
11-02-07, 17:13
|
|
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
|
Last edited by x_siobhan_x : 11-02-07 at 17:30.
|
11-02-07, 18:18
|
|
SQL Apprentice
|
|
Join Date: Jan 2007
Location: hiding
Posts: 8,145
|
|
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
You only stop learning when you stop asking questions.
|
|
11-03-07, 04:48
|
|
Gives Bad Advice
|
|
Join Date: Mar 2007
Location: 010101010110100
Posts: 706
|
|
|
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.
__________________
I and many others around the world are of the strong belief that the universe was created by the Flying Spaghetti Monster. It was He who created all that we see and all that we feel. We feel strongly that the overwhelming scientific evidence pointing towards evolutionary processes is nothing but a coincidence, put in place by Him.
|
|
11-03-07, 08:05
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 13,556
|
|
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
|
|
11-07-07, 16:39
|
|
Registered User
|
|
Join Date: Nov 2007
Posts: 7
|
|
Oh, the joy of ERD! Actually I enjoyed Database systems class out of all my CSC classes.
|
|
11-11-07, 08:35
|
|
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.
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Help with homework problem...please!!!
