1. Who usually does physical database design? Why would a specialist perform this task? Can SEs do physical database design as well? Why or why not? 2. Perform transform analysis on a case in Appendix...

1. Who usually does physical database design? Why would a specialist perform this task? Can SEs do physical database design as well? Why or why not?

2. Perform transform analysis on a case in Appendix A. Design the processing for the central transform from the high-level DFD. Develop lower level DFDs as required to assist your thinking. Factor and develop a first-cut structure chart. Develop pseudo-code for the processes you define. Refine the pseudo-code and finalize the structure chart, giving reasons for your design decisions. Develop program specifications and identify how the modules will be packaged. Make sure that you state your assumptions about the production environment clearly as part of the explanation of your decisions.