For the SQL question, did everyone get

SELECT FurnitureID, CustomerName, TelephoneNumber

From Furniture, Customer, CustomerOrderLine

WHERE FurnitureID = '01670' (or whatever the number was)

AND Furniture.FurnitureID = OrderLine.FurnitureID

ORDER BY CustomerName ASC

(edited 10 years ago)

Reply 243

moogoomonkey

Yeah I got the same for the traversal.

For the SQL I only SELECTED the CustomerName and TelephoneNumber.

Reply 244

moogoomonkey

And also I selected FROM, Customer, CustomerOrder and CustomerOrderLine

Reply 245

fizzbizz

For that 7 marker did everyone wrote in pseudocode or just English? It said write an algorithm for the steps required, no mention of pseudocode :/

Posted from TSR Mobile

Reply 246

moogoomonkey

Original post by fizzbizz

For that 7 marker did everyone wrote in pseudocode or just English? It said write an algorithm for the steps required, no mention of pseudocode :/

Posted from TSR Mobile

I wrote in pseudocode

Reply 247

Jcoope

I can't believe I wrote Prefix and Polish Notation instead of Postfix and Reverse Polish Notation. I thought this was the hardest Comp3 paper yet?

Reply 248

moogoomonkey

I'm not sure if it was the hardest but it definitely was different

Reply 249

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?

Reply 250

moogoomonkey

I put no, yes, yes, no. But I got the same for DAC. Can't remember which was which for algorithm but it was n, n^2 and a^n

Reply 251

I_Am_The_Man

Original post by JASApplications

I put Alter Table.

Reply 252

fizzbizz

Was the third line of the very first question Yes? I went through it twice and got Yes :/

Posted from TSR Mobile

Reply 253

JASApplications

Original post by moogoomonkey

I put no, yes, yes, no. But I got the same for DAC. Can't remember which was which for algorithm but it was n, n^2 and a^n

I don't think you could do the 3rd one because they sneakily put 'real' as the type when that wasn't in the options you could use.

Reply 254

fizzbizz

Original post by I_Am_The_Man

I put Alter Table.

This is right, I googled it :smile:

I put create field first then crossed it out and put this

Posted from TSR Mobile

Reply 255

Damask-

Original post by tomrobinson

I had this but with

AND Customer.CustomerID = Order.CustomerID

as well as the rest, and no speech marks around the number.

(edited 10 years ago)

Reply 256

CodeJack

Well, that didnt go well.

Reply 257

Jcoope

Original post by Damask-

I had this but with

AND Customer.CustomerID = Order.CustomerID

as well as the rest, and no speech marks around the number.

Yep that's exactly what I did.

Reply 258

JASApplications

Original post by Damask-

I had this but with

AND Customer.CustomerID = Order.CustomerID

as well as the rest

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

(edited 10 years ago)

Reply 259

JASApplications