Get premium membership and access questions with answers, video lessons as well as revision papers.
requirements. Data models representing each user view are created and then merged at a later stage of database design.
Database design is the process of creating a design that will support the company’s mission statement and mission objectives for the required database. This stage includes the logical and physical design of the database.
The aim of DBMS selection is to select a system that meets the current and future requirements of the company, balanced against costs that include the purchase of the DBMS product and any additional software/hardware, and the costs associated with changeover and training.
Application design involves designing the user interface and the application programs that use and process the database. This stage involves two main activities: transaction design and user interface design.
Prototyping involves building a working model of the database system, which allows the designers or users to visualize and evaluate the system.
Implementation is the physical realization of the database and application designs.
Data conversion and loading involves transferring any existing data into the new database and converting any existing applications to run on the new database.
Testing is the process of running the database system with the intent of finding errors.
Operational maintenance is the process of monitoring and maintaining the system following installation.
kevowmuchiri answered the question on July 4, 2018 at 16:01
- 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)
- What are the two major components of SQL and what function do they serve? (Solved)
What are the two major components of SQL and what function do they serve?
Date posted: July 4, 2018. Answers (1)
- Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.(Solved)
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
Date posted: July 4, 2018. Answers (1)
- Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign...(Solved)
Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign keys of tables relate to candidate keys? Give examples to illustrate your answer.
Date posted: July 4, 2018. Answers (1)
- Discuss the properties of a relational table. (Solved)
Discuss the properties of a relational table.
Date posted: July 4, 2018. Answers (1)
- Discuss the advantages and disadvantages of DBMSs.(Solved)
Discuss the advantages and disadvantages of DBMSs.
Date posted: July 4, 2018. Answers (1)
- Describe the functions that should be provided by a modern full-scale multi-user DBMS.(Solved)
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
Date posted: July 4, 2018. Answers (1)
- Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.(Solved)
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.
Date posted: July 4, 2018. Answers (1)
- Describe the five components of the DBMS environment and discuss how they relate to each other(Solved)
Describe the five components of the DBMS environment and discuss how they relate to each other
Date posted: July 4, 2018. Answers (1)
- Describe the main characteristics of the database approach.(Solved)
Describe the main characteristics of the database approach.
Date posted: July 4, 2018. Answers (1)
- Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence
(Solved)
Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence
Date posted: July 4, 2018. Answers (1)
- Outline four types of memory as used in data structures(Solved)
Outline four types of memory as used in data structures.
Date posted: July 3, 2018. Answers (1)
- Define Data structures(Solved)
Define Data structures.
Date posted: July 3, 2018. Answers (1)
- Explain the difference between nominal and real gross domestic product (GDP). (Solved)
Explain the difference between nominal and real gross domestic product (GDP).
Date posted: July 3, 2018. Answers (1)