The purpose of the system definition stage is to identify the scope and boundary of the database system and its major user views. Defining the scope and boundary of the database system helps to identify the main types of data mentioned in the interviews and a rough guide as to how this data is related. A user view represents the requirements that should be supported by a database system as defined by a particular job role (such as Manager or Assistant) or business application area (such as video rentals or stock control).
kevowmuchiri answered the question on July 4, 2018 at 16:19
-
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)
-
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)