IT BTEC Level 3 Unit 2 Creating Systems To Manage Information.
How did everybody find today’s unit 2 exam?
How did everybody do their relationships and did they recognise the 2 one to one relationships?
Couldn’t see any one to many relationships.
How did everybody do their relationships and did they recognise the 2 one to one relationships?
Couldn’t see any one to many relationships.
Reply 1
I also noticed the 2 many-to-many relationships. I put all three IDs in the joining table but only made VolunteerID and PositionID primary keys, do you guys think that's right? It just felt weird having three primary keys so I thought it was wrong. What did you guys do?
Imo Query B and the report was awful I've never seen anything like it
Imo Query B and the report was awful I've never seen anything like it
Reply 2
Zak45
OP
1
Original post
by ReeceDG20I also noticed the 2 many-to-many relationships. I put all three IDs in the joining table but only made VolunteerID and PositionID primary keys, do you guys think that's right? It just felt weird having three primary keys so I thought it was wrong. What did you guys do?
Imo Query B and the report was awful I've never seen anything like it
Imo Query B and the report was awful I've never seen anything like it
I just made all the IDs in the 2 joining tables primary keys. I agree it felt wrong having so many but we will see how it goes. And yes I agree that report question was horrendous. Only attempted the first query in question 3 nothing else.
(edited 10 months ago)
Reply 3
Zak45
OP
1
Original post
by ReeceDG20I also noticed the 2 many-to-many relationships. I put all three IDs in the joining table but only made VolunteerID and PositionID primary keys, do you guys think that's right? It just felt weird having three primary keys so I thought it was wrong. What did you guys do?
Imo Query B and the report was awful I've never seen anything like it
Imo Query B and the report was awful I've never seen anything like it
What did you have in each joining table?
Reply 4
Original post
by ReeceDG20I also noticed the 2 many-to-many relationships. I put all three IDs in the joining table but only made VolunteerID and PositionID primary keys, do you guys think that's right? It just felt weird having three primary keys so I thought it was wrong. What did you guys do?
Imo Query B and the report was awful I've never seen anything like it
Imo Query B and the report was awful I've never seen anything like it
Yooo, I did the same thing. The first query was good, and the second one was not the best. But wtf was that report.
Reply 5
Original post
by Zak45What did you have in each joining table?
In the 4th table, which was the attendance table, I had Volunteer ID and position ID, which were a primary key together(composite key).Then I had the attendance field and the runID field in it as well.
Reply 6
Original post
by Zak45How did everybody find today’s unit 2 exam?
How did everybody do their relationships and did they recognise the 2 one to one relationships?
Couldn’t see any one to many relationships.
How did everybody do their relationships and did they recognise the 2 one to one relationships?
Couldn’t see any one to many relationships.
All of mine were 1 to many, there was one many to many but I found a forth table and made it into a one to many
Reply 7
Original post
by ReeceDG20I also noticed the 2 many-to-many relationships. I put all three IDs in the joining table but only made VolunteerID and PositionID primary keys, do you guys think that's right? It just felt weird having three primary keys so I thought it was wrong. What did you guys do?
Imo Query B and the report was awful I've never seen anything like it
Imo Query B and the report was awful I've never seen anything like it
Yeah that report was DIABOLICAL. I fount the query B not too bad but I just had problems with counting the yes/no check box in volunteers attended. it kept giving a negative but still somehow made sense overall. hopefully I picked up marks in the rest though. Smith annoyed me for popping up once for each date, but ended up forgiving him when it came to counting in the query B. Let's see how it all goes 🤩 (I wish I had revised harder for that LowryCastle one in Jan, it was so much easier than this imo)
Quick Reply
Related discussions
- College Review. A Warning For Prospective Students!
- BTEC grade calculation
- Unit 11 Cyber Security Incident Management and Unit 14 IT Service Delivery BTEC
- BTEC Level 3 IT (Information Technology) assignments and exam material.
- Unit 11 cybersecurity and incidents
- BTEC Business Extended Diploma Grade Calculator
- Unit 11 part B (part 1)
- Btec IT Unit 11 and 14 result.
- unit 14 IT service delivery jan 2026 part A
- Foundation Degree in Computing (～￣▽￣)～ My Diary
- Would I still get a pass If I manage to get a merit or distinction on some of my unit
- Unit 11 Cyber Security Incident Management and Unit 14 IT Service Delivery BTEC
- Btec Applied Science
- unit 14 IT service delivery jan 2025
- Unit 14 2025 April
- Unit 11 Cyber Security Incident Management Part B
- BTEC IT Unit 11 Cyber and Unit 14 IT Service delivery March 2025 Results
- Unit 14 IT Service Delivery Jan 2023 Exam Discussion
- BTEC Level 3 IT (Information Technology) assignments and exam material Help
- Can you enter pharmcy with BTEC health and social care and A level chemistry
Latest
Trending
Last reply 7 months ago
Applied science btec - what do i need?Last reply 7 months ago
If i quit my WJEC applied diploma in criminology now will i still get the certificateLast reply 7 months ago
Uniformed and public servicesLast reply 7 months ago
Health and social care Btec gradingLast reply 7 months ago
predicted grades - btec applied scienceLast reply 7 months ago
Level 2 adult numeracy and literacy still accepted?Last reply 7 months ago
Btec health and social care unit 6Last reply 8 months ago
NCFE CACHE L3 Certificate Health and Social Care resultsLast reply 8 months ago
Health and Social Care Level 3Last reply 8 months ago
Btec level 3 Applied science extended diploma gradeLast reply 9 months ago
Can I get into uni with 2 btecs?Articles for you
How The Student Room is moderated
To keep The Student Room safe for everyone, we moderate posts that are added to the site.
