Contents

  Download as PDF (122KB) 

1 Database documentation series

2 Ageing programmes.

3 Data structures

3.1 Table relationships

3.2 Database design

3.3 Handling different sampling programmes

3.4 Null Values and sub_catch_no in the Primary Key.

4 Table Summaries

5 age Tables

5.1 Table 1: t_trip

5.2 Table 2: t_fish

5.3 Table 3: t_reading

5.4 Table 4: t_catalog.....

5.5 Table 5: t_age

5.6 Table 6: t_origin

5.7 Table 7: t_material

5.8 Table 8: t_reader

5.9 Table 9: t_age_meth

6 age Business Rules

6.1 Introduction to business rules

6.2 Summary of rules

Appendix 1 - Reference code tables

7 Acknowledgements

List of Figures

Figure 1: Entity Relationship Diagram (ERD) of the age database

Figure 2: Expanded ERD for t_trip showing foreign key relationships to code tables and top-level tables for other databases

Figure 3: Expanded ERD for the tables t_fish, t_catalog, t_reading, and t_age showing foreign key relationships to code tables

Revision History