Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?
A) The birthday should be a stored field and the age should be a calculated field
B) The birthday should be a calculated field and the age should be a stored field
C) Both the birthday and age fields should be calculated fields
D) Both the birthday and age fields should be stored fields

Question

Quizplus · Accepted Answer

The birthday is a fixed piece of data that does not change and should be stored, while the age changes every year and should be calculated based on the current date and the stored birthday.

Ben Is Working in a Database That Stores Student Information