In what cases would you denormalize tables in your database?

1 answer:

6 0

Answer: Denormalize is the mechanism is carried out by addition of the redundant bits in the already normalized database.The data is attached in the form of attributes,adding new tables.

This technique is used in the case of previously normalized data collection which requires improvement in the performance by reducing the errors.The improvement is made by making database readable ,adding group of data in redundant form etc.

When data is to be retrieved quickly then also denormalization is used as by grouping or collecting information into a single table.

You might be interested in

A specific remote device with a fixed IP address must be able to access your computer across the network. It must be able to acc

Softa [21]

IP address as it clearly isn't an application and nor is it a protocol.

6 0

4 years ago

Read 2 more answers

What does place value mean with binary?

mestny [16]

Explanation:

the largest number you can write in binary using only 6 places or 6 digits

7 0

4 years ago

The IT director instructed the systems administrator to build a server to support the accounting department's file growth. The I

Mamont248 [21]

Answer:

Option (C) FAT32 File System Type

Explanation:

FAT32 File System Type cannot be encrypted by the accounting users.
FAT stands for File Allocation Table. It is a file system architecture.
The File Allocation Table is an index table which contains the details about each cluster ( disk storage space ).
By traversing the File Allocation Table, the operating system gets the details the file ( where it is located ) and the size of the file.
The FAT32 file system contains more number of possible clusters.
In this system, 32 bits are used to store the total number of possible clusters.
In FAT32 file system, the transparent encryption is not supported.
So, option (C) is correct.
All other options are wrong options.

3 0

4 years ago

Which is the most likely problem if your computer starts up slowly, has many unwanted pop-up advertisements, and unusual hard

jeka94

You have a virus you should download malwarebytes free it covers everything

7 0

3 years ago

If Number = 7, what will be displayed after code corresponding to the following pseudocode is run? (In the answer options, new l

kherson [118]

Answer:

5,10; 6,12; 7,14

Explanation:

We will demonstrate the iteration of the loop:

First iteration: Number = 7, Count = 5 at the beginning. We will check if Count <= Number? Since it is correct, prints 5,10. Increment the Count by 1.

Second iteration: Number = 7, Count = 6. We will check if Count <= Number? Since it is correct, prints 6,12. Increment the Count by 1.

Third iteration: Number = 7, Count = 7. We will check if Count <= Number? Since it is correct, prints 7,14. Increment the Count by 1.

Forth iteration: Number = 7, Count = 8. We will check if Count <= Number? Since it is not correct, the loop stops.

8 0

3 years ago