BTEC IT Unit 2 January 2024 exam discussion

i put all 3 in but it didnt make sense

Reply 9

OP

Original post by dddd222

i put all 3 in but it didnt make sense

Wdym put all three as in in different tables/entities or you put it all in one

Reply 10

OP

Remember the foreign key moves to the many side of the erd

Reply 11

dddd222

Original post by Unknownaspriv

Remember the foreign key moves to the many side of the erd

Bascially the answer was : Suppliersid, RosesId, RosesTypeid, ExpertTypeId in 1 table nd link w other tables did u do that

Reply 12

OP

Original post by dddd222

Bascially the answer was : Suppliersid, RosesId, RosesTypeid, ExpertTypeId in 1 table nd link w other tables did u do that

Yes but the queries and report screwed me over how did u find those? Queries b was off throwing

Reply 13

the exam didnt go well for me. i only did activity 1 and two. also supplier's id, expert id and some other ids are in the roses table [ my relationships] . i think the exam was hard[could be wrong]. i used 2019's paper as a walkthrough and also watched a lot of vids on the exam and also i completely forgot the checks [ my fault ]. maybe i was burnt out idk. had problems with the second query. i spent too much time trying to perfect my normalised table i forgot about time until it was too late. compared to this exam , the 2019 and other videos i watched on database didnt seem this hard.

Reply 14

OP

Original post by Soap029

the exam didnt go well for me. i only did activity 1 and two. also supplier's id, expert id and some other ids are in the roses table [ my relationships] . i think the exam was hard[could be wrong]. i used 2019's paper as a walkthrough and also watched a lot of vids on the exam and also i completely forgot the checks [ my fault ]. maybe i was burnt out idk. had problems with the second query. i spent too much time trying to perfect my normalised table i forgot about time until it was too late. compared to this exam , the 2019 and other videos i watched on database didnt seem this hard.

I agree with you. I watched walkthroughs from 2019 to 2023 and the queries seemed logical or at least somewhat figural. Query B threw me off and the erd i spent quite some time on. You can still gain marks for tomorrow’s paper, viewing last years grade boundaries you’re well on track for merit

Reply 15

Original post by Unknownaspriv

I agree with you. I watched walkthroughs from 2019 to 2023 and the queries seemed logical or at least somewhat figural. Query B threw me off and the erd i spent quite some time on. You can still gain marks for tomorrow’s paper, viewing last years grade boundaries you’re well on track for merit

not sure about that bro but thanks for the uplifting message. keep in mind i only did activity 1 and 2 [ skipped checks and a few stuff]. i think a pass is more realistic at this point. btw did u find the whole exam hard or just the queries difficult. i actually stopped at query a. no more time and also i forgot some of the commands or stuff you might need in the harder queries or smth. i was also panicking about time [ spent too much time on normalisation and activity 1 ]

(edited 3 months ago)

Reply 16

OP

Original post by Soap029

not sure about that bro but thanks for the uplifting message. keep in mind i only did activity 1 and 2 [ skipped checks and a few stuff]. i think a pass is more realistic at this point. btw did u find the whole exam hard or just the queries difficult.

Report and queries for me was hard, entering the data in tables and assigning data types was fine as well as creating the relationships although my erd took some time. I made some silly mistakes and figured that out when testing. For reports i just simply added the names they wanted for display i nearly ran out of time. I personally need a merit but i think i’ll get a pass honestly

Reply 17

everything was hard 💀🤮

Reply 18

OP

Original post by Soap029

everything was hard 💀🤮

U ready for paper B tmr? Idk anything for it i wish the exam wasn’t in the morning 😒

Reply 19