i need help with these to questions 144 The designers of a database information system that...
i
need help with this questions
se of Exercise 14.4, the analyst measured the elapsed 243 sure read operatioompl44 of num In the second phase the In ond phas of the complexity of the query. The complexity was functf keywords in the query. The number of disk- Exerci also measured, as shown in Table 14.5. For this models to predict the elapsed time as a function re regression re data imber of keywords and interpret the result obtained sented in...
subject. Database system
i need the answer for 8 & 9 please.
8. Improve the performance and backup plan for the CUNY database. This database student records enrolled in 24 Colleges. Propose four recommendations to correct or ems identified. You have no budget to purchase additional hardware. You need to make recommendations using hardware already available (15 points) includes 400,000 You will be evaluated based on your improvements in a) performance, b) security, c) backup and d) hardware utilization. You...
I need a response in your opinion, from this answer Q1. Any user accessing the database is more interested in quick and correct result than how a database is designed. Hence if we introduce redundancy in the table and if the performance of the query increases, then we can ignore 3NF. This is known as denormalization. In this process, a normalized table will be rejoined to have the redundancy in the table to increase the performance of the query. Denormalization...