9/11/24, 2:47 Projec
PM t
Data Management - Applications Project (VHT1) 1
Data Management - Applications Project
(VHT1)
My Name
Western Governors University
This paper demonstrates the complete solution of creating models,
databases, tables, and query reports for a Donut shop smartphone
application. To complete this assessment, draw.io website was used
to design tables and E-R models, and MySQL Workbench to test and
run a database application.
For more information, please see following links:
http:ttttwww.draw.io
http:ttttwww.mysql.comttproductsttworkbenchtt
about:bl 1/
,9/11/24, 2:47 Projec
PM t
Data Management - Applications Project (VHT1) 2
Table of Contents
Section A - Designing Tables.............................................................................................................................3
A.1.a (Design of 1NF table)...........................................................................................................................3
A.1.b (Transformation to 2NF).....................................................................................................................4
A.1.c (Transformation to 3NF)......................................................................................................................6
Section B - The E-R Diagram.............................................................................................................................8
Section C – Creating tables with SQL...............................................................................................................9
Creating customer table...............................................................................................................................9
Creating donut table...................................................................................................................................10
Creating donutorder table.........................................................................................................................11
Creating orderline table.............................................................................................................................11
Section D – Create customer VIEW................................................................................................................12
Section E – ADD donut INDEX........................................................................................................................13
Section F – Populate tables with SQL.............................................................................................................14
Populate Customer table...........................................................................................................................14
Populate donut table..................................................................................................................................15
Populate donutorder table.........................................................................................................................16
Populate orderline table............................................................................................................................16
Section G.1 – Testing created tables..............................................................................................................17
Test customer table....................................................................................................................................17
Test donut table..........................................................................................................................................18
Test donutorder table................................................................................................................................19
Test orderline table....................................................................................................................................19
Section G.2 – Create a complex JOIN query..................................................................................................20
about:bl 2/
, 9/11/24, 2:47 Projec
PM t
about:bl 3/
PM t
Data Management - Applications Project (VHT1) 1
Data Management - Applications Project
(VHT1)
My Name
Western Governors University
This paper demonstrates the complete solution of creating models,
databases, tables, and query reports for a Donut shop smartphone
application. To complete this assessment, draw.io website was used
to design tables and E-R models, and MySQL Workbench to test and
run a database application.
For more information, please see following links:
http:ttttwww.draw.io
http:ttttwww.mysql.comttproductsttworkbenchtt
about:bl 1/
,9/11/24, 2:47 Projec
PM t
Data Management - Applications Project (VHT1) 2
Table of Contents
Section A - Designing Tables.............................................................................................................................3
A.1.a (Design of 1NF table)...........................................................................................................................3
A.1.b (Transformation to 2NF).....................................................................................................................4
A.1.c (Transformation to 3NF)......................................................................................................................6
Section B - The E-R Diagram.............................................................................................................................8
Section C – Creating tables with SQL...............................................................................................................9
Creating customer table...............................................................................................................................9
Creating donut table...................................................................................................................................10
Creating donutorder table.........................................................................................................................11
Creating orderline table.............................................................................................................................11
Section D – Create customer VIEW................................................................................................................12
Section E – ADD donut INDEX........................................................................................................................13
Section F – Populate tables with SQL.............................................................................................................14
Populate Customer table...........................................................................................................................14
Populate donut table..................................................................................................................................15
Populate donutorder table.........................................................................................................................16
Populate orderline table............................................................................................................................16
Section G.1 – Testing created tables..............................................................................................................17
Test customer table....................................................................................................................................17
Test donut table..........................................................................................................................................18
Test donutorder table................................................................................................................................19
Test orderline table....................................................................................................................................19
Section G.2 – Create a complex JOIN query..................................................................................................20
about:bl 2/
, 9/11/24, 2:47 Projec
PM t
about:bl 3/
