Question: ASAP 11. For this lab test: a. You can build the table structures, modify the table structures, and type in the original data in each

ASAP
ASAP 11. For this lab test: a. You can build the table
structures, modify the table structures, and type in the original data in

11. For this lab test: a. You can build the table structures, modify the table structures, and type in the original data in each table directly without using SQL statements, b. The other steps will require SQL statements when they ask for them. c. When doing the required sereen prints, be sure that your Applications Express User Id is visible in the upper right hand corner of your screen prints. 12. Build the following table, it's primary key, and insert the data directly into the table withnut noing SQL: 13. Do a screen print of the StudentTable table structure. 14. Do a screen print of the data in the StudentTable. 15. Add a field called Country to the StudentTable after all of the other table fields without using SQL. 16. Using SQL, put the country of "USA" into the Country field of both Student records. 17. Using SQL, change the spelling of the last name of "Fern" to "Fine" in Student Record \#2. 18. Do a screen print of the entire revised StudentTable data and its' contents. 19. Build the following second table and associated kevs and insert the data into it without neine enL: 20. Do a screen print of the BillingTable table structure. 21. Do a screen print of the data in the BillingTable. 22. Using SQL, display all of the fields for all of the records from the BillingTable that have an InvoiceAmount of $200.00 or higher, sorted from lowest to highest by InvoiceAmount. 23. Do a screen print of the SQL and the output from the prior step. 24. Using SQL, delete record #4 (with the InvoiceId 6666) in the BillingTable. 25. Do a screen print of the data of the updated BillingTable. 26. Using SQL, display the following combination of fields from both data tables in the following order for each row of the output: StudentId, StudentLastName, StudentFirstName, InvoiceId. InvoiceAmount. The data should be sorted by StudentId. 27. Do a sereen print of the SQL and the output from the prior step

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!