8.2 Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) …show more content…
Step 9 monitors the database application systems and improves performance by making amendments to the design as appropriate.
16.2 What factors can be used to measure efficiency?
There are a number of factors that we may use to measure efficiency:
• Transaction throughput: this is the number of transactions processed in a given time interval. In some systems, such as airline reservations, high transaction throughput is critical to the overall success of the system.
• Response time: this is the elapsed time for the completion of a single transaction. From a user’s point of view, you want to minimize response time as much as possible. However, there are some factors that influence response time that you may have no control over, such as system loading or communication times. You can shorten response time by: * reducing contention and wait times, particularly disk I/O wait times; * reducing the amount of time resources are required; * using faster components.
• Disk storage: this is the amount of disk space required to store the database files. You may wish to minimize the amount of disk storage