Introduction to Relational
Databases
Dominic Jeffrey
Unit 18: Database Design
Tutor: Carol Cusworth
Due Date: 25/01/17
DC Consultancy
, Table of Contents
Figures...................................................................................................................................................1
Introduction/Scenario............................................................................................................................2
Task 1 (P1, M1, D1)................................................................................................................................2
What is a Relational Database?.........................................................................................................2
(P1) Features of a Relational Database..............................................................................................2
Entities:..........................................................................................................................................2
Attributes:......................................................................................................................................2
Relationships:.................................................................................................................................4
Benefits:.........................................................................................................................................5
(M1) The Concept of Referential Integrity.........................................................................................6
Example of Referential Integrity.....................................................................................................6
Advantages of Referential Integrity................................................................................................7
(D1) Common Errors in Database Design and Construction...............................................................7
Conclusion.........................................................................................................................................8
Bibliography.......................................................................................................................................8
Figures
Figure 1 Attributes.................................................................................................................................3
Figure 2 Validation Rules........................................................................................................................3
Figure 3 Relationships............................................................................................................................5
Databases
Dominic Jeffrey
Unit 18: Database Design
Tutor: Carol Cusworth
Due Date: 25/01/17
DC Consultancy
, Table of Contents
Figures...................................................................................................................................................1
Introduction/Scenario............................................................................................................................2
Task 1 (P1, M1, D1)................................................................................................................................2
What is a Relational Database?.........................................................................................................2
(P1) Features of a Relational Database..............................................................................................2
Entities:..........................................................................................................................................2
Attributes:......................................................................................................................................2
Relationships:.................................................................................................................................4
Benefits:.........................................................................................................................................5
(M1) The Concept of Referential Integrity.........................................................................................6
Example of Referential Integrity.....................................................................................................6
Advantages of Referential Integrity................................................................................................7
(D1) Common Errors in Database Design and Construction...............................................................7
Conclusion.........................................................................................................................................8
Bibliography.......................................................................................................................................8
Figures
Figure 1 Attributes.................................................................................................................................3
Figure 2 Validation Rules........................................................................................................................3
Figure 3 Relationships............................................................................................................................5
