Exercise 5
docx
keyboard_arrow_up
School
Georgia State University *
*We aren’t endorsed by this school
Course
101
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by fgndfhsbds
Exercise 5
Copy this file and open it in Word or some other editor where you can insert images. Be sure to read "
How to Copy the Results of a Query
" found in Module 2 in Canvas. This is how you will be answering the following questions.
Using the Premier Products database:
1.
Add a new sales rep named Tina Webb with a number of 85. When complete, type your
construct here. Then, display the contents of the rep table. Insert your query and results here. Be sure all columns display.
2.
Change Tina Webb’s last name to Perry. When complete, type your construct here. Then, display the contents of the rep table. Insert your query and results here.
3.
Delete sales rep 85. When complete, copy and paste your construct here. Then, display
the contents of the rep table. Insert your query and results here.
4.
Change the name of customer 842 to All Season Sport. Copy and paste your construct here. Then, display the customer table. Insert your query and results here.
5.
Change the description of part BV06 to “Fitness Gym”. Insert your query and results here.
Using the Classes database, answer the following questions:
6.
Becca missed class on September 15, 2015. Insert this absence into the absences table. Insert your query and results here.
7.
A correction was made to Aubrey’s quiz taken on Sept. 16. The score will be changed from a 9 to a 10. Make this correction to the database, then display contents of the scores table. Insert your query and results here.
8.
A new student has come to class. Add the following information: Student Name: Rachel Gender: F. Insert your query and results here.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
9.
Rachel will no longer be in class. Remove her record from the database. Insert your query and results here.
10. A new quiz will be given to students on October 15, 2015. Insert your query and results here.