Consider an E-R diagram in which the same entity set appears several times, with its attributes repeated in more than one occurrence. Why is allowing this redundancy a bad practice that one should avoid?

Consider an E-R diagram in which the same entity set appears several times, with its attributes repeated in more than one occurrence. Why is allowing this redundancy a bad practice that one should avoid?

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter8: Systems Development

Section: Chapter Questions

Problem 8SAT: Data modelling is most often accomplished through the use of a(an) ________________. a....

See similar textbooks

Related questions

Q: Can foreign keys be used with weak entities in an entity relationship diagram??

A: A entity that cannot be uniquely identified by its attribute alone is called weak entity.…

Q: Compare and contrast the different representations of a 1:M relationship in an ER model and a OODM…

A: The definite examination on the E-R model and Object Oriented data Model (OODM) is given as follows…

Q: A weak entity set may always be trans formed into a strong entity set by including the primary-key…

A: The Answer is given below step.

Q: Define the term ID-dependent entity, and give an example other than one used in this text. Draw an…

A: Note: There are multiple questions are given in one question. According to the rule, you will get…

Q: Can you convert this ER diagram to simple text that anyone understand it without entities ,…

A: Personal vehicle database : Defines each and every attributes and entity work in detail ...

Q: Describe the most comm on way in which relationshipsin an E-R diagram are expressed in a…

A: Describe the most comm on way in which relationshipsin an E-R diagram are expressed in a…

Q: Consider the generalization and specialization lattice structure below (attributes not shown).…

A: Given: Consider the generalization and specialization lattice structure below (attributes not…

Q: Provide a separate ER diagram representing each of the following situations. 1.A is an entity. It…

A: ER diagram 1)

Q: Describe the Entity-Relationship model and its function.

Q: Explain how weak entity representation differs from strong entity representation.

A: Entity: The entity is a representation of an object, table, or thing in a database management…

Q: Would you look if i got ER diagram right ? I am asked to design a conceptual data model using ER…

A: Would you look if i got ER diagram right ?

Q: Create an Entity-Relationship Model to represent the data requirements of the problem given below.…

A: ERD for the given requirement: No of Entities: Person entity Employee Alumnus Student Staff Faculty…

Q: A weak entity set may always be turned into a strong entity set by adding the primary-key attributes…

A: A weak entity set may permanently be transformed into a strong entity set by including the main…

Q: An attribute that may take on more than one value for each entity instance in ERD is referred to as…

A: Answer :- option D) multivalued attribute

Q: Model a Triangular Irregular Network (TIN) with an Entity-Relationship diagram. Consider three…

A: Here,discuss about model a Triangular Irregular Network (TIN) with an Entity-Relationship diagram.…

Q: Draw an ER diagram expressing the total participation of an entity type “BURGER” in a binary…

A: Answer: I have given answered in the handwritten format in brief explanation

Q: Ov

A: The degree of has relationship is two.

Q: a. Draw ER- notation for the given elements of ER-Model. 1. Entities a. Strong Entity b. Weak Entity…

A: Strong Entity: Weak Entity: Associate Entry:

Q: You are to clearly: -- identify entity sets, relationship sets, all attributes, and primary keys;…

A: About the case study:

Q: What exactly are entity-relationship diagrams, and how do they come into play? What kind of symbol…

A: Any real-life item engaging in a business situation is represented by an entity, which contains a…

Q: Write down the many kinds of attributes in the Entity-Relationship (ER) model.

A: Given: 1. Make a list of the different kinds of characteristics that are used in the…

Q: Define different attributes (assigning name and domain to each) for an entity STUDENT, then apply…

A: CARTESIAN PRODUCT: Consider there are two sets A and B, then the cartesian product of sets A and B…

Q: What is the attribute that could be obtained using other attributes in the Entity-Relationship…

A: Introduction: What is the attribute that could be obtained using other attributes in the…

Q: 4 An entity cluster is considered "virtual" or "abstract", which combines multiple interrelated…

A: Answer is True

Q: What are the applications of entity-relationship diagrams? What kind of symbol is used to depict a…

A: Answer : application of entity relationship diagram : It is to simply understanding the relationship…

Q: We can convert any weak entity set to a strong entity set by simply adding appropriate attributes.…

A: Answer: firstly we should know about what is weak entity set. Weak entity set definition: 1.An…

Q: Describe the goal of an entity-relationship model in your own words.

A: Locating data in a logical place is the main goal of entity relationship model

Q: A weak entity set can always be made into a strong entity set by adding to its attributes the…

A: To convert a weak entity set to a string set, simply add the primary key attributes from its…

Q: It is possible to can convert any weak entity set to a strong entity set by simply adding…

A: To avoid the inconsistencies caused by duplicating the key of the strong entity. Though a weak…

Q: Consider an E-R diagram containing 2 strong entities A and B. The cardinality ratio between the two…

A: Minimum number of tables required are 4

Q: Describe how the regular entity type of an E-R diagram are transformed into relations

A: Given: Describe how the regular entity type of an E-R diagram are transformed into relations

Q: Consider the following E/R diagram with isa relationships, in which every node represents an entity…

Q: ) Identify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5.…

A: Entity Relationship Diagram

Q: The three main constructs of the entity-relationship modeling notation include each of the following…

A: The three main construct of ER modeling are attributes,entity and relationship..with all the three…

Q: When mapping generalisations and specialisations in enhanced entity relationship diagrams, which…

A: Enhanced entity relationship diagram is a graphical portrayal that portrays connections among…

Q: Step 1: Data Modeling - Create an ER diagram: Draw an ER diagram that captures the preceding…

A: Here is the answer:-

Q: What exactly is the weak entity type? What is the key to it? Give an example what is an altrubute…

A: There are two types of weak entities: associative entities subtype entities. The latter represents…

Q: Describe how the relationship (supertype/subtype) of an E-R diagram is transformed into relations

A: A supertype type is a typical business type that is affiliated with one or more subtypes. The…

Q: Specifically, on which side of a many-to-one connection does the primary key of one entity function…

A: Given: Specifically, on which side of a many-to-one connection does the primary key of one entity…

Q: Assume that there are two entity sets A and B, both of which possess the property X. (among others…

A: Introduction: ER Schema is another name for an ER diagram or ER model. There are two basic concepts…

Q: Consider an E/R diagram which has information about students, courses, and enrollments, where…

A: Entity Relationship Diagram: Entity Relationship Diagram, also known as ERD, ER Diagram or ER model,…

Q: In an E-R diagram, there are two entity sets, students and courses, and one relationship set, take.…

A: E R Diagram

Q: Consider two entity sets A and B that both have the attribute X (among otherswhose names are not…

A: Here , 1. X is the primary key for A but not B Means X in B is refer as a foreign key for A . 2. X…

Q: Consider two sets of entities A and B, each of which include the property X (among other names that…

A: Summary: ER diagram, also known as ER model or ER Schema. The ER model is built on two key ideas:…

Q: draw an E-R diagram that indicates the entity sets and their attributes. Identify and label…

A: An ER diagram is an entity relationship diagram, also known as an ERD, which displays the…

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
A weak entity set may always be made stronger by adding the primary-key attributes of its identifying entity set to its attributes. Give an example of the kind of redundancy that will come from our choices.
By adding the primary-key attributes of its identifying entity set to its attributes, a weak entity set may always be transformed into a strong entity set. Describe the kind of redundancy that will occur as a consequence of our actions.
Every flimsy entity set may be strengthened by the addition of pertinent characteristics. What therefore, is the cause of our subpar entity sets?
Can you define the weak entity type for me? Is there a secret to it? Provide an instance Just what does it mean to specialize in attribute?Where does ia fit into an ER diagram? Provide Illustration or Diagram
A weak entity set can always be made into a strong entity set by adding to its attributes the primary-key attributes of its identifying entity set. Outline what sort of redundancy will result if we do so.
What exactly is the weak entity type? What is the key to it? Give an example what is an altrubute specialization?how ia represent on ER diagram? Give Example and draw corresponding diagram
A weak entity set may always be transformed into a strong entity set by including the primary-key attributes of the identifying entity set in its attributes. Explain what kind of redundancy will arise as a consequence of our decision.
Just what does "weak entity type" mean? Is there a secret to it? Can you explain the meaning of "attribute"?How does sia look like on an ER chart? Please illustrate with a diagram.
What exactly does it imply when we talk about the weak entity type? What exactly is the key? Please provide an example. What exactly is meant by the term "alternative specialisation"?Where exactly do I fit into the ER diagram? Provide an illustration, then draw a diagram that corresponds to it.
What is the definition of "weak entity type"? Does it have a secret? Can you elucidate what "attribute" means?How would sia appear on an ER chart? Please depict with a diagram.
Can foreign keys be used with weak entities in an entity relationship diagram??