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

AQA Computing COMP 3- 22nd June 2016 [Exam Discussion]

Announcements
    Offline

    2
    ReputationRep:
    (Original post by Wanonawa)
    I know right? Those are the nicest questions.
    And ugh, me too. There is definitely going to be at least one question with it, let's just hope it's not more than that ._.

    How many exams do you have left after COMP3?
    Those always come up so easy marks and last one for me!!!! Wbu?
    Offline

    0
    ReputationRep:
    (Original post by RedRum99)
    Those always come up so easy marks and last one for me!!!! Wbu?
    Woohoo, that's awesome! Summer is pretty close then eh?

    I still have two more after this - Economics and Maths.
    Offline

    0
    ReputationRep:
    Good luck everyone
    Offline

    2
    ReputationRep:
    (Original post by Wanonawa)
    Woohoo, that's awesome! Summer is pretty close then eh?

    I still have two more after this - Economics and Maths.
    Well you're almost there and I already bailed out of those two last year haha :'
    Anyways good luck for tomorrow, hope it goes well for you!
    Offline

    0
    ReputationRep:
    (Original post by RedRum99)
    Well you're almost there and I already bailed out of those two last year haha :'
    Anyways good luck for tomorrow, hope it goes well for you!
    Heh, true.
    And thanks, likewise!
    Offline

    0
    ReputationRep:
    (Original post by Illumium)
    Good luck everyone
    Thanks, you too!
    Offline

    3
    ReputationRep:
    Jesus this thread is small. I expected a lot more people on here for some reason.
    Offline

    2
    ReputationRep:
    What did everyone end up with on the Turning machine?
    Offline

    3
    ReputationRep:
    (Original post by 1TrueMeaning)
    What did everyone end up with on the Turning machine?
    01 it reversed the string

    what was your query and normalised tables?
    Offline

    2
    ReputationRep:
    SELECT OrderDate? , Postcode? , Something else
    FROM PriceBand, Parcel
    WHERE Parcel.CustomerId= 104
    ORDERBY Orderdate descending
    Offline

    2
    ReputationRep:
    Normalised table:

    ParcelDelivery(PrimaryKey(postco de), Street, Town, County) Then removed the street name etc. from parcel and just left postcode

    Not sure though..
    Offline

    2
    ReputationRep:
    (Original post by 1TrueMeaning)
    SELECT OrderDate? , Postcode? , Something else
    FROM PriceBand, Parcel
    WHERE Parcel.CustomerId= 104
    ORDERBY Orderdate descending
    You also need to select FirstName and Surname ,
    From Customer also,
    also need another condition. Where Customer.ID = Parcel.ID and Customer.ID = 104
    also its Ascending not descending.
    Offline

    2
    ReputationRep:
    How was the pseudocode question?
    Offline

    2
    ReputationRep:
    (Original post by KnightCode)
    You also need to select FirstName and Surname ,
    From Customer also,
    also need another condition. Where Customer.ID = Parcel.ID and Customer.ID = 104
    also its Ascending not descending.
    Why would you need another condition? You can just check to see if the customer ID was in the parcel table. I did that because i saw it in a past paper like that.
    Offline

    2
    ReputationRep:
    (Original post by 1TrueMeaning)
    Normalised table:

    ParcelDelivery(PrimaryKey(postco de), Street, Town, County) Then removed the street name etc. from parcel and just left postcode

    Not sure though..
    I replaced Street, Town, Country with AddressID in Parcel
    then made a new table
    Address ( AddressID (Underlined), Street, Town, Country)
    Offline

    2
    ReputationRep:
    (Original post by KnightCode)
    You also need to select FirstName and Surname ,
    From Customer also,
    also need another condition. Where Customer.ID = Parcel.ID and Customer.ID = 104
    also its Ascending not descending.
    The question also specifically asked for certain details im sure name etc wasnt there i clearly remember three bold words.
    Offline

    2
    ReputationRep:
    (Original post by 1TrueMeaning)
    Why would you need another condition? You can just check to see if the customer ID was in the parcel table. I did that because i saw it in a past paper like that.
    to get the customer's details. Even though it didn't state it, the parcel delivery needs to know the name and surname of the person their delivering to, not just their ID
    Offline

    2
    ReputationRep:
    (Original post by KnightCode)
    to get the customer's details. Even though it didn't state it, the parcel delivery needs to know the name and surname of the person their delivering to, not just their ID
    The question said no other details... just those in bold and names were not included..
    Offline

    2
    ReputationRep:
    Did everyone get -1344 or something like that for the floating point question?
    Offline

    1
    ReputationRep:
    Why would you need the name of the person delivering to? The question is about parcels ordered by a specific customer, and it stated no extra details needed.
 
 
 
Poll
Do you have exam superstitions?

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.