Describe what the term data redundancy means in database design. explain if it is bad and if a normalized

Describe what the term data redundancy means in database design. explain if it is bad and if a normalized database design is always the best design. discuss the pros and cons of a normalized database.

Coates inc. experienced the following events in 2014, in its first year of operation: (1) received $20,000 Steven and Emily Campbell are planning to open a casual dining restaurant in downtown Akron, Ohio, and Roxy operates a dress shop in arlington, virginia. lisa, a maryland resident, comes in for a measurement Asap which statement is true? a. as the risk of an investment decreases, the opportunity of gains increases. Which tool or feature reduces speckling, dust particles, scratches, and minute light FIllmore Company began operations on Sept. 1 by purchasing$6000 of inventory and \$600 of cleaning supplies. During the month,

1. Expert says:

no u can still get a job there u just have to be determined.

2. kaayla20 says:

Data Redundancy:

Data redundancy is a condition created within a database or data storage technology in which the same piece of data is held in two separate places. This can mean two different fields within a single database, or two different spots in multiple software environments or platforms. Whenever data is repeated, this basically constitutes data redundancy. This can occur by accident, but is also done deliberately for backup and recovery purposes.

Pros of a Normalized Database

Updates run quickly due to no data being duplicated in multiple locations.

Also, Inserts run quickly since there is only a single insertion point for a piece of data and no duplication is required.

Cons of a Normalized Database

Since data is not duplicated, table joins are required. This makes quires more complicated, and thus read times are slower.

And, since joins are required, indexing does not work as efficiently.

Again, this makes readtimes slower because the joins don’t typically work well with indexing.

In database design, a normalized database helps remove redundant data. This saves storage space and, more importantly, various data anomalies, such as an insert problem, delete problem, and so forth. However, normalizing a database can create problems. The data retrieval becomes complex and time-consuming. For this reason, a little bit of data redundancy is often desirable and allowable. It makes the data reporting easier. Generally, OLTP (transaction database) has a normalized design and the reporting database, such as a data warehouse, has a highly denormalized design.

3. Expert says:

ed

explanation:

dew