87.1k views
3 votes
Items in the external level of the ANSI/SPARC model become _________ in the logical model?

1) Attributes
2) Entities
3) Tables
4) Relationships

1 Answer

6 votes

Final answer:

In the ANSI/SPARC model, items at the external level translate to entities at the logical level. Entities represent real-world objects or concepts within the database, and they later map to tables in the physical design.

Step-by-step explanation:

The items in the external level of the ANSI/SPARC model become entities in the logical model. The ANSI/SPARC model is a three-level architecture that separates the user's view (external level), the conceptual level, and the physical data level. The external level defines how the users view the data, and entities in a logical or conceptual model represent real-world objects or concepts that have an existence in the database.

Entities are identified during the logical design of the database and are mapped to tables during the physical design. Each entity correlates to a table in the relational database. The other options, such as attributes, describe the data which an entity holds, while relationships define how entities are connected to each other.

User General Electric
by
8.0k points