====== Requirements Analysis ======
===== Space Requirements =====
Entire access database size: 19,931 KB

===== Amount of Data =====
39 tables total
3 local tables
12 Linked Tables from another MDB file
24 ODBC Linked Tables from SIS Shadow

9 major tables, with rows x cols of 2739x22, 2953x12, 1744x22, 1211x34, 527x27, 100x5, 8x2, 5x2, 5x2

===== Growth Pattern =====
New data is added when new students attend the Graduate School and when current students reach new accomplishments in the progression of their degrees. Old / expired students are most likely not removed. The growth pattern of the data depends on the growth of the University, but the number of records is constantly growing or staying somewhere in the same vicinity of growth each year.

===== Database Access =====
==== Admin Access ====
3-4 users. IT Specialist, IT helper, Data Coordinator.

==== Write Access ====
5-7 users. The Associate Deans office and it's subsidy office will make up most of the users, along with a few rotating student workers.

==== Read Access ====
Same as the write access above.

===== Table Schema =====
{{projects:progression:progressionsrelationship.png}}