You work as a systems architect at MDFT Pro, a well-known training agency that provides Microsoft certification courses. The academy is upgrading their IT infrastructure and needs to choose the most appropriate database solution for their human resources system that manages employee data, payroll information, and organizational structure.
Mark, the HR director, emphasizes that the employee data follows a well-defined, fixed schema that includes standard fields like employee ID, name, department, salary, and hire date. Claire, the IT manager, wants to ensure they select a database tier that best fits this structured data requirement and supports the complex relationships between employees, departments, and roles.
Which database service is most appropriate for the human resources system?
Choose the correct answer from the options below.
Explanations for each answer: