Database Fundamentals — Question 84

Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data.
What do you recommend?

Answer options

• A. Create a table that contains columns that are named given name, surname, phone number, and email.
• B. Create a table that contains rows that are named given name, surname, phone number, and email.
• C. Create a view that contains columns that are named given name surname, phone number, and email.
• D. Create a view that contains rows that are named given name surname, phone number, and email

Correct answer: A

Explanation

The correct answer is A because a table is structured with columns to define the different attributes of the data, such as given name, surname, phone number, and email. Options B, C, and D are incorrect as they either misrepresent the structure of storing data or confuse the concept of rows and columns in a database context.