Question
Suppose we have the following two tables (pk is in bold): EMP ( E# , Ename, Address, D#) SAL_HISTORY ( E#, Raise# , Salary, Raise_Date,
Suppose we have the following two tables (pk is in bold):
EMP (E#, Ename, Address, D#)
SAL_HISTORY (E#, Raise#, Salary, Raise_Date, Reason)
Assume that 90% of queries involving salary is based on the most recent salary. How could you denormalize the above tables to improve the performance.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
101 Database Exercises Text Workbook
Authors: McGraw-Hill
2nd Edition
0028007484, 978-0028007489
