Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2009
    Posts
    24

    Need help with ER Diagram and Stuffs.

    You will design and create of a database application for any type of organization. You will define the main business activities of the organization. You must also provide a brief written description of the organization’s operational procedures and the list of derived “Business Rules”.


    Assignment 1 (a) – ER Modeling

    1. Identifying Entities and Attributes
    2. Specifying Relationship Types
    3. Identify and including constraints. (if applicable)
    4. Identifying and including all key attributes, e.g primary, foreign
    5. Draw an appropriately labeled E-R model diagram.

    http://img195.imageshack.us/img195/695/picture1epi.png

    can anyone help me out with this?

    I need at least 5 entity.. but i have no idea how to squeeze the other one.
    Last edited by MarineX; 07-01-09 at 09:08.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Marine - the very worst type of homework request is what you have just done: a copy and paste of the assignment and then asking for us to do your homework for you. In short, cheating.

    You'll get fook all.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by pootle flump
    Marine - the very worst type of homework request is what you have just done: a copy and paste of the assignment and then asking for us to do your homework for you. In short, cheating.

    You'll get fook all.
    i see... e very form of respect is to.. ignore it instead of leaving such comments, thanks!

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I'm a mod. May I refer you to the rules section:
    dBforums - Forum Guidelines

    Cheating does not get ignored, nor cheaters respected.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Thread locked. I haven't deleted it so your teacher can find it if (s)he decides to google his\ her question text.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by pootle flump
    I'm a mod. May I refer you to the rules section:
    dBforums - Forum Guidelines

    Cheating does not get ignored, nor cheaters respected.
    i don't wish to argue anymore. Does anyone willing to help me out?

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by MarineX
    You will design and create of a database application for any type of organization.
    This assignment is so easy, I'm going to help you out despite Pootle's rudeness.

    Here you go:
    Code:
    CREATE TABLE Everything
    	(RecordID int NOT NULL PRIMARY KEY CLUSTERED,
    	AllData xml NULL)
    GO
    ALTER TABLE dbo.Everything ADD CONSTRAINT
    	DF_Everything_RecordID DEFAULT 1 FOR RecordID
    GO
    Assignment done. Ta-da!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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