Asked Mar 25, 2019

If you are reading a flat file, with minimal information regarding business rules and constraints. How can one determine the appropiate relationships between entities?

This question refers to entity relationship modeling. Logical ERDs.


Expert Answer

Step 1


Even though the file contains minimal information about business rules and constraints, there certain rules which is used to identify the suitable relationship among the entities. They are described as follows:

Step 2

Identify the relationship among entities:

A relationship means linking the two associated entities.

  • The relationship always expressed with a “verb”.
  • The relationship among two entities is represented in “diamond” shape.
  • The relationship name is specified into that diamond shape.
  • There is no hard rule exist to identify the relationship. It always depends on the requirement of data.
    • For example: the “belongs to” is referred as relationship among department and employee entities.

Types of relationship:

  • There are three types of data relationships. They are,
    • One-to-one (1-to-1):
      • One record in one table is linked with one and only record in ano...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in


Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: do big data could replace the artistic vision of a creative director? and why?

A: Justification:“Yes”, big data replace the artistic vision of a creative director.


Q: Question 2 3 4

A: Question 2:Given binary value = 11012   The given binary value does not represents the decimal numbe...


Q: Analyze the following code: Code 1: int number = 45;boolean even; if (number % 2 == 0) even = true;e...

A: First lets discuss about the first question. 1) In the first code we are declaring two variables num...


Q: This table is in 1NF. What does the table look like in 3NF? This is about Normalization.

A: First to make the table clears 3NF we need to understand what is Normal form.* Basically normal form...


Q: Design a Turing machine that computes the function f(w) = 1 if w is even   = 0 if w ...

A: To discover whether a string is even or odd, just examine the LSB (least significant bit).If LSB is ...


Q: Write a program called StudentTable that prints the below table. Use only print() orprintf(). DO NOT...

A: Using the given hint "printf" the below program was done in C language where "println()" is used in ...


Q: what is the best test strategy for any ERP system?

A: ERP stands for Enterprise resource planning is a software used for business process management. It a...


Q: Associate each of the following concepts with one of the languages we covered (pseudo code,FORTRAN, ...

A: Associating languages with given concepts:ALGOL 60: Pass by nameALGOL 60: Pass by valueFORTRAN: Assi...


Q: This code is for python

A: This is a very long problem because of lack of space we provide only a portion of the algorithm. How...