In-lab Exercise (November 8th, 2019)

Download lab08_en.accdb at here and do the following:

1. Add a field "Faculty" to the Student table
2. Enter a few students into Student table, you must be one of the entries. The students should have varied GPA values, at least one in the range of 1.0-2.0, and another in the range of 2.0-30. Your list of students should not be the same as your classmate's.
3. Create another table "Course", with the following field:
   • Course ID, a short text of 6 bytes. This is the primary key.
   • Course Name, a short text of 20 bytes.
   • Credit, a number of integer subtype (field size)
   • Exam time, a Date/Time.

Submission

Save the database to file with LAB08_inlab_studentid.accdb as the file’s name. For example, LAB08_inlab_500510111.accdb. Then, upload the file to homework submission website (http://hw.cs.science.cmu.ac.th), under your section.

Take-home assignment (due November 21st, 2019)

From you lab 08 inlab work, add the following queries:

1. Create a query that display first name and last name of all student with GPA lower than 2.0. Name it Query 1
2. Create a query that display first name and last name and GPA of all male student with GPA lower than 2.0. Name it Query 2
3. Create a query that display first name and last name and GPA of all female student with GPA between 1.0 and 3.0. Name it Query 3

Submission

Save the database to file with LAB08_takehome_studentid.accdb as the file’s name. For example, LAB08_takehome_500510111.accdb. Then, upload the file to homework submission website (http://hw.cs.science.cmu.ac.th), under your section.