Previous Page
Next Page

1.20. Exercises

The tables available in the Student_course database are shown in Appendix A.

  1. The Student_course database contains the following tables: Student, Dependent, Grade_report, Section, Department, Course, Prereq, Room, Cap, Plants.

    1. View the table definition of each of these tables.

    2. View the data of each of these tables. Save your results to a file and print them out.

  2. Write a SQL query to view all the columns and rows in the Student table. (Hint: To retrieve all columns, use SELECT * in your query; the * means "all columns"). Save and execute the query. Save the results to a file and print out the results.


Previous Page
Next Page