Part 1: Use phpMyAdmin to create a database, HR, that contains two tables:
Department table: DID, DeptName, DeptPhone, DeptEmail
Employee table: EmpID, EMpName, Sex, Salary, HireDate, DID
You choose the appropriate data type and field size for each column and enter 2 department records and about 5 employee records.
Then, use phpMyAdmin to run this SQL statement: select * from department natural join employee;
Submit the output of the SQL statement.
Part 2: Download the MySQLOrder.txt file from my website: https://online.sfsu.edu/dchao/
Then use either MySQL command prompt or phpMyAdmin to run the command file to create a database named: SalesDB
Use SQL statements to answer the following questions from the SalesDB:
1. Retrieve the records of customers who have rating A or customers live in Chicago.
2. Retrieve the orders handled by salesperson Strong that are placed after 2013-06-30.
3. Create a query to show the number of orders for each customer and display: CID, Cname, NumbrOfOrders
4. Create a query to show: PID, Pname, TotalSalesTurn in the query design windows and results.
Submit the SQL statements with results.