Flat-File databases hold all of their data in one table only. The patient database is an example of a flat-file as all of the information is stored in one single table: Data that is duplicated unnecessarily within a database is bad practice.
If we had 100 patients who were all assigned Dr Hyde.
The work across all Key Stages is designed to challenge the students to create ICT solutions to key tasks and problems in the real world.
In our dedicated ICT suites the pupils are taught how to become efficient users of digital technology, ranging from essential office skills to programming and web designing.
This section focuses on different types of databases, in particular, flat-file and relational databases.
We will discuss the benefits of using relational databases and how tables can be joined together to make entering and updating data more efficient .
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.
Learning outcomes: By the end of the module, students will beable to analyse, specify, design and implement a data management system.
A vital component of the course is the coursework task, which comprises 30% of the overall mark for the course. Part 1 considers Relational Database Systems and involves the creation of a relational database with the establishment of relationships, data validation and implementing reports.