Typing

DATABASE ACTIVITY 6

1. Create Student Exams database.

2. Create the Student Reg table. Use Student Number as the primary key.

Field Name	Data Type	Field Size
Student Number	Text	5
Student Name	Text	25
Class	Text	3
Exam Subject	Text	20
Exam Score	Number

3. Add the following data to the Student Reg table

Student Number	Student Name	Class	Exam Subject	Exam Score
1121	Geraldine Patrick	5S1	Mathematics	62
1235	Kamini Bissoo	5B1	Mathematics	58
1122	Smithy Grant	5S1	Physics	74
3561	Maurice Grant	5B3	Spanish	89
3325	Donavan Singh	5T2	Mathematics	35
4123	Gavin Lavar	5S1	Food & Nutrition	92
2215	Annie Lawson	5G1	POB	100

4. Create the following queries saving them as Query 1, Query 2, Query 3, Query 4 and Query 5 and Query 6 respectively.

a. What is the subject taken by Kamini Bissoo.

b. List the Student number, Student Name, and Exam Subject for students are registered for Mathematics.

c. List the Student number, Student Name, and Exam Subject for students are registered for Spanish or POB.

d. What are the names of the students are in class 5S1

e. List the Student number, Student Name, and exam score for students who received an exam score above 65

f. List the Student number, Student Name, and exam score for students who received an exam score below 60