Assignment: Database Activity
I. Create Student Exams database.
II. 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
|
|
III. 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
|
IV. Create the following queries saving them as Query 1, Query 2, Query 3, Query 4 and Query 5 and Query 6 respectively.
• What is the subject taken by Kamini Bissoo.
• List the Student number, Student Name, and Exam Subject for students are registered for Mathematics.
• List the Student number, Student Name, and Exam Subject for students are registered for Spanish or POB.
• What are the names of the students are in class 5S1
• List the Student number, Student Name, and exam score for students who received an exam score above 65
• List the Student number, Student Name, and exam score for students who received an exam score below 60
Format your assignment according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the assignment, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.