BTEC Level 3 IT Unit 2 databases jan 2025
Anyone else struggling with Unit 2 and just realising they know barely anything with the exam on Tues/Wed?
(edited 10 months ago)
Scroll to see replies
Reply 1
Original post
by Anonymous43.Anyone else struggling with Unit 2 and just realising they know barely anything with the exam on Tues/Wed?
yes😭 my Chromebook dont even have MS access so idk wat to do I barely knw anythin i dont understand databses🥲
Reply 2
5
How did everyone find Part A?
Reply 3
Original post
by Anonymous43.Anyone else struggling with Unit 2 and just realising they know barely anything with the exam on Tues/Wed?
I was struggling how to start it off and how tables are arranged but as soon as i got it i was able to do the relationships and queries.
Reply 4
Original post
by Anonymous43.How did everyone find Part A?
Me and my friend found it easy but some other people I spoke to found it difficult
Reply 5
Original post
by Anonymous43.How did everyone find Part A?
Really easy. Except from report calculation and structure and testing for managerID and RoomID. Mine didn’t work so I left it blank. My evaluation was a bit weak
Reply 6
Original post
by Anonymous43.How did everyone find Part A?
Alright but except from the report it was good
Reply 7
That exam was alright, but that report was shambolic, I didn't know how to show the "Occupant" warning they asked. Did anyone know how to do the "Occupant" warning part?
Reply 8
5
Original post
by AB.D26That exam was alright, but that report was shambolic, I didn't know how to show the "Occupant" warning they asked. Did anyone know how to do the "Occupant" warning part?
I just had an if statement about if the party size was less than the 75% value then "Unoccupied" text otherwise " ". It seemed to work and only appeared on i think the last 2 parties on the report...
Reply 9
5
On the structure testing however I wasn't too sure on the type of test. Hopefully a minor thing.
Reply 10
Original post
by Anonymous43.I just had an if statement about if the party size was less than the 75% value then "Unoccupied" text otherwise " ". It seemed to work and only appeared on i think the last 2 parties on the report...
I wrote that as well but it posted occupant for all of them does any one know how many marks i lost bescause of that also can someone tell me if it was fine to put the Room ID in the customers table as i did that and the queries worked.
Reply 11
Original post
by bentas13I wrote that as well but it posted occupant for all of them does any one know how many marks i lost bescause of that also can someone tell me if it was fine to put the Room ID in the customers table as i did that and the queries worked.
I had Room ID originally on the Client's table, however on Activity 4 it stated that a party table submission shouldn't go through if the Room ID didn't match. So because of that I removed the RoomID from the clients table and changed the relationships which led to me having to redo all my queries. If the queries work, you shouldn't really lose any significant marks for it.
Reply 12
5
Original post
by bentas13I wrote that as well but it posted occupant for all of them does any one know how many marks i lost bescause of that also can someone tell me if it was fine to put the Room ID in the customers table as i did that and the queries worked.
Reply 13
Original post
by Anonymous43.How did everyone find Part A?
it was good until it wasnt. Did activity 1,2 and 3 well until i got stuck on the report, which i stupidly ended up spending so much time on i didnt do activity 4 or 5, and because i rushed so badly i forgot to include my database into the folder. I'll probably be doing a retake
Reply 14
Original post
by Anonymous43.With reports I think the mark scheme is separated into different traits like functionality, looks etc. So you should still get marks even if the functionality isn't 100%. Did you manage to do the total number of parties at the bottom?
yes i got 9
Reply 15
Original post
by Anonymous43.On the structure testing however I wasn't too sure on the type of test. Hopefully a minor thing.
My word document didnt have type of test on structure testing. (Like X,R, N) so i didnt include that
Reply 16
Original post
by Anonymous43.How did everyone find Part A?
i gave up i akways struggled with the relationships in activity 1 as i nver understood how to do it😭 sp i deffo failed i got stuck there and cudnt do anything else🥲 now im scared for partB my brainnso slow i dont understand nothing my parent r gnna kill me😭
Reply 17
Original post
by Kesha_Kash05i gave up i akways struggled with the relationships in activity 1 as i nver understood how to do it😭 sp i deffo failed i got stuck there and cudnt do anything else🥲 now im scared for partB my brainnso slow i dont understand nothing my parent r gnna kill me😭
same thing here like i was inputting the data and it just didn’t work and kept giving me an error. might have to drop the course because i fully just don’t understand databases at all. however i got distinctions in two other units.
Reply 18
Original post
by Anonymous43.How did everyone find Part A?
Much better than the first attempt. Hopping for a Pass
Reply 19
Original post
by AB.D26That exam was alright, but that report was shambolic, I didn't know how to show the "Occupant" warning they asked. Did anyone know how to do the "Occupant" warning part?
Yes - you had to use an =IIF formula.
Quick Reply
Related discussions
- Btec level 3 Applied science extended diploma grade
- Feedback on Unit 6 Jan 2025
- College Review. A Warning For Prospective Students!
- Cannot find my specific grade for UCAS
- Btec IT Unit 11 and 14 result.
- Level 3 Applied Science
- Help Calculating Final BTEC Grade
- BTEC Business Extended Diploma Grade Calculator
- Btec applied science grade calculator
- unit 14 IT service delivery jan 2025
- How do I work out my grade points
- Btec applied science unit 3 may 2025 predictions
- Unit 14 IT Service Delivery Help (pearsons)
- Pre-registration MSc Radiotherapy and Oncology in Practice at SHU
- Btec
- BTEC Applied Science Unit 3 2025
- GCSE WJEC and CCEA Exam Discussions 2025
- BTEC IT LEVEL 3 unit 2 jan 2024
- Btec Law Pre-Release Exam Material 2025 (January Exam)
- BTEC extended diploma Level 3 Applied Science
Latest
Trending
Last reply 2 months ago
Applied science btec - what do i need?Last reply 3 months ago
If i quit my WJEC applied diploma in criminology now will i still get the certificateLast reply 3 months ago
Uniformed and public servicesLast reply 3 months ago
Health and social care Btec gradingLast reply 3 months ago
predicted grades - btec applied scienceLast reply 3 months ago
Level 2 adult numeracy and literacy still accepted?Last reply 3 months ago
Btec health and social care unit 6Last reply 3 months ago
NCFE CACHE L3 Certificate Health and Social Care resultsLast reply 4 months ago
Health and Social Care Level 3Last reply 4 months ago
Btec level 3 Applied science extended diploma gradeLast reply 5 months ago
Can I get into uni with 2 btecs?
How The Student Room is moderated
To keep The Student Room safe for everyone, we moderate posts that are added to the site.
