Principles of Data Management

Figures and tables

Table

Figure 1.1	The relationship between data and information	4
Figure 2.1	A model of a database system	12
Figure 2.2	The three level schema architecture	15
Figure 2.3	A simplified view of the database development process	17
Figure 2.4	A conceptual data model diagram	18
Figure 2.5	A portion of an SQL create script	19
Figure 2.6	The EMPLOYEE entity	21
Figure 2.7	The attributes of the EMPLOYEE entity	22
Figure 2.8	The ADDRESS entity	23
Figure 2.9	The ‘resident at ’ relationship	24
Figure 2.10	The QUALIFICATION and EMPLOYEE QUALIFICATION entities	26
Figure 2.11	The GRADE and EMPLOYEE GRADE entities	27
Figure 2.12	The DEPARTMENT and ASSIGNMENT entities	28
Figure 2.13	The one-to-one ‘managed by’ relationship	29
Figure 2.14	The many-to-many ‘managed by’ relationship	30