Get premium membership and access questions with answers, video lessons as well as revision papers.
Identifying relationships
Having identified the entities, the next step is to identify all the relationships that exist between these entities. When you identify entities, one method is to look for nouns in the users’ requirements specification. Again, you can use the grammar of the requirements specification to identify relationships. Typically, relationships are indicated by verbs or verbal expressions. For example:
• Branch Has Staff
• Branch IsAllocated VideoForRent
• VideoForRent IsPartOf RentalAgreement
The fact that the users’ requirements specification records these relationships suggests that they are important to the users, and should be included in the model.
Take great care to ensure that all the relationships that are either explicit or implicit in the users’ requirements specification are noted. In principle, it should be possible to check each pair of entities for a potential relationship between them, but this would be a daunting task for a large system comprising hundreds of entities. On the other hand, it’s unwise not to perform some such check. However, missing relationships should become apparent when you check the model supports the transactions that the users require. On the other hand, it is possible that an entity can have no relationship with other entities in the database but still play an important part in meeting the user’s requirements.
kalvinspartan answered the question on July 9, 2018 at 19:16
- Identify the main tasks associated with Step 1 of logical database design.(Solved)
Identify the main tasks associated with Step 1 of logical database design.
Date posted: July 9, 2018. Answers (1)
- Discuss the purpose of Step 1 of logical database design.(Solved)
Discuss the purpose of Step 1 of logical database design.
Date posted: July 9, 2018. Answers (1)
- Discuss the main activities associated with each step of the logical database design methodology(Solved)
Discuss the main activities associated with each step of the logical database design methodology
Date posted: July 9, 2018. Answers (1)
- Discuss the important role played by users in the process of database design.(Solved)
Discuss the important role played by users in the process of database design.
Date posted: July 9, 2018. Answers (1)
- Identify important factors in the success of database design.(Solved)
Identify important factors in the success of database design.
Date posted: July 9, 2018. Answers (1)
- Describe the main phases involved in database design.(Solved)
Describe the main phases involved in database design.
Date posted: July 9, 2018. Answers (1)
- Describe the purpose of a design methodology.(Solved)
Describe the purpose of a design methodology.
Date posted: July 9, 2018. Answers (1)
- Describe what is meant by transitive dependency and describe how this type of dependency relates to 3NF. Provide an example to illustrate your answer.(Solved)
Describe what is meant by transitive dependency and describe how this type of dependency relates to 3NF. Provide an example to illustrate your answer.
Date posted: July 9, 2018. Answers (1)
- Describe the characteristics of a table in third normal form (3NF).(Solved)
Describe the characteristics of a table in third normal form (3NF).
Date posted: July 9, 2018. Answers (1)
- Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.(Solved)
Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.
Date posted: July 9, 2018. Answers (1)
- Describe the characteristics of a table in second normal form (2NF).(Solved)
Describe the characteristics of a table in second normal form (2NF).
Date posted: July 9, 2018. Answers (1)
- Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) table(s).(Solved)
Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) table(s).
Date posted: July 9, 2018. Answers (1)
- What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.(Solved)
What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.
Date posted: July 9, 2018. Answers (1)
- Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.(Solved)
Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.
Date posted: July 9, 2018. Answers (1)
- Describe the types of update anomalies that may occur on a table that has redundant data.(Solved)
Describe the types of update anomalies that may occur on a table that has redundant data.
Date posted: July 9, 2018. Answers (1)
- Discuss how normalization may be used in database design.(Solved)
Discuss how normalization may be used in database design.
Date posted: July 9, 2018. Answers (1)
- Describe how strong and weak entities differ and provide an example of each.(Solved)
Describe how strong and weak entities differ and provide an example of each.
Date posted: July 7, 2018. Answers (1)
- Provide an example of a relationship with attributes(Solved)
Provide an example of a relationship with attributes
Date posted: July 7, 2018. Answers (1)
- Describe what multiplicity represents for a relationship.(Solved)
Describe what multiplicity represents for a relationship.
Date posted: July 7, 2018. Answers (1)
- What are business rules and how does multiplicity model these constraints?(Solved)
What are business rules and how does multiplicity model these constraints?
Date posted: July 7, 2018. Answers (1)