var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CODASYL - Network Database
I need some Experts for CODASYL, a network database system.
Is somebody with a basic knowledge in here?
i used to have a pretty decent knowledge of idms
emphasis on past tense
what's the question?
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)
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>
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
if calls.software-id same as software.software-id
find owner within consultant-calls
print consultant name
find next within calls-software
or something like that
i'm guessing, because you didn't say what the sets were
thank you for that first answer,
tomorrow I try to put a Network Modell in here to show you the settypes and so on!