Business, 24.12.2019 01:31 kyliech023

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.

Answers: 3

Show answers

Answers

Answer from: bmthkaylani

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.

Answer from: Quest

there was no passage listed but using the process of elimination i'd say it was d. the high economy would do the opposite. i don't see how low prices would affect it. high unemployment is possible but i feel d is the better answer.

Answer from: Quest

answer; importance to people; or acceptance;

Another question on Business

Business, 22.06.2019 00:00

Which part/word/phrase in the passage refers to a business’s financing activity seen in a cash flow statement? nathan works as an accountant in a footwear manufacturing company. he is currently preparing the cash flow statement for his employer. during the given accounting period, the company purchased raw materials worth $25,000. it also bought new equipment worth $75,000 to increase its production output. further, it borrowed a long-term bank loan of $100,000 to facilitate further expansion. finally, the company spent $50,000 on advertising its latest brand of footwear in the market. {lol i guessed its "it borrowed a long-term bank loan of $100,000 to facilitate further expansion" and thats correct}

Answers: 1

Answer

Business, 22.06.2019 03:00

For each separate case below, follow the 3-step process for adjusting the prepaid asset account at december 31. step 1: determine what the current account balance equals. step 2: determine what the current account balance should equal. step 3: record the december 31 adjusting entry to get from step 1 to step 2. assume no other adjusting entries are made during the year. a. prepaid insurance. the prepaid insurance account has a $4,700 debit balance to start the year. a re- view of insurance policies and payments shows that $900 of unexpired insurance remains at year-end. b. prepaid insurance. the prepaid insurance account has a $5,890 debit balance at the start of the year. a review of insurance policies and payments shows $1,040 of insurance has expired by year-end. c.prepaidrent.onseptember1ofthecurrentyear,thecompanyprepaid$24,000 for 2 years of rentfor facilities being occupied that day. the company debited prepaid rent and credited cash for $24,000.

Answers: 3

Answer

Business, 22.06.2019 13:30

Presented below is information for annie company for the month of march 2018. cost of goods sold $245,000 rent expense $ 36,000 freight-out 7,000 sales discounts 8,000 insurance expense 5,000 sales returns and allowances 11,000 salaries and wages expense 63,000 sales revenue 410,000 instructions prepare the income statement.

Answers: 2

Answer

Business, 22.06.2019 15:40

Brandt enterprises is considering a new project that has a cost of $1,000,000, and the cfo set up the following simple decision tree to show its three most likely scenarios. the firm could arrange with its work force and suppliers to cease operations at the end of year 1 should it choose to do so, but to obtain this abandonment option, it would have to make a payment to those parties. how much is the option to abandon worth to the firm?

Answers: 1

Answer

You know the right answer?

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

Questions