Database Design Institute.mdb + course text

In the process of performing an analysis of the requirements for the information system, the composition of the input information was determined, which includes: data on the departments of the design institute; data on the offices of the design institute; job data; employee data; data on activities; additional information about the employee. The required information is contained in the accounting, organizational, administrative and reference documents of the design institute: regulations on subdivisions; regulations on document circulation; personal files of employees; accounting invoices and statements.

Content

2 introduction
1. Structural systems analysis 3
1.1. Domain analysis 3
1.2. Analysis of information system requirements 4
1.3. Terms of reference for the development of IS 5
2. Data flow diagrams 7
2.1. Context Diagram 7
2.2. Decomposed Diagram 8
3. Infological data model 10
4. Physical structure of a relational database 13
5. Database interface 15
Conclusion 27
List of sources used 29
Appendices 30