Essay on SQL Lab1

Submitted By adams34
Words: 571
Pages: 3

SECTION ONE

In Section One we will create the Person table illustrated below:

This Person table has three columns -- person_id, first_name, and last_name -- with data types specified in the diagram above.

2. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

4. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

6. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

8. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

10. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

12. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

14. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

16. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

18. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown.

SECTION TWO

The goal of Section Two is to apply what is learned in Section 1 to create and populate the following table:

This Book table has three columns -- book_id, title, and subtitle -- with data types specified in the diagram above.

20. Capture a screenshot of the command to create the Book table. Include the results of the command’s execution.

22. Capture a screenshot of the command which inserts a row with values book_id = 101, title = Art, and subtitle = Modernized. Include the results of the command’s execution.

24. Capture a screenshot of the command to select all rows in the table. Include the results of the command’s execution.

26. Capture a screenshot of the command which updates the subtitle from “Modernized” to “Revisited”. Include the results of the command’s execution.

28. Capture a screenshot of the