Question: Use the Registration create script to answer these questions. We will use the below area to write our test SQL . * * * *

Use the Registration create script to answer these questions.
We will use the below area to write our test SQL.
******************/
/*1) How would you add a grade attribute (Char with length 1)
to the Registration table? */
/*2) How would you remove Elliot's registration to INFO 1003?*/
/*DELETE*/
/*3) How would you create a new MathCourses table? */
/*4) How would you insert MATH1315 College Algebra to the MathCourses table? */
/*5) How would you show the rows of the MathCourses table to make sure you
inserted MATH1315 successfully? */
/*6) How would you remove the MathCourses table? */
/*7) Show which Section has the most registrations. */
/*8) Show which Student has the highest ID number. */
/*9) Show the Courses in alphabetical order by CourseID */
/*10) Which students are registered for a section? */
/*11) How many classes are each student registered for? */

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!