Unit 18: Assignment 2
Designing a Relational Database
Edexcel BTEC Level 3 90 Credit Diploma in Information Technology
Carol Cusworth
Dominic Jeffrey
, Contents
Introduction/Scenario............................................................................................................................2
Task 1 (P2, CT1)......................................................................................................................................3
Evidence of Normalisation to 3rd Normal Form......................................................................................3
ERD (Entity Relationship Diagram).........................................................................................................4
Data Dictionary......................................................................................................................................4
Customer Table..................................................................................................................................4
...........................................................................................................................................................4
Delivery Table....................................................................................................................................5
...........................................................................................................................................................5
Order Table........................................................................................................................................6
...........................................................................................................................................................6
Sandwich Table..................................................................................................................................6
...........................................................................................................................................................6
Shop Table.........................................................................................................................................6
...........................................................................................................................................................6
Staff Table..........................................................................................................................................6
...........................................................................................................................................................6
Data Integrity.........................................................................................................................................6
Dominic Jeffrey Page 1
Designing a Relational Database
Edexcel BTEC Level 3 90 Credit Diploma in Information Technology
Carol Cusworth
Dominic Jeffrey
, Contents
Introduction/Scenario............................................................................................................................2
Task 1 (P2, CT1)......................................................................................................................................3
Evidence of Normalisation to 3rd Normal Form......................................................................................3
ERD (Entity Relationship Diagram).........................................................................................................4
Data Dictionary......................................................................................................................................4
Customer Table..................................................................................................................................4
...........................................................................................................................................................4
Delivery Table....................................................................................................................................5
...........................................................................................................................................................5
Order Table........................................................................................................................................6
...........................................................................................................................................................6
Sandwich Table..................................................................................................................................6
...........................................................................................................................................................6
Shop Table.........................................................................................................................................6
...........................................................................................................................................................6
Staff Table..........................................................................................................................................6
...........................................................................................................................................................6
Data Integrity.........................................................................................................................................6
Dominic Jeffrey Page 1
