CREATE A DATABASE USING SQL IN MICROSOFT ACCESS
PRACTICE EXERCISE #1:
Write the SQL code that will create the table structure for the table named Employee. The table employee stores the attributes:
EMP_NUM CHAR(3), EMP_LNAME CHAR(15), EMP_FNAME CHAR(15), EMP_INITIAL CHAR (1), EMP_HIREDATE DATE, JOB_CODE CHAR(3)
The primary key for the employees table should be the employee number.
CREATE TABLE EMPLOYEE
)
EMP_NUM CHAR(3), PRIMARY KEY
EMP_LNAME CHAR(15),
EMP_FNAME CHAR(15),
EMP_INITIAL CHAR (1),
EMP_HIREDATE DATE,
JOB_CODE CHAR(3)
);
PRACTICE EXERCISE #2:
Write the SQL code to enter the two rows for the table shown in Fig. 1
Figure 1. Contents of Employee EMP_NUM | EMP_LNAME | EMP_FNAME | EMP_INITIAL | EMP_HIREDATE | JOB_CODE | 102 | Senior | David | H | 12-Jul-89 | 501 | 101 | News | John | G | 08-Nov-14 | 502 |

PRACTICE EXERCISE #3:
Write the SQL code that will list all the attributes in the table Employee.
PRACTICE EXERCISE #4:
Write the SQL code that will list all the attributes for a job_code of 502.

PRACTICE EXERCISE #5:

Write the SQL code required to list all employees that were hired after 12/31/2013

PRACTICE EXERCISE #6:
Write the SQL code to create a copy of Employee, naming the copy Employee_2.

PRACTICE EXERCISE #7:
Write the SQL code to count the number of employees in the table Employee
PRACTICE EXERCISE #8:
Write the SQL code required to list the employee with a job code = 502 and hire date = 8-11-14

PRACTICE EXERCISE #9:
Write the SQL code required to create a table including the job code (CHAR(3)), description (CHAR(30)) and charge per hour (CURRENCY).

PRACTICE EXERCISE #10:
Write the SQL code to enter the two rows for the table shown in Fig. 2
Figure 2 Contents of Job JOB_CODE | JOB_DESC | CHG_HOUR | 502 | Programmer | $95.00 | 500 | System Analyst | $150.00 |

PRACTICE EXERCISE #11: