Get premium membership and access questions with answers, video lessons as well as revision papers.
There are many occasions for fact-finding during the database system development lifecycle. However, fact-finding is particularly crucial to the early stages of the lifecycle, including the database planning, system definition, and requirements collection and analysis stages. It’s during these early stages that the database developer learns about the terminology, problems, opportunities, constraints, requirements, and priorities of the business and the users of the system. Fact-finding is also used during database design and the later stages of the lifecycle, but to a lesser extent. For example, during physical database design, fact-finding becomes technical as the developer attempts to learn more about the DBMS selected for the database system. Also, during the final stage, operational maintenance, fact-finding is used to determine whether a system requires tuning to improve performance or further developed to include new requirements.
kevowmuchiri answered the question on July 4, 2018 at 16:17
- 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)
- What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?(Solved)
What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?
Date posted: July 4, 2018. Answers (1)
- Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?(Solved)
Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?
Date posted: July 4, 2018. Answers (1)
- What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?(Solved)
What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?
Date posted: July 4, 2018. Answers (1)
- Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?
a)FROM
b) WHERE
c)GROUP BY
d)HAVING
e)SELECT(Solved)
Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?
a)FROM
b) WHERE
c)GROUP BY
d)HAVING
e)SELECT
Date posted: July 4, 2018. Answers (1)