Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Currently, it order to obtain personal information for a student, several tables must be joined into the query.  The name is in one table, the address is in another, campus email is in another (with an outer join, as it may not exist), sex is in another, military status is in another.  This makes for complicated queries which stresses the system unnecessarily.  Also, it makes the task of writing simple queries more cumbersome, especially for the novice query writer and other non tech query writer as well.  This new view would ease the process for obtaining a student's personal data - it would be in one view.  In addition, modification of queries in future will be much simpler for query writers as well.

Proposed SQL or other technical documentation

...