CompTIA Study Materials
AWS Study Materials
AWS Certified Developer Associate AWS Certified Developer Associate
AWS Certified Developer Associate DVA-C02
AWS Certified Solutions Architect Associate AWS Certified Solutions Architect Associate
AWS Certified Solutions Architect Associate SAA-C03
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

Free CompTIA ITF+ FC0-U61 Practice Question

In a relational database designed for a healthcare clinic, there are two tables: 'Patients' and 'Appointments'. The 'Patients' table has a 'PatientID' field, which uniquely identifies each patient. How should this field be properly used in the 'Appointments' table to maintain a relationship between the two tables?

  • Copy all patient information into the 'Appointments' table for each appointment

  • Create a new 'AppointmentID' field in the 'Patients' table

  • Generate a random unique identifier for each appointment separately from 'PatientID'

  • Include 'PatientID' as a 'Foreign Key' in the 'Appointments' table

This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology