Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jul 2004
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    relational database issue

    I have two tables, dept and std. Database specs:

    dept table:

    d_id
    d_loc
    d_name

    d_id: primary key
    data type: autonumber

    std table:

    s_ssn
    s_lastname
    s_firstname
    s_addr
    s_city
    s_zip
    s_state
    d_id

    s_ssn: primary key
    d_id: foreign key
    data type for d_id: autonumber
    data type for s_ssn: text

    As you see, I have dept's primary key connected to std's table as foreign key and formed the relationship between the tables.

    Can someone please tell whether whatever I have done so far is right? and If I want to query selecting fields from both tables, will it work? I am not sure whether my implemention is right? Please someone confirm. thanks.

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    it will work
    I am the luckiest man in the world


  •  

    Posting Permissions

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