Table of Contents

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 2739×22, 2953×12, 1744×22, 1211×34, 527×27, 100×5, 8×2, 5×2, 5×2

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