Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009

    Unanswered: Confusion over Tables for relationships

    Hi all,

    When i transfer my Relational schema to Access Database as tables do i have to make Tables for the Relashionships also?

    Customers (CID, Cname, CstAdd, Ccity, Cstate, Czip, Cph, Ce-mail)
    Orders (OID, Oamt, OrderDate, ShippingAdd)
    Flowers (FID, Fname, Fprice, Fdescription)
    PuchaseOrders (POID, POamt, shippingAddr, POdate)
    Supplier (SID, SName, SStAdd, Scity, Szip, Sstate, Sph)
    Place (CID, OID)
    OrderDetails (OID, FID, unitprice, Oqty )
    POrderdetail (FID, POID, Unitcost , POqty)
    Forwarded (POID, SID)

    Relationships are (Place, OrderDetails, POrderdtail, Forwareded)


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    create your tables
    then select tools | relationships
    define your realtionships using drag and drop
    make sure you select the correct properties (ie whether you want to enforce Referential Intergity (RI)... usually yes
    delete cascade and update cascade are up to you as designer, theres good reasons either way both for and against)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2009
    Thanks for the reply,

    well the question is if there is Customers (Entity) that Place(relationship) Orders(Entity). Then do i have to have Place(relationship) as a table in the Access database?
    Customers (Many)---> Place <---- (Many)Orders

    Or since "place" gets Keys from both tables "Customers" CID and "Order" OID. I just connect these two tables in Access like "you wrote above" and that would signify the "place" relationship without actually making a "place" table.

    Last edited by ChazMaster; 04-04-09 at 14:46.

  4. #4
    Join Date
    Mar 2009
    Maybe its the wrong forum for this question?

  5. #5
    Join Date
    Mar 2009
    Provided Answers: 14
    Right ChazMaster: it concerns more the general concepts of relational databases and normalization. see: The Relational Data Model, Normalisation and effective Database Design for instance.

    Have a nice day!

Posting Permissions

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