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?
A.
Object relational data model
B.
Entity-Relationship Model
C.
Network data model
D.
Relational model
Explanation:
A relational model uses a collection of tables to represent both data and the relationship between
those data. Every table has multiple columns, and each column has a unique name. A relational
model is an example of a record-based model. Record-based models are so named because the
database is structured in a fixed format. Each table in the database contains records of a particular
type and each record type defines a fixed number of fields or attributes. This model is the most
widely used data model, and most database systems are based on this model. This model is at a
lower level of abstraction than the E-R Model.Answer B is incorrect. The Entity-Relationship Model is a collection of objects called entities and the
relationships between these objects. Entities in a database are known as attributes. A relationship is
an association among several entities. It is a conceptual representation of structured data. Entityrelationship modeling is a relational schema database modeling method that is used in software
engineering to produce a type of conceptual data model of a system, often a relational database.
The logical structure of a database can be expressed graphically by an E-R diagram, which has the
following components:
Rectangle: It represents entity sets.
Ellipse: It represents attributes.
Diamond: It represents relationships among entity sets.
Line: It links attributes to entity sets.
Answer A is incorrect. An object relational data model (ORD) is similar to a relational data model,
but with an object-oriented database model. Objects, classes, and inheritance are directly supported
in database schemas and in the query language.
Answer C is incorrect. The network data model contains logical information such as connectivity
relationships among nodes and links, directions of links, and costs of nodes and links. A node
represents an object of interest and a link represents a relationship between two nodes.