Database Fundamentals — Question 141

John works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database.
John wants to insert records in a table where the database is structured in a fixed format.
Which of the following data models will he use to accomplish the task?

Answer options

• A. Object relational data model
• B. Entity-Relationship Model
• C. Network data model
• D. Relational model

Correct answer: D

Explanation

The correct answer is D, the Relational model, as it is specifically designed for structured data in tables, allowing for easy insertion of records. The Object relational data model (A) extends the relational model but is not primarily focused on fixed formats. The Entity-Relationship Model (B) is used for designing databases but not for direct data manipulation. The Network data model (C) is outdated and not as commonly used for structured table formats.