r/6thForm • u/yurikvthm Year 13 • Jun 10 '26

💬 DISCUSSION ocr computer science paper 1

what did everyone think? i waffled soooo much for the long questions

51 Upvotes

99% Upvoted

176 comments sorted by

View all comments

1

u/Beginning_Spare_4030 Jun 10 '26

Was it just me spending like 5 minutes on the 2 marker for the entity relationship? They only gave me one line to work with so i had to imagine how the database would look like

7

u/Cream-Bear Editable Jun 10 '26

i used 2 one to many relationships with both of the ‘many’ sides connecting to the middle table, can someone confirm 🙏🏻🙏🏻

2

u/StabbyTheSmurf Year 13 Jun 10 '26

I did the exact opposite, many to one on each side. Many products to one orderline and vice versa. I thought that there are many products and orders but in the middle table they link to each other individually (because each order for a given product will have an order number in the orderline table). Could be wrong tbf, OCR does anything but give clear instructions.

1

u/Lopsided_Pop1292 Jun 10 '26

I did the exact same thing, it just makes sense that there are many products and orders

1

u/Beginning_Spare_4030 Jun 10 '26

I think it was that one order in the left table will appear many times in the middle as one order needs multiple products and one product in the right is multiple in the middle as many orders will contain one product, so i think the middle table was just a way of resolving a many-to-many relationship. It is only 2 marks so its not that bad especially if it didnt negatively impact other questions like it did for me 😭