This discussion is closed.
Matt Hamer
Badges:
#1
Report 17 years ago
#1
Ello

Well, what did you think of this one then? Particulalry that crappy mail-merge question and working
out the fields in the last question.

Im sure there was an error in the data requirement things; it said somet like "the customer gives an
order number", surely the order number will be determined by a record number or similar - you dont
phone up a shop and say "oooh can i be order number 23784923 pretty please with sugar on top??".

OK apart from that tho I spose.

-djmatt
0
Seamus
Badges:
#2
Report 17 years ago
#2
"Matt Hamer" <[email protected]> wrote in message
news:[email protected]...
[q1]> Ello[/q1]
[q1]>[/q1]
[q1]> Well, what did you think of this one then? Particulalry that crappy mail-merge question and[/q1]
[q1]> working out the fields in the last question.[/q1]
[q1]>[/q1]
[q1]> Im sure there was an error in the data requirement things; it said somet like "the customer gives[/q1]
[q1]> an order number", surely the order number will be determined by a record number or similar - you[/q1]
[q1]> dont phone up a shop and[/q1]
say
[q1]> "oooh can i be order number 23784923 pretty please with sugar on top??".[/q1]

That's what I though surly you don't request your own order number, I felt the biometrics question
was a bit vague and so did the teacher at my school

Seamus
0
Brackets
Badges:
#3
Report 17 years ago
#3
"Matt Hamer" <[email protected]> wrote in message
news:[email protected]...

[q1]> Im sure there was an error in the data requirement things; it said somet like "the customer gives[/q1]
[q1]> an order number", surely the order number will be determined by a record number or similar - you[/q1]
[q1]> dont phone up a shop and[/q1]
say
[q1]> "oooh can i be order number 23784923 pretty please with sugar on top??".[/q1]

Don't argos work on a system like that?

I had Edexcel units 5 and 6 today. Anyone else? I thought the first exam was fairly ok, whereas the
second one contained many questions I wasn't too sure on. Whats hypermedia? I even looked it up in
our textbooks, and it just says something like "A system of data in a computer e.g. video, audio".
Not too helpful.

--
Alex Studders Greggers Brackets
0
Waynio
Badges:
#4
Report 17 years ago
#4
[q1]> Im sure there was an error in the data requirement things; it said somet like "the customer gives[/q1]
[q1]> an order number", surely the order number will be determined by a record number or similar - you[/q1]
[q1]> dont phone up a shop and[/q1]
say
[q1]> "oooh can i be order number 23784923 pretty please with sugar on top??".[/q1]

I thought it was just a reference for the customer's own benefit.

They use the same sort of system at Dabs, you identify an order with an identifier such as 'new pc'
or 'graphics card' just so that you can refer to your own orders. That was why they mentioned that
different customers could have the same Order ID.

As for the two papers, Unit 4 was super, lots of technical stuff, interesting, whereas Unit 5 was
again boring - with stupid questions!

--
Waynio
0
Nk
Badges:
#5
Report 17 years ago
#5
"Matt Hamer" <[email protected]> wrote in message
news:<[email protected]>...
[q1]> Ello[/q1]
[q1]>[/q1]
[q1]> Well, what did you think of this one then? Particulalry that crappy mail-merge question and[/q1]
[q1]> working out the fields in the last question.[/q1]
[q1]>[/q1]
[q1]> Im sure there was an error in the data requirement things; it said somet like "the customer[/q1]
[q1]> gives an order number", surely the order number will be determined by a record number or similar[/q1]
[q1]> - you dont phone up a shop and say "oooh can i be order number 23784923 pretty please with sugar[/q1]
[q1]> on top??".[/q1]
[q1]>[/q1]
[q1]> OK apart from that tho I spose.[/q1]
[q1]>[/q1]
[q1]> -djmatt[/q1]

It wasn't too bad..but, as usual, very vague - esp. the questions about the passport. Explaining the
techniques was easy but IMHO the other parts of the question were too general.

I think the last question was a tricky one. How did u tackle the SQL statement? I did it by running
two seperate statements - first on the order table, and then on the customer table.

btw : what did u get for module 6?
0
Adam Atkinson
Badges:
#6
Report 17 years ago
#6
On 17-Jun-02 15:59:07, Matt Hamer said:

[q1]>Im sure there was an error in the data requirement things; it said somet like "the customer[/q1]
[q1]>gives an order number", surely the order number will be determined by a record number or similar[/q1]
[q1]>- you dont phone up a shop and say "oooh can i be order number 23784923 pretty please with sugar[/q1]
[q1]>on top??".[/q1]

Businesses who order things often give things their own order numbers.

One of my summer jobs one year was matching up invoices with purchase orders. This was so the
company didn't pay invoices for things it hadn't ordered. People _do_ send invoices to companies on
the off chance they'll pay them without checking. Obviously, the incoming invoices say which order
number they correspond to.

If I as a business ordered 20 thousand widgets from a manufacturer I'd probably tell the
manufacturer to quote my order number 2346 on all correspondence about it. The manufacturer might
_also_ give the thing a number, in which case we might both have to quote both numbers on all
correspondence.

--
Adam Atkinson ([email protected]) Only some kind of a numbskull thinks he knows things about
things he knows nothing about. (Amy Archer)
0
Matt Hamer
Badges:
#7
Report 17 years ago
#7
[q2]> > "oooh can i be order number 23784923 pretty please with sugar on top??".[/q2]
[q1]>[/q1]
[q1]> Don't argos work on a system like that?[/q1]

nah - you give em a product number not an order number...your order number is the one they give ya
to queue up for innit, "order 142 is now ready for collection"

-djmatt
0
Seamus
Badges:
#8
Report 17 years ago
#8
"Waynio" <[email protected]> wrote in message
news:v%[email protected]...
[q2]> > Im sure there was an error in the data requirement things; it said somet like "the customer[/q2]
[q2]> > gives an order number", surely the order number will[/q2]
be
[q2]> > determined by a record number or similar - you dont phone up a shop and[/q2]
[q1]> say[/q1]
[q2]> > "oooh can i be order number 23784923 pretty please with sugar on top??".[/q2]
[q1]>[/q1]
[q1]> I thought it was just a reference for the customer's own benefit.[/q1]
[q1]>[/q1]
[q1]> They use the same sort of system at Dabs, you identify an order with an identifier such as 'new[/q1]
[q1]> pc' or 'graphics card' just so that you can refer[/q1]
to
[q1]> your own orders. That was why they mentioned that different customers[/q1]
could
[q1]> have the same Order ID.[/q1]
[q1]>[/q1]
[q1]> As for the two papers, Unit 4 was super, lots of technical stuff, interesting, whereas Unit 5 was[/q1]
[q1]> again boring - with stupid questions![/q1]

I liked paper 4 apart from the machine code question any, which way did any one else do it.

Seamus
0
Matt Hamer
Badges:
#9
Report 17 years ago
#9
[q1]> I thought it was just a reference for the customer's own benefit.[/q1]
[q1]>[/q1]
[q1]> They use the same sort of system at Dabs, you identify an order with an[/q1]

ahh - **** . that makes sense. the paper didnt word it well though i dont think. i reread it so many
times. it seemed half of it implied relational and half implied flat file, which i found very weird.

so it's kinda like reference names that you can use when you pay bills with online banking? that
sorta thing.

[q1]> As for the two papers, Unit 4 was super, lots of technical stuff, interesting, whereas Unit 5 was[/q1]
[q1]> again boring - with stupid questions![/q1]
too right. 4 was good. i did that in Jan and got an A , woohoo!

-djmatt
0
Matt Hamer
Badges:
#10
Report 17 years ago
#10
ello

[q1]> It wasn't too bad..but, as usual, very vague - esp. the questions about the passport. Explaining[/q1]
[q1]> the techniques was easy but IMHO the other parts of the question were too general.[/q1]
yea it was a bit weird werent it. wonder what the mark scheme says.

luckily i had experience with the SQL before on me website, so I knew how to do it; you dont need to
seperate queries.

SELECT Customer.CustName, Order.Despatched FROM Customer, Order WHERE Order.Despatched = True

but I think i screwed up the ordernumber ascending sort so i'll leave that out. i wrote ORDER BY
ABCOrderNo Asc; but i dont think that on its own would work.

i reckon they might give the marks tho for two seperate queries. mark schemes are weird these days.

-djmatt
0
Seamus
Badges:
#11
Report 17 years ago
#11
"Matt Hamer" <[email protected]> wrote in message
news:[email protected]...
[q1]> ello[/q1]
[q1]>[/q1]
[q2]> > It wasn't too bad..but, as usual, very vague - esp. the questions about the passport. Explaining[/q2]
[q2]> > the techniques was easy but IMHO the other parts of the question were too general.[/q2]
[q1]> yea it was a bit weird werent it. wonder what the mark scheme says.[/q1]
[q1]>[/q1]
[q1]> luckily i had experience with the SQL before on me website, so I knew how[/q1]
to
[q1]> do it; you dont need to seperate queries.[/q1]
[q1]>[/q1]
[q1]> SELECT Customer.CustName, Order.Despatched FROM Customer, Order WHERE Order.Despatched = True[/q1]
[q1]>[/q1]
[q1]> but I think i screwed up the ordernumber ascending sort so i'll leave that out. i wrote ORDER BY[/q1]
[q1]> ABCOrderNo Asc; but i dont think that on its own[/q1]
would
[q1]> work.[/q1]

I put SELECT customer.custname FROM customer, order WHERE order.dispatched = yes ORDER BY
order.abcorderNo

as they didn't as for the field dispatched to be returned just names of people whose orders had been
dispatched

seamus
0
Arkan
Badges:
#12
Report 17 years ago
#12
"Matt Hamer" <[email protected]> wrote in message
news:[email protected]...

[q1]> luckily i had experience with the SQL before on me website, so I knew how[/q1]
to
[q1]> do it; you dont need to seperate queries.[/q1]
[q1]>[/q1]
[q1]> SELECT Customer.CustName, Order.Despatched FROM Customer, Order WHERE Order.Despatched = True[/q1]
[q1]>[/q1]

hey, didnt the info about the database not say that the order despacted status (yes or not) is NOT
stored in the database? I therefore assumed ALL entries in the order database were dispatched.

What did everyone do for the data flow diagram? for the first procecss box i did "get book id"
second: "calculate fine" and the storage box was the library database.

I just so need an A in this module, but i am seeing many hole's in my performance! Ive easy got an A
overall for the entire A-level but my uni wants A in A2 @#|@&%[email protected]%!!!
0
Matt Hamer
Badges:
#13
Report 17 years ago
#13
[q1]> I put SELECT customer.custname FROM customer, order WHERE order.dispatched[/q1]
=
[q1]> yes ORDER BY order.abcorderNo[/q1]
[q1]>[/q1]
[q1]> as they didn't as for the field dispatched to be returned just names of people whose orders had[/q1]
[q1]> been dispatched[/q1]

aye that sounds spot on to me actually -djmatt
0
Matt Hamer
Badges:
#14
Report 17 years ago
#14
[q1]> Businesses who order things often give things their own order numbers.[/q1]
[q1]>[/q1]
[q1]> One of my summer jobs one year was matching up invoices with purchase orders.[/q1]

that also make sense as well. wish theyd have worded the question better, d'oh!

-djmatt
0
Matt Hamer
Badges:
#15
Report 17 years ago
#15
[q1]> hey, didnt the info about the database not say that the order despacted status (yes or not) is NOT[/q1]
[q1]> stored in the database? I therefore assumed ALL entries in the order database were dispatched.[/q1]

hrmm, im pretty sure it said it did need to store if it was despatched or not.

[q1]> What did everyone do for the data flow diagram? for the first procecss box[/q1]
i
[q1]> did "get book id" second: "calculate fine" and the storage box was the library database.[/q1]

i put "scan book" , "calc fine", and "library database", but you needed to draw on the arrows to. it
was a 5 mark question. on the arrow goin from library db to calc fine , i wrote "date due back" and
i cant remember whati wrote on the one from "scan book" --> "calc fine".

[q1]> I just so need an A in this module, but i am seeing many hole's in my performance![/q1]

ditto! i have to get an A for me points cos im ****e at me other subjects. I got A's in all CPT1, 2
and 4, and a D in coursework , module 3, whoops! A is still doable tho i think!

-djmatt
0
Dr_deranged
Badges:
#16
Report 17 years ago
#16
What did everyone put for the assembly language question on unit 4? i just continually used the CMP
function to compare the different numbers but had no idea on the format.
0
Rtype
Badges:
#17
Report 17 years ago
#17
god i hope we don't lose marks for using INNER JOIN in that last SQL question.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1
Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
0
moi
Badges:
#18
Report 17 years ago
#18
that was the biggest wake up call of my life cos i cudnt answer ONE question in full
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Had lockdown impacted your relationships?

Yes, my partner and I are struggling (17)
7.83%
Yes, my partner and I broke up (14)
6.45%
Yes, it's hard being around my family so much (45)
20.74%
Yes, I'm feeling lonely isolating alone (28)
12.9%
No, nothing has changed (73)
33.64%
No, it's helped improve my relationships (40)
18.43%

Watched Threads

View All