This practical approach helps students develop knowledge and skills that benefit them both in employment and in preparation for higher education.
The specification builds on the foundations laid by the GCSE ICT specification and the GCSE Applied ICT Double Award.
Key fields are identified using a primary key as shown in the image below: :- If Dr Hyde changed his room number to 02, we only need to change this information once in the doctor table.
The new room would automatically be assigned to every patient who was under the care of Dr Hyde.
CCEA's GCE Applied ICT qualification gives students hands-on experience of ICT and first hand experience of how it is used in real life contexts.
Students also take part in practical work outside the classroom.
However, students do not need to complete either of these courses before undertaking GCE Applied ICT.
This course will equip students with the practical ICT skills needed for both further education and employment.
The purpose of this module is to provide an overview of the theory andpractice of database systems: data and database analysis, design, useand management, with particular emphasis on relational systems.
Inter alia the module will cover: data investigation, representation andorganisation; metadata; conceptual modelling; entity-relationshipmodelling; normalization of data; relational databases and relationalalgebra; query languages; SQL; database implementation; databasemanagement systems; database administration; security and performanceissues; data on the web and related issues.