Webster would like for a student's program plan data to be entered using an on-line input form and stored in a database. Then, a program plan report similar to the manual worksheet (at the above link) could be printed, as required. Review the following prototype design for an automated Program Plan input form and database.
a. List the form and database design problems with this design. Hint: Draw on your knowledge of good user interface and database design concepts and practices from the Chapter 8 and 9 assignments.
b. Develop an improved input form mockup and database table design for a Webster student to enter/store Program Plan data. You do not have to design the output report. Note: MS Access may be used to develop the input form and/or data tables design, but it is not mandatory. You may also follow a similar approach used to answer the chapter 8 and 9 assignment questions.