Please note that the field length of Forename in Entity Relationship diagram is 26 ( at 21:31)
@davidayliffe2476 ай бұрын
and surname should be 12 characters
@Faisal-jo5vk Жыл бұрын
i would've never thought of normalizing it like that
@merbertjeruela5488 Жыл бұрын
Can you create a video for the 2025 specimen paper for paper 4? Thanks.
@xizx2597 Жыл бұрын
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.
@finzpapers9364 Жыл бұрын
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...
@asrabibi5509 Жыл бұрын
plz as in Pakistan you couldn't find more IT teachers plz more past paper solutions 9626/12 and 32
@papiibolt7596 ай бұрын
Cant I delete "English, Maths, IT and Science" from the student table after making the StudentClass table since the classes are already there?
@davidayliffe2476 ай бұрын
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...
@finzpapers93646 ай бұрын
I do agree.. But marking scheme shows the 4 fields.. Still doesn't understand why they r included
@davidayliffe2476 ай бұрын
@@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!
@emortia6 ай бұрын
@@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
@davidayliffe2475 ай бұрын
@@emortia I don't think it does.... but they are in the answer key from Cambridge so IDK
@amleh0096 ай бұрын
Why didnt we separate the pupil number and forename and surname into another table and delete the forename and surname from the original table
@papiibolt7595 ай бұрын
I think its because they will fall under the same primary key which is StudentID so its not needed to split them
@ahmedbarry3764 Жыл бұрын
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😢
@finzpapers9364 Жыл бұрын
Practice all papers and find out different skills asked in different years
@blissaethetic Жыл бұрын
will i lose marks if i set fieldsize for both first name and surname as , say, 30?
@finzpapers936411 ай бұрын
Don't think so
@davidayliffe2476 ай бұрын
Yes, according to the answer key, you will lose 2 marks. One for each.
@Wolfxzy.The.Robloxian Жыл бұрын
What is that website where you check the entity relationship information?
@ahmedbanaga8185 Жыл бұрын
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
@Foodie.anas007 Жыл бұрын
will a link table be always needed for conversion to the third normal form?
@finzpapers9364 Жыл бұрын
Mostly, if you cannot find a relationship in the existing tables
@abdullahqamar5570 Жыл бұрын
from where get those file
@weaponx8263 Жыл бұрын
Use gceguide
@glitchplays7574 Жыл бұрын
FROM GCE GUIDE
@rogerbackster3762 Жыл бұрын
@@glitchplays7574 ayo how did i find u on here
@rogerbackster3762 Жыл бұрын
@@glitchplays7574 hope ur prepared for the mock exam bruh cuz I just did spreadsheet and database, cant be bothered
@perlyricperword8282 Жыл бұрын
can i have the files so i can solve the paper while watching u?
@eashtmodi Жыл бұрын
can 4 subjects be compound key in students table?
@xizx2597 Жыл бұрын
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
@eashtmodi Жыл бұрын
@@xizx2597 yeah thanks
@saminaamin6808 Жыл бұрын
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
@finzpapers9364 Жыл бұрын
I will try..please send me link to syllabus and past papers