Results 1 to 3 of 3

Thread: Help

  1. #1
    Join Date
    Jun 2012
    Posts
    11

    Help

    Hi, anyone knows how to draw admin entity? Or is it not supposed to be added in the er model? I created something like this

    Staff
    ^
    |
    |
    Admin

    Admin inherites the Staff. Staff have many attributes but Admin have none? Except it gets StaffID from Staff.
    So it will be

    Staff(StaffID, Name, ....)
    Admin(<StaffID>)

    And worst is Admin is linked to Product so that Admin can add, edit or remove product. But the er model is just a bit of odd...

    Staff
    ^
    |
    |
    Admin
    |
    | 1
    |
    | updates
    |
    | M
    |
    Product

    Is there anything wrong with this? And how do I grab the Admin attribute to put inside Product(ProductID, Name, ...)????
    Sorry I suck at this but can anyone guide me through this???
    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    So an admin is a staff member?
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    Jun 2012
    Posts
    11
    yeah. it inherits all attributes from staff.
    So is there any problem in the drawing? Cause I find it odd..

Posting Permissions

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