Unit 18: Database Design
Assignment 3: Implementing the Database
Designed for Mia’s sandwich shop
Dominic Jeffrey
CAROL CUSWORTH Edexcel BTEC Level 3 90 Credit Diploma in Information Technology
, Dominic Jeffrey
Contents
Introduction/Scenario............................................................................................................................3
Task 1.....................................................................................................................................................4
Create and populate a database (P3).................................................................................................4
Task 2...................................................................................................................................................13
Import data from an external source (M2)......................................................................................13
Task 3...................................................................................................................................................23
Perform queries using multiple tables and multiple criteria (P5).....................................................23
Task 4...................................................................................................................................................27
Include an advanced feature in a database design (P6)...................................................................27
Implement an automated function (M4).........................................................................................27
Task 5...................................................................................................................................................30
Export data from an external source (M3).......................................................................................30
Task 6...................................................................................................................................................33
Test a relational database (P7).........................................................................................................33
Task 7...................................................................................................................................................35
Evaluate a database against the specified user need (D2)...............................................................35
List of Figures
Figure 1 All Access Objects/Database Index...........................................................................................5
Figure 2 Customer Table........................................................................................................................6
Figure 3 Delivery Table...........................................................................................................................6
Figure 4 Order Table..............................................................................................................................6
Figure 5 Sandwich Table........................................................................................................................7
Figure 6 Shop Table................................................................................................................................7
Figure 7 Staff Table.................................................................................................................................8
Figure 8 Outstanding Payments Query..................................................................................................8
Figure 9 Total Sandwiches Sold Query...................................................................................................9
Figure 10 Customer Form......................................................................................................................9
Figure 11 Main Menu/Switchboard.....................................................................................................10
Figure 12 Order Form...........................................................................................................................10
Figure 13 Sandwich Form.....................................................................................................................11
1
Assignment 3: Implementing the Database
Designed for Mia’s sandwich shop
Dominic Jeffrey
CAROL CUSWORTH Edexcel BTEC Level 3 90 Credit Diploma in Information Technology
, Dominic Jeffrey
Contents
Introduction/Scenario............................................................................................................................3
Task 1.....................................................................................................................................................4
Create and populate a database (P3).................................................................................................4
Task 2...................................................................................................................................................13
Import data from an external source (M2)......................................................................................13
Task 3...................................................................................................................................................23
Perform queries using multiple tables and multiple criteria (P5).....................................................23
Task 4...................................................................................................................................................27
Include an advanced feature in a database design (P6)...................................................................27
Implement an automated function (M4).........................................................................................27
Task 5...................................................................................................................................................30
Export data from an external source (M3).......................................................................................30
Task 6...................................................................................................................................................33
Test a relational database (P7).........................................................................................................33
Task 7...................................................................................................................................................35
Evaluate a database against the specified user need (D2)...............................................................35
List of Figures
Figure 1 All Access Objects/Database Index...........................................................................................5
Figure 2 Customer Table........................................................................................................................6
Figure 3 Delivery Table...........................................................................................................................6
Figure 4 Order Table..............................................................................................................................6
Figure 5 Sandwich Table........................................................................................................................7
Figure 6 Shop Table................................................................................................................................7
Figure 7 Staff Table.................................................................................................................................8
Figure 8 Outstanding Payments Query..................................................................................................8
Figure 9 Total Sandwiches Sold Query...................................................................................................9
Figure 10 Customer Form......................................................................................................................9
Figure 11 Main Menu/Switchboard.....................................................................................................10
Figure 12 Order Form...........................................................................................................................10
Figure 13 Sandwich Form.....................................................................................................................11
1
