answersLogoWhite

0

The E-R model is a data model used to describe the relationships between entities in a database. An Entity set is a collection of similar entities (objects) with shared attributes that are grouped together in the database.

User Avatar

AnswerBot

1y ago

What else can I help you with?

Continue Learning about Educational Theory

Why associative entity use in ER model?

Associative entities are used in Entity-Relationship (ER) models to represent relationships between two or more entities. They help to model complex relationships that have attributes of their own. By using associative entities, we can accurately capture the associations between the main entities and represent them in a clear and normalized way.


Do bacteria have smooth er?

No, bacteria do not have smooth endoplasmic reticulum (ER). Smooth ER is a cell organelle found in eukaryotic cells, not in prokaryotic cells like bacteria.


Do bacteria have ER?

No, bacteria do not have endoplasmic reticulum (ER) like eukaryotic cells. Bacteria lack membrane-bound organelles, including the ER, and instead have a simpler internal structure.


ER Diagram of transport system of college?

An ER diagram of a college transport system would typically include entities such as Student, Driver, Vehicle, Route, and Booking. Relationships between these entities would show how students book rides, assign drivers to vehicles, and track routes taken. Attributes for each entity might include student ID, driver license number, vehicle number, route ID, and booking timestamp.


- How does the hierarchical data model address the problem of data redundancy?

The hierarchical model divides the data into parents and children with the system working on the principle that each child can have only one parent but each parent can have an infinate number of children - thus supporting one-to-manyrelationships.This means that data redundency is reduced as a relationship can be established between entities e.g. in a school system each course would be a parent, with each student being the child, and each grade being the child of the student.This would allow you to createa one-to-many relationship between the students on each course and the grades for each pupil.However this system is not ideal for this scenario, as if a student was enrolled on more than one course their details would have to be duplicated for each course.To deal with this many-to-many relationship you would need to create a relational database, creating a studentcourses entity with a one to many relationship occurring between both it and a student entity and it and a courses entity

Related Questions

What is aggregation in ER diagram?

-Used when we have to model a relationship involving (entitity sets and) a relationship set.-Aggregationallows us to treat a relationship set as an entity set for purposes of participation in (other) relationships.


Entity relationship model with example?

draw an er diagram on attendance management system


Entity-relationship model retaurent management?

er daigram and dfd retaurent management?


What is er model in dbms?

In software engineering, an Entity - Relationship model(ER model for short) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion. Diagrams created by this process are called entity-relationship diagrams or ER diagrams.learn more www.ngprakasam.hpage.com


Er model.... Entity relationship diagram about how patient sets appointment to a doctor for check up....?

me2


What is ER models?

The Entity-Relationship Model is often referred to as a semantic data model, because it more closely resembles real world scenarios than, e.g., the relational model. . In the ER model, we model the concept of "Instructors." In the relational model we deal with names and phone numbers. . In the ER model, there is a distinction between entities (objects) and relationships between such entities. In the relational model, both concepts are represented by relations.


What are the components of er model?

components of er model are :- 1. external entity 2. relationships :- one to one , one to many , many to one , many to many 3. attributes 4. cardinality 5. participation


What are two types of ER?

The two types of ER (Entity-Relationship) models commonly used in database design are the conceptual ER model, which describes the high-level concepts and relationships in a system, and the logical ER model, which defines the structure and constraints of the database in more detail.


Two types of ER?

There are two types of ER (Entity-Relationship) models: conceptual ER models, which focus on defining entities, attributes, and relationships in a domain, and logical ER models, which involve translating the conceptual ER model into a specific database schema design.


Difference between entity and entity set?

Entity - Table Entity Set - Rows in Table


What is meaning of IR and ER in people management?

ER means Entity Relationship


In model ER why you need DBMS system?

Because it is very useful in mapping the meanings and interactions of real-world enterprises onto a conceptual schema. Because of this usefulness, many database-design tools draw on concepts from the ER-model. The ER data model employs three basic notation:a.) Entity setsb.) Relationship setsc.) Attributes.