Results 1 to 5 of 5

Thread: ER Diagram

  1. #1
    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..

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    This should give you a good start.

    Can you inform me of the mark I was given for the data model?
    Attached Thumbnails Attached Thumbnails Univ.gif  
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    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

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes we can help you with it

    can we do it for you? no way

    so... what have you got so far?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Correction in data model.
    Attached Thumbnails Attached Thumbnails Univ.gif  
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    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

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

Posting Permissions

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