CSC239_Lab02-1 (3)

.doc

School

Rutgers University, Newark *

*We aren’t endorsed by this school

Course

239

Subject

Computer Science

Date

Oct 30, 2023

Type

doc

Pages

Uploaded by jackelynbenavides842

Middlesex County College CSC239-60 Computer Science Department Version 5 Lab Assignment Database Concepts Page 1 __________________________________________________________________________________________ C. Activity: 1. Using a web browser, go to the website: academy.oracle.com 2. Select the “Sign In / Register” option. 3. Select the Application Express option to log in 4. Log into Application Express. 5. Select the “SQL Workshop” button. 6. On right side of the window, select “Table” from the “Create Object” group on the right. 7. Click on the Next button. 8. In the Create Table window, click in the textbox for the table name 9. Create a table named ClientsLab2. 10. Build the ClientsLab2 table structure to comprise the following: 11. You will now create a table named ClientsLab2 with the following data types which need to be reformatted based on Oracle data types: Note: For the Client Id, use a Number data type. 12. Determine the data types needed for each column of the table. 13. Input the data records of the ClientsLab2 table is as follows: 14. Add the following records to the table (including the typing errors): Client Id Client Name Year Region Revenue Referred By 9 Peggie Johnson 2017 Qwest 100 Newspaper 10 Brad Williams 2016 North -5000 TV 11 Barbara Baker 2015 South 1100 Spider Ad 12 Tamara Thomas 2100 East 1400 Newspaper 13 Brian Brawnie 2014 South 1000 Unknown

Middlesex County College CSC239-60 Computer Science Department Version 5 Lab Assignment Database Concepts Page 2 __________________________________________________________________________________________ 15. Write the SQL statement to INSERT the following data record: Client Id Client Name Year Region Revenue Referred By 14 (your full name) 2019 East 7000 Web Ad 16. Write the SQL statement that will fix the Region for Peggie Johnson to be: West 17. Write the SQL statement that will fix the Revenue for Brad Williams to be: 5000 18. Write the SQL statement that will fix the Referred By for Barbara Baker to be: Web Ad 19. Write the SQL statement that will fix the Year for Tamara Thomas to be: 2010 20. Delete Brian Brawnie’s record 21. Now that the updates are done, display all the data records you typed in within a columnar format, use the SELECT instruction. 22. Select the option to display table structure. 23. Open Word and at the top line of the document, type out: your full name, CSC239-xx (xx is your section number, Lab02 24. Do a screen print of the table structure and paste it into the Word document. 25. Select the option to display the entire contents of the data table in its original columnar order. 26. Do a screen print of the data table and paste it into the same Word document below the first screen print from the prior steps. 27. Select the option so that the list of the SQL commands typed is displayed. 28. Do a screen print of the list of SQL commands and paste in the Word document below the 2 other screen prints. 29. Save this Word document with the name of Lab02 in your flash drive’s CSC239 folder named CSC239LabAssignments. 30. Print this Word document. 31. Log out of Application Express. 32. Exit out of Word.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version