The Student Room Group

BTEC Level 3 IT Unit 2 Exam May 2024

How did everyone find the exam?

Scroll to see replies

Reply 1
Original post by undebrihe
How did everyone find the exam?

Did you create a composite key?
Original post by undebrihe
How did everyone find the exam?

Normalisation wasn’t that bad, queries were straight forward but I didn’t know how to do the format check.
Reply 3
Yeah i did a composite key between Product ID and Supplier ID.
Reply 4
Original post by undebrihe
Yeah i did a composite key between Product ID and Supplier ID.
Yesss
How many tables did you end up with?
Reply 6
Original post by CeoOfSarcasm07
How many tables did you end up with?

I ended up with 4, due to the different prices and each product having different amounts
Reply 7
Original post by AB.D26
I ended up with 4, due to the different prices and each product having different amounts

what were your relationships like?
Original post by AB.D26
I ended up with 4, due to the different prices and each product having different amounts

I had a composite key of suppliers and products, products and product categories were a one to many relationship with me
I messed it up so bad, ended up with 3 tables and spent like an hour and a half on relationships
Reply 10
The tables and queries were alright, but the report was confusing. Did any of you miss out on some activities?
Original post by AB.D26
The tables and queries were alright, but the report was confusing. Did any of you miss out on some activities?

The report was confusing. I missed out the large items calculation icl
Original post by undebrihe
How did everyone find the exam?

i only did 3 tables , couldn’t find the 4th . Activity 2,4,5 all done correctly thought . I’d be happy with a P at this point .
Original post by CeoOfSarcasm07
How many tables did you end up with?

1.

Table 1: Products

2.

Product ID (Primary Key)

3.

Product Description

4.

Product Category ID (Foreign Key)

5.

Table 2: Product Categories

6.

Product Category ID (Primary Key)

7.

Product Category

8.

Table 3: Suppliers

9.

Supplier ID (Primary Key)

10.

Supplier Name

11.

Supplier Email

12.

Table 4: Product Supplier

13.

Product ID (composite Key)

14.

Supplier ID (composite Key)

15.

Supplier Pack Size

16.

Purchase Price

17.

Days to Pay
Well i did everything except email validation because it was confusing for me, just the total large items in report. I dont know man if this exam was this simple or there's catch like 5 tables or something.

Original post by NateDaley
I messed it up so bad, ended up with 3 tables and spent like an hour and a half on relationships

I mean bro it was quite easy from my perspective. Everything was straightforward. it took me like 40 minutes to fill the data, relationship and some validation like table lookups and value lookup things. I saw a student who didnt even fill the structure testing and my friend told me that he didnt do structure testing and Evaluation. Bro lost 12 marks straight.
Original post by aryakunal

1.

Table 1: Products

2.

Product ID (Primary Key)

3.

Product Description

4.

Product Category ID (Foreign Key)

5.

Table 2: Product Categories

6.

Product Category ID (Primary Key)

7.

Product Category

8.

Table 3: Suppliers

9.

Supplier ID (Primary Key)

10.

Supplier Name

11.

Supplier Email

12.

Table 4: Product Supplier

13.

Product ID (composite Key)

14.

Supplier ID (composite Key)

15.

Supplier Pack Size

16.

Purchase Price

17.

Days to Pay
Well i did everything except email validation because it was confusing for me, just the total large items in report. I dont know man if this exam was this simple or there's catch like 5 tables or something.


Doesn’t days to pay go in supplier table?
Original post by CeoOfSarcasm07
Doesn’t days to pay go in supplier table?

Pray to god that they don't. Lmao
Original post by CeoOfSarcasm07
Doesn’t days to pay go in supplier table?

maybe i messed up a little but i just want merit. So please dont point out my mistakes or else i have to take rebirth or regress.
Original post by aryakunal
I mean bro it was quite easy from my perspective. Everything was straightforward. it took me like 40 minutes to fill the data, relationship and some validation like table lookups and value lookup things. I saw a student who didnt even fill the structure testing and my friend told me that he didnt do structure testing and Evaluation. Bro lost 12 marks straight.
even if you did 3 tables like i did , the validation, testing and evaluation is still the same in terms of marks you still get them but you’ll lose the 6 marks for activity one, am i correct?
Original post by aryakunal
Pray to god that they don't. Lmao

Am only saying tha cuz there were 3 differente suppliers and 3 different days to pay and each supplier had a particular value for days to pay

Quick Reply

Latest

Trending

Trending