Question

In: Computer Science

d- What is the purpose of a feasibility study (or feasibility analysis)? e- What is one...

d- What is the purpose of a feasibility study (or feasibility analysis)?

e- What is one advantage and one disadvantage of a centralized database compared to a distributed database?

f- What is the deletion anomaly problem that databases try to avoid?

g- One problem that good database designs try to solve is the "data insertion problem." What is the data insertion problem?

Solutions

Expert Solution

d- What is the purpose of a feasibility study (or feasibility analysis)?


Feasibility study is the feasibility analysis or it is a measure of the project in terms of how much beneficial product development will be for the organization in a practical point of view. Feasibility study is carried out based on many purposes to analyze whether software product will be right in terms of development, implantation, contribution of project to the organization etc.
Feasibility study is so important stage as after completion of feasibility study it gives a conclusion of whether to go ahead with proposed project as it is practically feasible or to stop proposed project here as it is not right/feasible to develop or to think/analyze about proposed project again. Along with this Feasibility study helps in identifying risk factors involved in developing and deploying system and planning for risk analysis also narrows the business alternatives and enhance success rate analyzing different parameters associated with proposed project development.

e- What is one advantage and one disadvantage of a centralized database compared to a distributed database?

A centralized database is basically a type of database that is stored, located as well as maintained at a single location only. This type of database is modified and managed from that location itself. This location is thus mainly any database system or a centralized computer system.

When centralized databse is compared to distributed database, The data access time in case of multiple users is more in a centralized database, while the data access time in case of multiple users is less in a distributed database which is considered as a disadvantage when it comes to centralized database.

The management, modification and backup of centralized database is easier as entire data is present at the same location but the same for distributed database is very difficult as it is spread across different physical locations. This is considered as an advantage when it comes to centralized database.

f- What is the deletion anomaly problem that databases try to avoid?

A deletion anomaly occurs when you delete a record that may contain attributes that shouldn’t be deleted. Deletion anomalies happen when the deletion of unwanted information causes desired information to be deleted as well. For example, if a single database record contains information about a particular product along with information about a salesperson for the company and the salesperson quits, then information about the product is deleted along with salesperson information. To avoid these kinds of deletion problems, we need to decompose the original table into several smaller tables where each table has minimal overlap with other tables.

g- One problem that good database designs try to solve is the "data insertion problem." What is the data insertion problem?

Data insertion problems contributes to the creation of redundant data. Redundancy means having multiple copies of same data in the database. This problem arises when a database is not normalized. Data redundancy is the existence of data that is additional to the actual data and permits correction of errors in stored or transmitted data. The additional data can simply be a complete copy of the actual data, or only select pieces of data that allow detection of errors and reconstruction of lost or damaged data up to a certain level. Data redundancy leads to data anomalies and corruption and generally should be avoided by design. Applying database normalization prevents redundancy and makes the best possible usage of storage. An Insert Anomaly occurs when attributes cannot be inserted into the database without the presence of other attributes.


Related Solutions

What are the four steps in a feasibility study and describe each one?
What are the four steps in a feasibility study and describe each one?
7. A feasibility study evaluates the project's potential for success. One of the feasibility studies is...
7. A feasibility study evaluates the project's potential for success. One of the feasibility studies is technological feasibility. What need to be considered in technological feasibility? Please give one example to explain.
You are asked to conduct a five-year economic feasibility study of an e-commerce site for a...
You are asked to conduct a five-year economic feasibility study of an e-commerce site for a small office supply company. Due to construction time, the system will only be in operation for 6 months for the current year (Year 1). Once the system is in operation, you expect to reduce staff cost by $37,000 and to reduce printing/postage cost by $12,000 for a full year of operation between year 1 and year 3. The numbers will be $38,000 and $15,000,...
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what...
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what proportion of the progeny will phenotypically resemble the first parent? b) what proportion of the progeny will genotypically resemble neither parent?
what are the analysis of the 4 feasibility elements for a small business which is (...
what are the analysis of the 4 feasibility elements for a small business which is ( salon on the go) it is salon beauty on car ?
Suppose that D and E are sets, and D ⊆ E. Let A = P(E). Recall...
Suppose that D and E are sets, and D ⊆ E. Let A = P(E). Recall that P(E) denotes the set of all subsets of E. Define a relation R on A by R = {(X, Y) ∈ A × A: [(X − Y) ∪ (Y − X)] ⊆ D}. So, XRY if and only if [(X−Y) ∪ (Y −X)] ⊆ D. Prove that R is an equivalence relation on A.
Suppose that A = D + E and that D/A = 0.68. Solve for A/E. Suppose...
Suppose that A = D + E and that D/A = 0.68. Solve for A/E. Suppose that A = D + E and that D/A = 0.24. Solve for D/E. Suppose that D + E = A, that N/A = .15 and that D/A = 0.72. Solve for N/E. Suppose that S/A = 8.4 and N/S = .0925. Solve for N/A. Suppose A – D = E, that N = 21,000, E/A = .75 and N/E = .40. Compute D/A....
Discuss the importance of pre-feasibility, feasibility studies and technical analysis is ensuring success in the operational...
Discuss the importance of pre-feasibility, feasibility studies and technical analysis is ensuring success in the operational phase of the project.
Discuss the importance of pre-feasibility, feasibility studies and technical analysis is ensuring success in the operational...
Discuss the importance of pre-feasibility, feasibility studies and technical analysis is ensuring success in the operational phase of the project. i want very long and Professional answer please
What is the purpose of break even Analysis?
What is the purpose of break even Analysis?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT