Books /Entity-Relationship Modeling: Foundations of Database Technology

BROWSE BY

Entity-Relationship Modeling: Foundations of Database Technology

ISBN

9798888365373-2025

Author

Richard Buoen

Publisher

Larsen and Keller Education

Language

English

Publication Year

2025

Category

Computer and Information Science - Information Technology and Management

Pages

100

Price

USD 160

Description

Entity-Relationship (ER) Modeling is a fundamental technique used in database design to represent data and its relationships in a structured and systematic way. This model provides a visual schema to illustrate how entities like distinct objects or concepts such as customers, orders, or products—relate to one another within a system. ER modeling is crucial in the database technology landscape as it serves as the blueprint for creating relational databases, which are the backbone of modern data management systems. By defining entities, their attributes, and interrelationships, the ER model ensures that the database is logically coherent, reduces redundancy, and supports efficient data retrieval and manipulation. Database technologies, such as MySQL, Oracle, and SQL Server, leverage the ER model to structure data effectively. These technologies use Structured Query Language (SQL) to execute operations on the data defined by the ER schema, enabling the implementation of complex queries, data integrity constraints, and transactions. The topics covered in this extensive book deal with the core subjects of Entity-Relationship (ER) Modeling. Different approaches, evaluations and methodologies and advanced studies on database technologies have been included in this book. Those in search of information to further their knowledge will be greatly assisted by it.