The Student Room Group

Btec unit 2 databases exam

Now the real question is... should I care? But anyway, I had my Unit 2 exam today which was the real thing and gave me a scanerio about a catering company selling party goods. The ERD was tough but what is concerning me most is the report. I was asked to total something per supplier (how many large stock sizes each has) and used a report footer to do this, however, I put a COUNT function in and it was only counting how many products they had so I changed it to SUM but it returned all the values as negative numbers. Although I tried to justify it all in my evaluation (i.e using the techincal vocab), taking me to nearly a whole page, I still worry that I have lost so many marks in this thing. What happens if I fail this unit? Do I have to sacrifice BTEC IT altogether?

Reply 1

Original post
by x.jxson.ross.x
Now the real question is... should I care? But anyway, I had my Unit 2 exam today which was the real thing and gave me a scanerio about a catering company selling party goods. The ERD was tough but what is concerning me most is the report. I was asked to total something per supplier (how many large stock sizes each has) and used a report footer to do this, however, I put a COUNT function in and it was only counting how many products they had so I changed it to SUM but it returned all the values as negative numbers. Although I tried to justify it all in my evaluation (i.e using the techincal vocab), taking me to nearly a whole page, I still worry that I have lost so many marks in this thing. What happens if I fail this unit? Do I have to sacrifice BTEC IT altogether?
As long as you get 16 marks across all 2 parts you will be fine and get a pass

Reply 2

you're cooked g

Reply 3

Original post
by x.jxson.ross.x
Now the real question is... should I care? But anyway, I had my Unit 2 exam today which was the real thing and gave me a scanerio about a catering company selling party goods. The ERD was tough but what is concerning me most is the report. I was asked to total something per supplier (how many large stock sizes each has) and used a report footer to do this, however, I put a COUNT function in and it was only counting how many products they had so I changed it to SUM but it returned all the values as negative numbers. Although I tried to justify it all in my evaluation (i.e using the techincal vocab), taking me to nearly a whole page, I still worry that I have lost so many marks in this thing. What happens if I fail this unit? Do I have to sacrifice BTEC IT altogether?

icl you're mad cooked, cheesin fyam.

Reply 4

Original post
by CeoOfSarcasm07
As long as you get 16 marks across all 2 parts you will be fine and get a pass
Yes but the thing is I need to get a merit for a strong overall grade so I can apply for uni

Reply 5

Original post
by ZakBoss27
you're cooked g
I thought I did well but seeing you man saying were cooked now I’m a bit worried i can’t lie 😂

Reply 6

Original post
by x.jxson.ross.x
Yes but the thing is I need to get a merit for a strong overall grade so I can apply for uni

What overall grade are you looking to achieve?

Reply 7

Original post
by Noonelol
What overall grade are you looking to achieve?
A distinction at least, but I’ve been pulling out all the stops, and I will still do this, for a Distinction* when I finish next year. Am doing unit 1 (exam next January) and unit 6 (coursework).

Reply 8

Original post
by x.jxson.ross.x
A distinction at least, but I’ve been pulling out all the stops, and I will still do this, for a Distinction* when I finish next year. Am doing unit 1 (exam next January) and unit 6 (coursework).


Ohh, good luck

Unit 1 would be really enjoyable for you imo

Reply 9

Original post
by x.jxson.ross.x
Now the real question is... should I care? But anyway, I had my Unit 2 exam today which was the real thing and gave me a scanerio about a catering company selling party goods. The ERD was tough but what is concerning me most is the report. I was asked to total something per supplier (how many large stock sizes each has) and used a report footer to do this, however, I put a COUNT function in and it was only counting how many products they had so I changed it to SUM but it returned all the values as negative numbers. Although I tried to justify it all in my evaluation (i.e using the techincal vocab), taking me to nearly a whole page, I still worry that I have lost so many marks in this thing. What happens if I fail this unit? Do I have to sacrifice BTEC IT altogether?

I need help with database exam soon

Reply 10

Original post
by CeoOfSarcasm07
As long as you get 16 marks across all 2 parts you will be fine and get a pass

If I get for mock 26 I will get pass for real exam ?

Reply 11

Is 2026 exam hard database unit 2?

Reply 12

Original post
by x.jxson.ross.x
Now the real question is... should I care? But anyway, I had my Unit 2 exam today which was the real thing and gave me a scanerio about a catering company selling party goods. The ERD was tough but what is concerning me most is the report. I was asked to total something per supplier (how many large stock sizes each has) and used a report footer to do this, however, I put a COUNT function in and it was only counting how many products they had so I changed it to SUM but it returned all the values as negative numbers. Although I tried to justify it all in my evaluation (i.e using the techincal vocab), taking me to nearly a whole page, I still worry that I have lost so many marks in this thing. What happens if I fail this unit? Do I have to sacrifice BTEC IT altogether?


My advice is that get as much Distinction grades possible from the assignments it will be easy to get a Distinction but for exams I will say go for Merit or higher if you can, because I am on my last year (2) of the course and it is kinda intense.

Quick Reply

How The Student Room is moderated

To keep The Student Room safe for everyone, we moderate posts that are added to the site.