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.

Reply 14

aryakunal

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.

Reply 15

CeoOfSarcasm07

6

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?

Reply 16

aryakunal

Original post by CeoOfSarcasm07

Doesn’t days to pay go in supplier table?

Pray to god that they don't. Lmao

Reply 17

aryakunal

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.

Reply 18

habibYousuf

1

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?

Reply 19

CeoOfSarcasm07

6

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

BTEC Level 3 IT Unit 2 Exam May 2024

Quick Reply

Related discussions

Articles for you