Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercises for Chapter 1 s you do these exercises, save and print your SQL output using SPOOL and then copy and paste your SQL itput
Exercises for Chapter 1 s you do these exercises, save and print your SQL output using SPOOL and then copy and paste your SQL itput into a word processor from which you can save and print your output. We suggest you use the "copy ad paste" method to hand in your exercises. To keep a complete record of your work, it is a good idea to py/paste your query as well as your query result. 1-1. Print a description of the Course table (use DESC Course). Use the SELECT statement to display the actual data. (Just a reminder - you will have to use "rearp." in front of all the table names, since you are not the owner of these tables. So, you will have to type in rearp.Course instead of just Course in your query). 1-2. Create a synonym for the Student table. Display the table description using the synonym. Display all the data in the Student table using SELECT. 1-3. We have supplied a Student-Course database with the following tables (these tables are shown in Appendix 3): Student Course Section Prereq (for prerequisite) Grade_report Department_to_major Room There are also tables, such as Cap and Plants, not associated with the Student-Course database. These other tables are used in later exercises. Create synonyms for the tables in the Student-Course database because you will use them extensively. You can shorten the name of the table in your synonym, for example: CREATE SYNONYM d2m FOR Department_to_major; Using the synonyms and DESC, show the first few lines of all the tables in the Student-Course database. To display the column names and datatypes, use DESC. To display the first few lines of the table, use a WHERE on the table name like this: SELECT * FrOM student WHERE ROWNUM
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started