Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Posts
    7

    Unanswered: Help with building Entity relationship diagrams?

    Hi I am new here. I have to draw an erd, well I finished drawing it, just trying to figure out a few things. I'm not sure if this is the right place. Thanks. I'm not sure if this is the correct forum.. Thanks

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    I'm not sure anywhere is the correct forum, since you do not pose a question. If you look a little further down the list here on DBFORUMS there is a Database Concepts and Design board.

  3. #3
    Join Date
    Oct 2013
    Posts
    7

    Erd

    This is what I have to do, but thanks Ill post it in the other forums



    Draw the corresponding ERD for the following data structure:
    Products(ProID, Descrip, Cost, Price, CatID)
    People(ID, FName, LName, Phone)
    Clients(CID, CreditLimit)
    Employees(EID, DOH, DOB, SupervisorID)
    ClientAddress(CLID, CID, Street1, Street2, City, State, Zip)
    PriceHistory(PrID, ProductID, Price, StartDate, EndDate)
    InvDetail(InvNum, DetID, Qty, ProdID, UnitPrice, Discount)
    InvHeader(InvNum, Date, ClientID, CliAddrID, SalesPersonID, Memo)
    Categories(ID, Description)
    Underline stands for primary key
    Italic stands for Foreign key.

  4. #4
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    you still haven't posed a question as to what your problem is.
    I finished drawing it, just trying to figure out a few things.
    What few things?

  5. #5
    Join Date
    Oct 2013
    Posts
    7
    I went ahead and posted in the other forum like you suggested.

    I am trying to figure out, with the objects that contain a foreign key? Does that Object then and always indicate a many object?

    Are the primary keys in each object suppose to be connected, with the primary keys in other related object boxes?

Posting Permissions

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