Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2013
    Posts
    3

    Unanswered: anyone here can help me :(

    Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel' main entities are its customers, employees, projects and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment however, is assigned to only one project at a time

    1. Identify the entities
    2. Find relationships
    3. Draw rough ERD
    4. Fill in cardinalities
    5. Define primary keys
    6. Draw key-based ERD
    7. Identify attributes
    8. Map attributes
    9. Draw fully attributed ERD
    10. Check results

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It wouldn't be right to deny you the experience of doing your own homework assignment.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2013
    Posts
    3
    just in no.2 can you help me sir?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by akosimelbs View Post
    just in no.2 can you help me sir?
    A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment however, is assigned to only one project at a time.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by akosimelbs View Post
    just in no.2 can you help me sir?
    I'll be glad to help... Which relationships have you identified? What questions do you have about them?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Nov 2013
    Posts
    3
    Click image for larger version. 

Name:	untitled.JPG 
Views:	10 
Size:	22.2 KB 
ID:	14899

    this is correct?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Customers hire the Pick and Shovel Construction Company, not the employees of the company.

    Relationships are further defined as:
    • one to one
    • one to many
    • many to many

    and each of these may be defined as mandatory or optional
    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
  •