Database - Design & Implementation

Running head: DATABASE DESIGN AND IMPLEMENTATION
Database Design and Implementation
Name of the Student:
Name of the University:
Author Note

1
DATABASE DESIGN AND IMPLEMENTATION
Part A
ER Diagram
Part B
SQL queries
Query 1
+-------------------------------------+-----------------+
| CompanyName | Fullname |
+-------------------------------------+-----------------+
| 3M Tapes & Adhesive Division | GlennMortimer |

2
DATABASE DESIGN AND IMPLEMENTATION
| Freightcorp | GlennStephens |
| Industrial Packaging Systems Pty Lt | WarrenJennings |
| Siemens Ltd - Industrial Automatio | GarryRussell |
| Visy Industrial Packaging | ElizabethWilson |
| AMTAS Pty Ltd | AllanRussell |
| ActionLaser Pty Ltd | StephenMorris |
+-------------------------------------+-----------------+
7 rows in set (0.00 sec)
Query 2
MariaDB [express media]> SELECT
orderdetails.`OrderID`,orderdetails.`UnitPrice`,orderdetails.`Production`
-> FROM `orderdetails` Join pagesize On orderdetails.PageSize =
pagesize.PageSize
-> WHERE PageSize.PageValue = "Full Page" and orderdetails.UnitPrice > 0;
Empty set (0.00 sec)
Query 3
MariaDB [express media]> SELECT (`UnitPrice`+`Production`+`GST`) As TotalPrice
FROM `orderdetails` Order by TotalPrice;
+------------+
| TotalPrice |
+------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |