A small clinic is setting up a system to manage patient records. They need to ensure that multiple staff members can access and update patient information concurrently without conflicts, and they anticipate the volume of data will grow as the practice expands. Which of the following would be the most suitable for their requirements?
Use a single spreadsheet file to store all patient records, with each row representing a patient.
Use a database to manage patient records.
Use a flat file system to store each patient's record in a separate document.
Keep paper records in filing cabinets, with each drawer representing a different category of patient information.