Hey, the Question in Task 6 mentions to use the same data as specified in the source files, including the names of the Primary key fields or any other field. Even the marking scheme shows the original field names, without specifiing any alternatives or suggestions which express the usage of modified field names.
Field names should follow a proper naming convention and no where it is mentioned tht same field name should be used..you can see it is Pupil number in file but in marking scheme it is Pupil_No... also no data is changed...
yea but ultimately those 4 subject fields are dependent on the 'Pupil_number' or Student_ID, so making the Student_ID or Pupil_number the only primary key is probably the best way of connecting the fields
Surely you don't need "English", "Maths", "IT" and "Science" in the Student table in task 9 when normalising to the 3rd form. This is duplicated data and violates the rules of 3NF...
@@finzpapers9364 yeah and there's a mistake in their answer key too on the link table which shows surname as one of the fields! madness! you'd think they'd proofread these before they go out!
@@davidayliffe247 do u think the student table still needs those english maths science it though? cause I'm also confused and I don't trust the mark scheme anymore ToT
Please note that the field length of Forename in Entity Relationship diagram is 26 ( at 21:31)
and surname should be 12 characters
i would've never thought of normalizing it like that
Can you create a video for the 2025 specimen paper for paper 4? Thanks.
Hey, the Question in Task 6 mentions to use the same data as specified in the source files, including the names of the Primary key fields or any other field. Even the marking scheme shows the original field names, without specifiing any alternatives or suggestions which express the usage of modified field names.
Field names should follow a proper naming convention and no where it is mentioned tht same field name should be used..you can see it is Pupil number in file but in marking scheme it is Pupil_No... also no data is changed...
Cant I delete "English, Maths, IT and Science" from the student table after making the StudentClass table since the classes are already there?
Why didnt we separate the pupil number and forename and surname into another table and delete the forename and surname from the original table
I think its because they will fall under the same primary key which is StudentID so its not needed to split them
What is that website where you check the entity relationship information?
It's the online version of the IT A-level coursebook. You have to have a physical textbook to enter a code on the website
plz as in Pakistan you couldn't find more IT teachers plz more past paper solutions 9626/12 and 32
will i lose marks if i set fieldsize for both first name and surname as , say, 30?
Don't think so
Yes, according to the answer key, you will lose 2 marks. One for each.
Very few days left and i have no idea about database. Please give advice how should i cover all practical for p2 and p4 also. 😢😢. PLEASE HELP😢
Practice all papers and find out different skills asked in different years
will a link table be always needed for conversion to the third normal form?
Mostly, if you cannot find a relationship in the existing tables
from where get those file
Use gceguide
FROM GCE GUIDE
@@glitchplays7574 ayo how did i find u on here
@@glitchplays7574 hope ur prepared for the mock exam bruh cuz I just did spreadsheet and database, cant be bothered
can 4 subjects be compound key in students table?
yea but ultimately those 4 subject fields are dependent on the 'Pupil_number' or Student_ID, so making the Student_ID or Pupil_number the only primary key is probably the best way of connecting the fields
@@xizx2597 yeah thanks
Surely you don't need "English", "Maths", "IT" and "Science" in the Student table in task 9 when normalising to the 3rd form. This is duplicated data and violates the rules of 3NF...
I do agree.. But marking scheme shows the 4 fields.. Still doesn't understand why they r included
@@finzpapers9364 yeah and there's a mistake in their answer key too on the link table which shows surname as one of the fields! madness! you'd think they'd proofread these before they go out!
@@davidayliffe247 do u think the student table still needs those english maths science it though? cause I'm also confused and I don't trust the mark scheme anymore ToT
@@emortia I don't think it does.... but they are in the answer key from Cambridge so IDK
can i have the files so i can solve the paper while watching u?
Is anyone doing edexcel IT CUZ there is no tb for that spec and past papers are also very less please make vids for IT
I will try..please send me link to syllabus and past papers
Unit 1 and 2
I have exam in 5 days
@@saminaamin6808 how was it?
@@wiftzy4060 i passed bro 110/50
7:45