Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Posts
    5

    Unanswered: CODASYL - Network Database

    Hi,

    I need some Experts for CODASYL, a network database system.

    Is somebody with a basic knowledge in here?


    Best Regards.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i used to have a pretty decent knowledge of idms

    emphasis on past tense

    what's the question?

    rudy
    http://rudy.ca/

  3. #3
    Join Date
    Apr 2002
    Posts
    5
    yeah, cool

    I hope you can help me.

    For testing a university test in germany i have to do the folowing task:



    Design the following Query with CODASYL-DML:

    "Which Consultant (Name) has done Calls abaout a special Software (string "Windows2000")?"

    on the following relational Database:

    Consultant(Id, Name, PhoneNumber, Address)
    Client (Id, Name, Phonenumber, Account)
    Calls(Client-Id, Consultant-Id, Software-Id, Day, Time)
    Software(Number, Description)
    Requires_Software(Number-1, Number-2)

    But we only can use the following CODASLYL Statements:

    FIND ANY <Record name> USING <Key Name>
    FIND FIRST <Record name> WITHIN <Set name>
    FIND NEXT <Record name> WITHIN <Set name>
    FIND LAST <Record name> WITHIN <Set name>
    FIND OWNER WITHIN <Set name>
    FIND CURRENT <Record name> [WITHIN <Set name>]
    GET <Record name>
    STORE <Record name>


    Thank you.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i don't have FIND ANY in the book i'm looking at -- presumably that's how you find the Software record for Windows2000? i'm not sure, but you have to find that record first

    then find owner within calls-software

    loop
    if calls.software-id same as software.software-id
    find owner within consultant-calls
    print consultant name
    endif
    find next within calls-software
    endloop

    or something like that

    i'm guessing, because you didn't say what the sets were

    rudy

  5. #5
    Join Date
    Apr 2002
    Posts
    5
    thank you for that first answer,

    tomorrow I try to put a Network Modell in here to show you the settypes and so on!

Posting Permissions

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