Your assignment is to develop a simple student record keeping system. You need to keep the following:

Student id

Student name (store last and middle initial and first in separate fields)

Major

Name of the major

Date enrolled

Courses taken

Semester course taken

Grades on the courses taken

Name of the course

Assignment: Note that you can combine things. For example the query using 2 tables can also use the AND and the concatenation etc. LABEL things so I know what you did.

• I see this as needing 4 tables. Set up the 4 tables and put data into them.
• Establish the relationship between the tables.
• Do a query using two tables.
• Do a query using three tables.
• Do a query using all four tables
• Do a query where you change the field names in the results
• Do a query where you concatenate the name as last, first middle
• Do a query using an AND
• Do a query using an OR - do it two ways
• Do a query using a cond1 AND either cond2 or cond3
• Do a calculation within the query to create a column with the answer