Relationship is a set of meaningful associations among entities. As with entities, each association should be uniquely identifiable within the set. A uniquely identifiable association is called a relationship occurrence. Each relationship is given a name that describes its function. For example, the Actor entity is associated with the Role entity through a relationship called Plays, and the Role entity is associated with the Video entity through a relationship called Features.
The entities involved in a particular relationship are referred to as participants. The number of participants in a relationship is called the degree and indicates the number of entities involved in a relationship. A relationship of degree one is called unary, which is commonly referred to as a recursive relationship. A unary relationship describes a relationship where the same entity participates more than once in different roles. An example of a unary relationship is Supervises, which represents an association of staff with a supervisor where the supervisor is also a member of staff. In other words, the Staff entity participates twice in the Supervises relationship; the first participation as a supervisor, and the second participation as a member of staff who is supervised (supervisee). See Figure 7.5 for a diagrammatic representation of the Supervises relationship.
kevowmuchiri answered the question on July 4, 2018 at 16:24
- Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.(Solved)
Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.
Date posted: July 4, 2018. Answers (1)
- How do the contents of a users’ requirements specification differ from a systems specification?(Solved)
How do the contents of a users’ requirements specification differ from a systems specification?
Date posted: July 4, 2018. Answers (1)
- What is the purpose of the systems definition stage?(Solved)
What is the purpose of the systems definition stage?
Date posted: July 4, 2018. Answers (1)
- Describe how fact-finding is used throughout the stages of the database system development lifecycle(Solved)
Describe how fact-finding is used throughout the stages of the database system development lifecycle
Date posted: July 4, 2018. Answers (1)
- Briefly describe what the process of fact-finding attempts to achieve for a database developer. (Solved)
Briefly describe what the process of fact-finding attempts to achieve for a database developer.
Date posted: July 4, 2018. Answers (1)
- Discuss Redundant Array of Independent Disks (RAID)(Solved)
Discuss Redundant Array of Independent Disks (RAID)
Date posted: July 4, 2018. Answers (1)
- Explain the purpose and scope of database security.(Solved)
Explain the purpose and scope of database security.
Date posted: July 4, 2018. Answers (1)
- Discuss the process of testing the database system and its purpose(Solved)
Discuss the process of testing the database system and its purpose
Date posted: July 4, 2018. Answers (1)
- What are the main activities associated with operational maintenance stage.(Solved)
What are the main activities associated with operational maintenance stage.
Date posted: July 4, 2018. Answers (1)
- Describe the purpose of the data conversion and loading stage.(Solved)
Describe the purpose of the data conversion and loading stage.
Date posted: July 4, 2018. Answers (1)
- Discuss the main activities associated with the implementation stage.(Solved)
Discuss the main activities associated with the implementation stage.
Date posted: July 4, 2018. Answers (1)
- Describe the potential benefits of developing a prototype database system.(Solved)
Describe the potential benefits of developing a prototype database system.
Date posted: July 4, 2018. Answers (1)
- Discuss the two main activities associated with application design.(Solved)
Discuss the two main activities associated with application design.
Date posted: July 4, 2018. Answers (1)
- Explain why it is necessary to select the target DBMS before beginning the physical database design phase. (Solved)
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
Date posted: July 4, 2018. Answers (1)
- Discuss what a user view represents when designing a database system.(Solved)
Discuss what a user view represents when designing a database system.
Date posted: July 4, 2018. Answers (1)
- Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.(Solved)
Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.
Date posted: July 4, 2018. Answers (1)
- Briefly describe the stages of the database system development lifecycle. (Solved)
Briefly describe the stages of the database system development lifecycle.
Date posted: July 4, 2018. Answers (1)
- Discuss the relationship between the information systems lifecycle and the database system development lifecycle.(Solved)
Discuss the relationship between the information systems lifecycle and the database system development lifecycle.
Date posted: July 4, 2018. Answers (1)
- Describe what is meant by the term ‘software crisis’.(Solved)
Describe what is meant by the term ‘software crisis’.
Date posted: July 4, 2018. Answers (1)
- What is QBE and what is the relationship between QBE and SQL?(Solved)
What is QBE and what is the relationship between QBE and SQL?
Date posted: July 4, 2018. Answers (1)