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 > ER Diagram

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-09-11, 06:23
ksh1234 ksh1234 is offline
Registered User
 
Join Date: Mar 2011
Posts: 1
ER Diagram

hello
Can some1 help me with ER diagram for the below problem:

Theres a university which operates a number of courses. There are a number of schools in the university. Each school is responsible for one or more courses. A course is a property of a single school. A number of lecturers work for each school. Lecturers work for one school only. School operates a number of modules. A module is associated witha single school. Lecturers teach on the modules. Typically a lecturer teaches more than one module and a module is taught by more than one lecturer. A module is associated with one lecturer who is the module leader for that module. A lecturer may be the module leader for more than one module. A course is made up of many modules. and the same same module may appear on many courses. a school can be responsible for a module that is taught on a course owned by a different school. student at the uni enroll on a course and take many modules. A student at any one time can be enrolled on one course.

thank you..
Reply With Quote
  #2 (permalink)  
Old 03-09-11, 07:25
Wim Wim is offline
Registered User
 
Join Date: Nov 2004
Posts: 1,279
This should give you a good start.

Can you inform me of the mark I was given for the data model?
Attached Thumbnails
ER Diagram-univ.gif  
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 16
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote
  #3 (permalink)  
Old 03-09-11, 07:26
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
yes we can help you with it

can we do it for you? no way

so... what have you got so far?
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #4 (permalink)  
Old 03-09-11, 07:28
Wim Wim is offline
Registered User
 
Join Date: Nov 2004
Posts: 1,279
Correction in data model.
Attached Thumbnails
ER Diagram-univ.gif  
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 16
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote
  #5 (permalink)  
Old 03-09-11, 08:19
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by tonkuma View Post
You can ask the question on
Database Concepts & Design - dBforums
I suspect that in order to find someone who will do this school assignment for them, that they have already posted the question in multiple places.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
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