Question

In: Operations Management

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?

Solutions

Expert Solution

Substance Relationship Diagram shows the relationship among shifts elements and segments in a put away databases. It clarifies and portrays the legitimate structure in the database, the relationship existed to one component to another, with how many parts it has associations and so forth. When all is said in done these graphs looks like flowcharts, with specialized images, every image conveys one of a kind significance and which give some information or data to the per user.

there are numerous kinds of graphs drawn the makers dependent on the necessities, and dependent on the contributions to make the chart. The fundamental images utilizes for making of these graphs are given previously


Related Solutions

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...
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:...
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) 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: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
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.
Create a database and design an ER diagram for the given question. Must link the related...
Create a database and design an ER diagram for the given question. Must link the related tables then implement the design using MySQL. Insert at least 5 records. Ensure that the data to be added are related to other tables. Follow this format in creating the database and table: Database format: databasename_yourname Table format: tablename_yourname QUESTION: Company ABC has the following business rules. A department employs many employees, but each employee is employed by only one department. A division operates...
What role does supplier relationship management play in creating value in the procurement process? Provide a...
What role does supplier relationship management play in creating value in the procurement process? Provide a detailed explanation.
What is an ERDM, and what role does it play in the modern (production) database environment?
What is an ERDM, and what role does it play in the modern (production) database environment?Describe the basic features of the relational data model and discuss their importance to the end user and the designer.
What role does the executional framework play in advertising design?
What role does the executional framework play in advertising design?
What role does a firewall play in a honey pot design?
What role does a firewall play in a honey pot design?
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!!!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT