Question

In: Computer Science

I need an example of a composite entity replacing a m:n relationship in an Er diagram....

I need an example of a composite entity replacing a m:n relationship in an Er diagram.

Need atleast three entities being used.

Solutions

Expert Solution

· Composite entity is an entity used to represent the relationship between any other 2 or more entities.

· That is a many-to-many relationship can be eliminated from the ER diagram using these composite entities.

· As many-to-many relationship can cause some problem while converting the ER diagram to relational model.

· Entities are usually some objects and the relationship connecting them are some actions performed among the entities.

                               

Eg: consider the 3 entity relationship involving student, class, subject entity

Means: a student can be enrolled to many classes, a class can have many students

A student can study many subjects, a subject can be learnt by many students.

A class can have many subjects taught and a subject can be taught in many classes

This is how many-to-many relationship exhibited by the 3 given entities. (figure shown below)

Now these many-to-many relationship can be changed using composite entity.

Steps:

1. Identify the many-to-many relationship in the ER diagram (figure is shown below)

2. Then the relationship symbol(diamond) is changed to the composite entity symbol.(diamond symbol within the entity symbol, square)

3. Change the relationship name into an entity name

4. Now reconnect the relationship with the new arrived entity with the many-to-many relationship corrected to one-to-many.

5. Now each class will have many enrollments, each student will have many enrollments and each subject will have many enrollments (1:M relationship)

6. The composite entity will have a composite key, which is the combination of the primary keys of all the associated entities in 1:M relationship


Related Solutions

What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different...
What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?
A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that...
A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements. 1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records...
I am doing a project and need an ER diagram, as well as some, create table...
I am doing a project and need an ER diagram, as well as some, create table statements in SQL. Here is what I have so far. My database will be a hospital management system. It will be able to keep track of patients and doctors, as well as each of their attributes, to better help organize the hospital's data. Each patient and doctor will be searchable via an id, and the user will be able to run reports as well....
I need to draw an ER diagram for a future database necessary to hold application data...
I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for an internship at a tech company. The students will provide the following information on the application: first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4 character...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
In this project you will be provided a set of specifications to create an entity-relationship diagram...
In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements. You are a database consultant with Premier Software, LLC and have been assigned to...
business rules and entity-relationship diagram insurance, invoice, patient, appointment, employee
business rules and entity-relationship diagram insurance, invoice, patient, appointment, employee
Overview In this lab, you will design an Enhanced Entity Relationship (EER) diagram to improve on...
Overview In this lab, you will design an Enhanced Entity Relationship (EER) diagram to improve on the database design that you have worked on in the previous weeks. The new design will include additional improvements such as: Inheritance Relationships Constraints Union Types A clear and well-documented explanation of all your modifications and the EER diagram. can you please give me an example of how to start this or what am i supposed to do!!!
create an entity relationship diagram to describe the data requirements of the system. Your client is...
create an entity relationship diagram to describe the data requirements of the system. Your client is a local real estate company that wants to automate some of their processes. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property...
Create an entity relationship diagram to describe the data requirements of the system. Here is how...
Create an entity relationship diagram to describe the data requirements of the system. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property - A purchase agreement is between the seller and the buyer, and only for one property...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT