Top Research Professionals
The research experts and assignment help team consists exclusively of highly qualified graduate writers, each professional with in-depth subject matter expertise and significant experience in custom academic writing.
Boost Your Final Grades By Ordering Custom Writing Help!
For similar papers and sample answers; with a few clicks, Order your research paper, thesis, dissertation writing and other assignment help services
Posted: February 21st, 2023
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
Why Choose our Custom Writing Services
We prioritize delivering top quality work sought by college students.
Discounted Pricing
Our custom writing services maintain the highest quality while remaining affordable for students. Our pricing for research papers, theses, and dissertations is not only fair considering the superior quality but also competitive with other writing services.
0% Similarity Index
We guarantee plagiarism-free, human-written content. Every product is assured to be original and not AI-generated. Our writers, tutors and editors are research experts who ensures the right formating and citation sytles are followed. To note, all the final drafts undergo rigorous plagiarism checks before delivery for submission to ensure authenticity for our valued customers.
How it works
When you decide to place an order with Dissertation Help, here is what happens: