(Solved): Table1: Students - StudentiD (primary key) - Name - Age - Gender - Major Example data:
1. Create a ...
Table1: Students - StudentiD (primary key) - Name - Age - Gender - Major Example data:
1. Create a new table, newCourse, and populate it with Physics Department's book/books, using an existing table and a subquery, (15points) 2. Create a sequence "studentiD_seq" to generate StudentiD (for students table). Use "studentiD_seq" to add a new student. Then, add a new student:(15points) You can also write your descriptive comments along with your codes.
To create a new table, "newCourse", and populate it with Physics Department's book/books using an existing table and a subquery, we can use the following SQL code: