Join TSR now and get all your revision questions answeredSign up now
    Offline

    1
    ReputationRep:
    My query was:

    SELECT CustomerName, TelephoneNumber

    FROM Customer, CustomerOrderLine, CustomerOrder

    WHERE FurnitureID = '01670' (or whatever the number was)
    AND Customer.CustomerID = CustomerOrder.CustomerID
    AND CustomerOrder.OrderID = CustomerOrderLine.OrderID

    ORDER BY CustomerName
    Offline

    0
    ReputationRep:
    This paper seemed a completely different style from the others apart from that obligatory network question; hated it!
    Offline

    0
    ReputationRep:
    (Original post by JASApplications)
    For the first question, was it: no, yes, no, no

    Then I think there was DAC for the questions of real numbers and CBA for order of algorithm efficiency?

    Also what did you put for the very last question? The middle box?
    Something like that, but I just wrote o(n) in the orders.
    Offline

    0
    ReputationRep:
    (Original post by moogoomonkey)
    My query was:

    SELECT CustomerName, TelephoneNumber

    FROM Customer, CustomerOrderLine, CustomerOrder

    WHERE FurnitureID = '01670' (or whatever the number was)
    AND Customer.CustomerID = CustomerOrder.CustomerID
    AND CustomerOrder.OrderID = CustomerOrderLine.OrderID

    ORDER BY CustomerName
    I got the exact same as you !
    Offline

    1
    ReputationRep:
    I put:

    SELECT CustomerName, TelephoneNumber

    FROM Customer, CustomerOrderLine, CustomerOrder

    WHERE CustomerOrderLine.FurnitureID = '61701'

    AND CustomerOrderLine.OrderID = CustomerOrder.OrderID

    AND CustomerOrder.CustomerID = Customer.CustomerID

    ORDER BY CustomerName ASC


    I didn't see a need to access the furniture relation


    Posted from TSR Mobile
    Offline

    0
    ReputationRep:
    (Original post by NightStrider)
    Same here
    Damn I crossed that out and put 46*9+
    Offline

    0
    ReputationRep:
    (Original post by JASApplications)
    For the ERD, what relationships did you get?

    I think I got 3 one-many but can't remember where they were to.
    I think I got a customer has many furniture, an order has many furniture and a customer has many orders.
    Offline

    0
    ReputationRep:
    (Original post by fizzbizz)
    I put:

    SELECT CustomerName, TelephoneNumber

    FROM Customer, CustomerOrderLine, CustomerOrder

    WHERE CustomerOrderLine.FurnitureID = '61701'

    AND CustomerOrderLine.OrderID = CustomerOrder.OrderID

    AND CustomerOrder.CustomerID = Customer.CustomerID

    AND CustomerOrder.OrderID = CustomerOrderLine.OrderID

    ORDER BY CustomerName ASC


    I didn't see a need to access the furniture relation


    Posted from TSR Mobile
    That is what I put except your duplication at the end, but I put DESC for some strange reason...
    Offline

    0
    ReputationRep:
    (Original post by JASApplications)
    For the first question, was it: no, yes, no, no

    Then I think there was DAC for the questions of real numbers and CBA for order of algorithm efficiency?

    Also what did you put for the very last question? The middle box?
    Yeah i got that, I think it was the top box however?
    Offline

    0
    ReputationRep:
    What algorithm did you people put?

    I did something like.

    CurrentPointer = 2;
    previousPointer =1;
    while list[currentPointer]>normal
    currentPointer++;
    previousPointer++;
    end while
    list[previousPointer].pointer=pointerOfDatabase
    list[pointerOfDatabase].pointer=currentPointer.


    This works because it said that you assume there is already one of each priority.
    Offline

    0
    ReputationRep:
    (Original post by ollyhal)
    Yeah i got that, I think it was the top box however?
    That's what other people are saying so it probably is the top box. I just had a guess cos I didn't have a clue!
    Offline

    1
    ReputationRep:
    (Original post by I_Am_The_Man)
    That is what I put except your duplication at the end, but I put DESC for some strange reason...
    Oops yeah my bad


    Posted from TSR Mobile
    Offline

    0
    ReputationRep:
    (Original post by ollyhal)
    Yeah i got that, I think it was the top box however?
    Oh god I put the last box!
    Offline

    0
    ReputationRep:
    Also for my algorithm I got something like this:

    CurrentPointer = StartPointer

    While Memory[CurrentPointer].Priority >= "Medium"
    PreviousPointer = CurrentPointer
    CurrentPointer = Memory[CurrentPointer].Pointer
    End While

    NewItem.Pointer = CurrentPointer
    Memory[PreviousPointer].Pointer = NewItem


    Did anyone get anything similar?

    EDIT: It should be >= not =>.
    Offline

    0
    ReputationRep:
    (Original post by I_Am_The_Man)
    Also for my algorithm I got something like this:

    CurrentPointer = StartPointer

    While Memory[CurrentPointer].Priority => "Medium"
    PreviousPointer = CurrentPointer
    CurrentPointer = Memory[CurrentPointer].Pointer
    End While

    NewItem.Pointer = CurrentPointer
    Memory[PreviousPointer].Pointer = NewItem


    Did anyone get anything similar?
    I got something similar, but I incremented the values. Meaning I got that wrong.
    Offline

    0
    ReputationRep:
    (Original post by NightStrider)
    I got something similar, but I incremented the values. Meaning I got that wrong.
    I wouldn't be so sure, because I was thinking of it in terms of RAM.
    Offline

    0
    ReputationRep:
    (Original post by JASApplications)
    I put:

    SELECT CustomerName, TelephoneNumber

    FROM Furniture, Customer, CustomerOrderLine, CustomerOrder

    WHERE FurnitureID = '01670' (or whatever the number was)
    AND Furniture.FurnitureID = OrderLine.FurnitureID
    AND Customer.CustomerID = Order.CustomerID
    AND CustomerOrder.OrderID = CustomerOrderLine.OrderID

    ORDER BY CustomerName ALPHABETICAL
    Two things, not sure whether they'd pick up on it though:

    The number shouldn't be within quotes.

    ALPHABETICAL should be ASC.
    Offline

    0
    ReputationRep:
    (Original post by I_Am_The_Man)
    I wouldn't be so sure, because I was thinking of it in terms of RAM.
    But it is a linked list - not a linear list. That means that the pointers are not linear incremented.
    Offline

    0
    ReputationRep:
    Code:
    Do
    i= i + 1
    CurrentNodePointer = i
    PreviousNodePointer = i - 1
    Loop Until Priority(i) = "Normal"
    
    For i = CurrentNodePointer to EndNodePointer
    Pointer(i) = Pointer(i) + 1
    Next
    
    Process(CurrentNodePointer) = "Database"
    Priority(CurrentNodePointer) = "Normal"
    Pointer(CurrentNodePointer) = CurrentNodePointer + 1
    I assumed the Process, Priority and Pointer were stored in arrays but that assumption is probably wrong!
    I also thought you were supposed to add the item at the beginning of the 'Normal' items rather than at the end which is apparently wrong!
    Offline

    0
    ReputationRep:
    (Original post by I_Am_The_Man)
    Also for my algorithm I got something like this:

    CurrentPointer = StartPointer

    While Memory[CurrentPointer].Priority => "Medium"
    PreviousPointer = CurrentPointer
    CurrentPointer = Memory[CurrentPointer].Pointer
    End While

    NewItem.Pointer = CurrentPointer
    Memory[PreviousPointer].Pointer = NewItem


    Did anyone get anything similar?
    Almost Word for word what I wrote apart from I used Node[] instead of Memory[] and I used Do Until Node[CurrentPointer] = Low to find the first low priority one
 
 
 
Poll
Which Fantasy Franchise is the best?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Quick reply
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.