The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

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

Scroll to see replies

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 :smile: and last one for me!!!! Wbu?
Reply 21
Avatar for Wanonawa
Wanonawa
Original post by RedRum99
Those always come up so easy marks :smile: 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.
Reply 22
Avatar for Illumium
Illumium
Good luck everyone :biggrin:
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 :':wink:
Anyways good luck for tomorrow, hope it goes well for you!
(edited 7 years ago)
Reply 24
Avatar for Wanonawa
Wanonawa
Original post by RedRum99
Well you're almost there and I already bailed out of those two last year haha :':wink:
Anyways good luck for tomorrow, hope it goes well for you!


Heh, true.
And thanks, likewise! :smile:
Reply 25
Avatar for Wanonawa
Wanonawa
Original post by Illumium
Good luck everyone :biggrin:


Thanks, you too!
Jesus this thread is small. I expected a lot more people on here for some reason.
What did everyone end up with on the Turning machine?
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?
SELECT OrderDate? , Postcode? , Something else
FROM PriceBand, Parcel
WHERE Parcel.CustomerId= 104
ORDERBY Orderdate descending
Normalised table:

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

Not sure though..
How was the pseudocode question?
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.:biggrin:
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.:biggrin:


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.
Original post by 1TrueMeaning
Normalised table:

ParcelDelivery(PrimaryKey(postcode), 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)
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.:biggrin:


The question also specifically asked for certain details im sure name etc wasnt there i clearly remember three bold words.
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
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..
(edited 7 years ago)
Did everyone get -1344 or something like that for the floating point question?
(edited 7 years ago)
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.

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you