ISYS-307: Mid-Term Exam

When asked to create a table you should try to choose the best type possible for the field. For string keep the standard length of 255. You are not graded on choosing string lengths. Each question is 1/10th of your score. Partial credit will be given.

1. Create a database where the filename is the same as your last name (i.e. heaton.acdb).
2. Create a table that holds the employees of the company. The fields should be first_name, last_name, phone, title, gender, department, and salary. Please use a multi-value field for gender.
3. Create a table that holds the departments of the company. The fields should be department_name.
4. Make sure that the user enters the phone number in the form (636) 555-1212.
5. Update the relationships so that the relation between employee and department is shown. This should be a one (department) to many (employee) relationship.
6. Populate your department table with three departments.
7. Populate your employee table with ten employees. Use data of your choice. Pick data so that each of your queries below will return at least two rows.
8. Create a query that will return the number of employees that make less than $30,000.
9. Create a query that will display the number of female employees.
10. Create a query that will count the total number of employees in each department.